Exam Associate-Data-Practitioner Topic 1 Question 28 Discussion
Actual exam question for Google's Associate-Data-Practitioner exam
Question #: 28
Topic #: 1
Question #: 28
Topic #: 1
Your company wants to implement a data transformation (ETL) pipeline for their BigQuery data warehouse.
You need to identify a managed transformation solution that allows users to develop with SQL and JavaScript, has version control, allows for modular code, and has data quality checks. What should you do?
You need to identify a managed transformation solution that allows users to develop with SQL and JavaScript, has version control, allows for modular code, and has data quality checks. What should you do?
Suggested Answer: C Vote an answer
Comprehensive and Detailed in Depth Explanation:
Why C is correct:Dataform is a managed data transformation service that allows you to define data pipelines using SQL and JavaScript.
It provides version control, modular code development, and data quality checks.
Why other options are incorrect:A: Cloud Composer is an orchestration tool, not a data transformation tool.
B: Scheduled queries are not suitable for complex ETL pipelines.
D: Dataproc requires setting up a Spark cluster and writing code, which is more complex than using Dataform.
Why C is correct:Dataform is a managed data transformation service that allows you to define data pipelines using SQL and JavaScript.
It provides version control, modular code development, and data quality checks.
Why other options are incorrect:A: Cloud Composer is an orchestration tool, not a data transformation tool.
B: Scheduled queries are not suitable for complex ETL pipelines.
D: Dataproc requires setting up a Spark cluster and writing code, which is more complex than using Dataform.
by Gene at May 22, 2025, 10:46 PM
0
0
0
10
Comments
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.
Report Comment
Commenting
You can sign-up / login (it's free).