Google Exam Associate Data Practitioner Topic 3 Question 9 Discussion

Actual exam question for Google's Associate Data Practitioner exam

Question #: 9
Topic #: 3

[All Associate Data Practitioner Questions]

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?

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

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

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

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

Show Suggested Answer

Suggested Answer: C

Creating external tables over the Parquet files in Cloud Storage allows you to perform SQL-based analysis and joins with data already in BigQuery without needing to load the files into BigQuery. This approach is efficient for a one-time analysis as it avoids the time and cost associated with loading large volumes of data into BigQuery. External tables provide seamless integration with Cloud Storage, enabling quick and cost-effective analysis of data stored in Parquet format.

by Lavonne at Mar 19, 2025, 09:39 AM

Limited Time Offer

25%

26 days ago

Cloud Data Fusion seems like the easiest way to get this done. No need to write any code!

upvoted 0 times

Sarah

8 days ago

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

upvoted 0 times

...

Sommer

1 months ago

I think option A sounds like a good idea.

upvoted 0 times

...