Exam Associate-Data-Practitioner Topic 1 Question 35 Discussion

Actual exam question for Google's Associate-Data-Practitioner exam
Question #: 35
Topic #: 1
You are working with a small dataset in Cloud Storage that needs to be transformed and loaded into BigQuery for analysis. The transformation involves simple filtering and aggregation operations. You want to use the most efficient and cost-effective data manipulation approach. What should you do?

Suggested Answer: A Vote an answer

Comprehensive and Detailed In-Depth Explanation:
For a small dataset with simple transformations (filtering, aggregation), Google recommends leveraging BigQuery's native SQL capabilities to minimize cost and complexity.
* Option A: Dataproc with Spark is overkill for a small dataset, incurring cluster management costs and setup time.
* Option B: BigQuery can load data directly from Cloud Storage (e.g., CSV, JSON) and perform transformations using SQL in a serverless manner, avoiding additional service costs. This is the most efficient and cost-effective approach.
* Option C: Cloud Data Fusion is suited for complex ETL but adds overhead (instance setup, UI design) unnecessary for simple tasks.

by Kyle at Dec 18, 2025, 09:39 AM

Limited Time Offer

15%

Off

Get Premium Associate-Data-Practitioner Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10