A company needs to ingest raw logs from Cloud Storage into BigQuery and then perform transformations that involve joining with reference data and computing daily aggregates. The transformations are complex and require iterative development. Which approach is most suitable?

Load raw logs into BigQuery, then use SQL views and scheduled queries for transformations.

Use Dataflow to transform the logs before loading into BigQuery.

Use Transfer Appliance to move logs to BigQuery and then use Cloud Functions to transform.

Use Cloud Data Fusion to clean and transform logs before loading.

A data engineer needs to load raw data into a cloud data warehouse and then apply transformations. The engineer wants to minimize the time-to-insight for exploratory analysis. Which approach best describes this order of operations?

ELT: Extract, Load, Transform — load raw data first, then transform it in the warehouse

ETL: Extract, Transform, Load — transform data before loading it into the warehouse

EL: Extract, Load — no transformation step

ETLT: Extract, Transform, Load, Transform — transform before and after loading

Google CloudAssociate Data Practitioner

Domain 1Objective 1

1.1 Prepare and Process Data ASSOCIATE-DATA-PRACTITIONER Practice Questions (Page 3)

Part of the Data Preparation and Ingestion domain, which accounts for ~30% of the ASSOCIATE-DATA-PRACTITIONER exam.

24questions here

5free pages

6concepts

~30%of the exam

Questions 11–15

11foundation · easy
In a Dataflow pipeline, which component is used to handle errors that occur during data processing, such as invalid records?
Select an answer first
12application · medium
A company needs to ingest raw logs from Cloud Storage into BigQuery and then perform transformations that involve joining with reference data and computing daily aggregates. The transformations are complex and require iterative development. Which approach is most suitable?
Select an answer first
13foundation · easy
A data engineer needs to load raw data into a cloud data warehouse and then apply transformations. The engineer wants to minimize the time-to-insight for exploratory analysis. Which approach best describes this order of operations?
Select an answer first
14foundation · easy
A data engineer wants to build a data cleaning pipeline that includes transformations and quality checks without writing code. Which Google Cloud service is designed for this?
Select an answer first
15foundation · easy
A data engineer needs to implement a data cleaning pipeline that processes streaming data and applies custom transformations. Which Google Cloud service is most appropriate?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to ASSOCIATE-DATA-PRACTITIONER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Google Cloud. “ASSOCIATE-DATA-PRACTITIONER” is a trademark of its owner, used for identification only.

1.1 Prepare and Process Data ASSOCIATE-DATA-PRACTITIONER Practice Questions (Page 3)

Questions 11–15

In a Dataflow pipeline, which component is used to handle errors that occur during data processing, such as invalid records?

A company needs to ingest raw logs from Cloud Storage into BigQuery and then perform transformations that involve joining with reference data and computing daily aggregates. The transformations are complex and require iterative development. Which approach is most suitable?

A data engineer needs to load raw data into a cloud data warehouse and then apply transformations. The engineer wants to minimize the time-to-insight for exploratory analysis. Which approach best describes this order of operations?

A data engineer wants to build a data cleaning pipeline that includes transformations and quality checks without writing code. Which Google Cloud service is designed for this?

A data engineer needs to implement a data cleaning pipeline that processes streaming data and applies custom transformations. Which Google Cloud service is most appropriate?

Keep studying — Data Preparation and Ingestion