Google certshero free Associate-data-practitioner Updates by Norah q50 vce pdf

Page: 5 / 5

Google Associate-Data-Practitioner Exam Overview :

Exam Name:	Google Cloud Associate Data Practitioner ( ADP Exam )
Exam Code:	Associate-Data-Practitioner Dumps
Vendor:	Google	Certification:	Google Cloud Platform
Questions:	72 Q&A's	Shared By:	norah

Question 20

Your organization has a petabyte of application logs stored as Parquet files in Cloud Storage. You need to quickly perform a one-time SQL-based analysis of the files and join them to data that already resides in BigQuery. What should you do?

Options:

Create a Dataproc cluster, and write a PySpark job to join the data from BigQuery to the files in Cloud Storage.

Launch a Cloud Data Fusion environment, use plugins to connect to BigQuery and Cloud Storage, and use the SQL join operation to analyze the data.

Create external tables over the files in Cloud Storage, and perform SQL joins to tables in BigQuery to analyze the data.

Use the bq load command to load the Parquet files into BigQuery, and perform SQL joins to analyze the data.

Discussion

Question 21

You work for a healthcare company that has a large on-premises data system containing patient records with personally identifiable information (PII) such as names, addresses, and medical diagnoses. You need a standardized managed solution that de-identifies PII across all your data feeds prior to ingestion to Google Cloud. What should you do?

Options:

Use Cloud Run functions to create a serverless data cleaning pipeline. Store the cleaned data in BigQuery.

Use Cloud Data Fusion to transform the data. Store the cleaned data in BigQuery.

Load the data into BigQuery, and inspect the data by using SQL queries. Use Dataflow to transform the data and remove any errors.

Use Apache Beam to read the data and perform the necessary cleaning and transformation operations. Store the cleaned data in BigQuery.