ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Associate Data Practitioner All Questions

View all questions & answers for the Associate Data Practitioner exam
Go to Exam

Exam Associate Data Practitioner topic 1 question 4 discussion

Actual exam question from Google's Associate Data Practitioner
Question #: 4
Topic #: 1
[All Associate Data Practitioner Questions]

You want to process and load a daily sales CSV file stored in Cloud Storage into BigQuery for downstream reporting. You need to quickly build a scalable data pipeline that transforms the data while providing insights into data quality issues. What should you do?

  • A. Create a batch pipeline in Cloud Data Fusion by using a Cloud Storage source and a BigQuery sink.
  • B. Load the CSV file as a table in BigQuery, and use scheduled queries to run SQL transformation scripts.
  • C. Load the CSV file as a table in BigQuery. Create a batch pipeline in Cloud Data Fusion by using a BigQuery source and sink.
  • D. Create a batch pipeline in Dataflow by using the Cloud Storage CSV file to BigQuery batch template.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by trashbox at Jan. 22, 2025, 2:07 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
trashbox
2 weeks, 1 day ago
Selected Answer: A
Cloud Data Fusion enables us to build a scalable data pipeline from Cloud Storage to BigQuery. In addition, the service provides us an end-to-end data lineage for root cause and impact analysis.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago