FirstTry

Objective 1.2

ADP

Extract and load data into appropriate Google Cloud storage systems

Objective 1.2 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.

1-2Data Preparation and Ingestion

A workload needs a serverless data warehouse for SQL analytics over terabytes with no infrastructure to manage. Which storage system fits?

BigtableBigtable is a NoSQL key-value store, not a SQL analytics warehouse.
FilestoreFilestore provides network file storage, not SQL analytics.
Cloud SQLCloud SQL is a transactional relational database, not a warehouse for analytics at scale.
BigQueryCorrect · your answerCorrect.

Correct.

Concept

Analytical warehouses separate storage from compute and run SQL at scale without server management. Matching workload type to storage system is a core selection skill.

Why D

BigQuery is a serverless data platform for SQL analytics at terabyte and petabyte scale.

Source

BigQuery's serverless architecture lets you use languages like SQL and Python to answer your organization's biggest questions with zero infrastructure management.

Google Cloud, BigQuery overview, checked August 2026
#1-2

Now you: objective 1.2 questions

No account needed. The explanation opens when you answer.

Sample question 1 of 3

1-2Data Preparation and Ingestion

You need to load data into BigQuery from a script running in a CI job without opening the console. Which tools are appropriate?

Sample question 2 of 3

1-2Data Preparation and Ingestion

You must classify incoming JSON event records that have keys and nested fields but no fixed relational schema. How is this data best described?

Sample question 3 of 3

1-2Data Preparation and Ingestion

Which storage system uses a serverless architecture that separates a storage layer from a compute layer?

That’s 3 of the full Associate Data Practitioner bank.

Keep going free: 10 questions per certification in bank practice, with no account.

Continue practising

Read 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.

More objectives in Data Preparation and Ingestion