Objective 1.1
ADPPrepare and process data
Objective 1.1 sits in Data Preparation and Ingestion, which carries 30% of the Associate Data Practitioner exam. The questions below are original, written from the official objective title above, and each explanation cites the Google Cloud page it rests on.
Objective title verbatim from the official objectives. Google Cloud exam page ↗
A worked example
Shown solved, with the whole explanation open: this is what every question here carries.
A team lands raw files in Cloud Storage, then loads them into BigQuery and runs SQL to reshape them inside the warehouse. Which pattern is this?
Correct.
Concept
ETL processes data before loading it; ELT loads raw data first and processes it in the destination system. The order of load and transformation defines the pattern.
Why C
Loading raw data into BigQuery and reshaping it there with SQL processes after the load, which is the ELT pattern.
Source
Google Cloud, Dataform overview, checked August 2026Dataform lets you manage data transformation in the Extraction, Loading, and Transformation (ELT) process for data integration.
Now you: objective 1.1 questions
No account needed. The explanation opens when you answer.
Sample question 1 of 3
A team runs SQL inside BigQuery to filter, deduplicate, and correct values after loading raw exports. This work is best described as which step?
Sample question 2 of 3
You want version-controlled SQL definitions in BigQuery with managed dependencies and automated data quality tests during preparation. Which service provides this?
Sample question 3 of 3
Messages arrive on Pub/Sub and must land in BigQuery unchanged, and the team wants to avoid running and maintaining a separate processing job. What should they use?
That’s 3 of the full Associate Data Practitioner bank.
Keep going free: 10 questions per certification in bank practice, with no account.
Continue practisingRead the sources
These are the official pages the questions above cite. Reading them is studying the objective from the primary source, which is what the explanations point you toward anyway.