A company wants to load raw JSON files from Cloud Storage into BigQuery and then perform transformations like joining with dimension tables and aggregating metrics. The transformations are complex and require multiple SQL statements. Which approach best fits this requirement?

Use Dataflow to transform data in memory and then write to BigQuery.

Load raw JSON into BigQuery, then use SQL views or scheduled queries to transform the data.

Use Cloud Data Fusion to transform data before loading into BigQuery.

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

A data engineer is using Cloud Data Fusion to build a pipeline that cleans a dataset containing customer records. The pipeline must remove rows with missing email addresses, standardize state codes to uppercase, and flag records where the age is above 120 as outliers. Which combination of plugins should be used?

Condition, Deduplicate, and GroupBy

Filter, Wrangler, and Validator

Joiner, Aggregator, and Splitter

Google CloudAssociate Data Practitioner

Domain 1Objective 1

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

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 1–5

1application · medium
A company wants to load raw JSON files from Cloud Storage into BigQuery and then perform transformations like joining with dimension tables and aggregating metrics. The transformations are complex and require multiple SQL statements. Which approach best fits this requirement?
Select an answer first
2foundation · easy
A company needs to transfer 500 TB of on-premises data to Google Cloud. The network bandwidth is limited to 100 Mbps, and the transfer must complete within two weeks. Which tool is most appropriate for this scenario?
Select an answer first
3application · medium
A data engineer is using Cloud Data Fusion to build a pipeline that cleans a dataset containing customer records. The pipeline must remove rows with missing email addresses, standardize state codes to uppercase, and flag records where the age is above 120 as outliers. Which combination of plugins should be used?
Select an answer first
4foundation · easy
A data analyst needs to filter out rows where the 'status' column is NULL from a BigQuery table. Which SQL condition should be used in the WHERE clause?
Select an answer first
5foundation · easy
During data quality assessment, a data engineer finds that the 'age' column contains values like 150, 200, and 300. Which data quality issue is most likely present?
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 1)

Questions 1–5

A company wants to load raw JSON files from Cloud Storage into BigQuery and then perform transformations like joining with dimension tables and aggregating metrics. The transformations are complex and require multiple SQL statements. Which approach best fits this requirement?

A company needs to transfer 500 TB of on-premises data to Google Cloud. The network bandwidth is limited to 100 Mbps, and the transfer must complete within two weeks. Which tool is most appropriate for this scenario?

A data analyst needs to filter out rows where the 'status' column is NULL from a BigQuery table. Which SQL condition should be used in the WHERE clause?

During data quality assessment, a data engineer finds that the 'age' column contains values like 150, 200, and 300. Which data quality issue is most likely present?

Keep studying — Data Preparation and Ingestion