# Free GADP practice questions

> 10 free GADP practice questions with the correct answer and an explanation.

Page: https://devopscodelab.com/exams/google-associate-data-practitioner/free-practice-questions/
Practice exams: https://devopscodelab.com/exams/google-associate-data-practitioner/

### Question 1 of 10

A company must ingest data nightly from an on-premises Oracle database and a Salesforce instance, apply joins and lookups, and load BigQuery. The team prefers prebuilt connectors and a visual designer, and it needs pipeline lineage. Which service should it use?

- A. BigQuery Data Transfer Service
- B. Serverless for Apache Spark batches
- C. Cloud Data Fusion
- D. Datastream

**Answer:** C

**Explanation:** Cloud Data Fusion offers a visual designer with a large library of prebuilt connectors, including databases and SaaS sources, supports joins and lookups, and tracks lineage. Datastream replicates database changes but does not join with Salesforce, the Data Transfer Service loads supported sources without custom joins, and Serverless for Apache Spark (formerly Dataproc Serverless) requires writing Spark code.

### Question 2 of 10

A manufacturer ingests millions of sensor readings per second and needs single-digit millisecond reads of recent readings by device ID and timestamp. Which storage service should it choose?

- A. Firestore with one document per reading in a device collection
- B. BigQuery with the readings table partitioned by ingestion day
- C. Cloud SQL for PostgreSQL with an index on device ID and time
- D. Bigtable with a row key that combines device ID and timestamp

**Answer:** D

**Explanation:** Bigtable handles very high write throughput with low-latency lookups by row key, and a device-plus-timestamp key supports fast range scans per device. BigQuery is optimized for analytical scans rather than millisecond point reads, Cloud SQL cannot absorb millions of writes per second on one instance, and Firestore is a document store aimed at application data rather than massive time-series ingestion.

### Question 3 of 10

A company has 30 TB of files on an on-premises NFS share and a dedicated 10 Gbps Cloud Interconnect with plenty of spare capacity. It wants a managed, resumable transfer to Cloud Storage with integrity checks. Which option should it use?

- A. Transfer Appliance, because any dataset over 10 TB must ship offline
- B. Database Migration Service configured with the share as a source
- C. BigQuery Data Transfer Service scheduled against the NFS share path
- D. Storage Transfer Service for on-premises data using transfer agents

**Answer:** D

**Explanation:** With 10 Gbps of spare bandwidth, 30 TB can move online in well under two days, and Storage Transfer Service agents provide managed, resumable transfers with checksums. Transfer Appliance makes sense when bandwidth is the bottleneck, not at a fixed size, BigQuery Data Transfer Service loads into BigQuery from supported sources, and Database Migration Service migrates databases rather than file shares.

### Question 4 of 10 (choose 2)

A fraud model in BigQuery ML is trained on data where only 0.5% of transactions are fraudulent, and it predicts 'not fraud' for nearly everything. Which two actions help? (Choose two.)

- A. Remove all fraudulent rows so the model trains on clean data only
- B. Set auto_class_weights to TRUE when creating the model
- C. Evaluate with precision, recall, and ROC AUC instead of accuracy
- D. Raise the classification threshold so fewer rows are flagged
- E. Use ARIMA_PLUS so the model learns fraud trends over time

**Answer:** B, C

**Explanation:** Class weighting makes errors on the rare class count more during training, and metrics such as precision, recall, and ROC AUC reveal performance on the minority class that accuracy hides. Removing fraud rows eliminates the class the model must learn, ARIMA_PLUS forecasts time series rather than classifying transactions, and raising the threshold flags even fewer frauds.

### Question 5 of 10

A support team wants to summarize thousands of customer comments stored in a BigQuery table using a Google Gemini model, without moving the data out of BigQuery or writing application code. What should the data practitioner do?

- A. Export the comments to Cloud Storage and run a Dataflow pipeline that sends each comment to the Gemini API for summarization
- B. Train a BigQuery ML boosted tree classifier on the comments and use ML.PREDICT to output a summary per row
- C. Create a remote model over a Vertex AI Gemini endpoint through a BigQuery connection and call ML.GENERATE_TEXT
- D. Use the Natural Language API sentiment analysis from a Cloud Run function triggered on each new comment row

**Answer:** C

**Explanation:** BigQuery ML remote models connect to Vertex AI Gemini endpoints through a Cloud resource connection, and ML.GENERATE_TEXT runs prompts over table rows using SQL. A boosted tree classifier predicts labels and cannot write summaries, a Dataflow export pipeline moves data and requires code, and sentiment analysis scores tone rather than producing summaries.

### Question 6 of 10

A model trained in BigQuery ML shows 98% accuracy on its training data but only 71% on the evaluation data. What is the MOST likely cause, and what should the practitioner do first?

- A. The model is underfitting; add many more input features and iterations
- B. The model is overfitting; add regularization or simplify the features
- C. The evaluation data is mislabeled; train again using the evaluation rows
- D. The split is random; switch to a fixed split with no evaluation set

**Answer:** B

**Explanation:** A large gap between training and evaluation performance is the classic sign of overfitting, which regularization or simpler features help address. Underfitting shows poor performance on both sets, retraining on the evaluation rows would remove the ability to measure generalization, and removing the evaluation set hides the problem rather than fixing it.

### Question 7 of 10

A team needs to chain a few serverless steps: call an external REST API, start a BigQuery job, wait for it, and call a Cloud Run service with the result. They want a lightweight, pay-per-use orchestrator with no environment to manage. Which service should they choose?

- A. Workflows
- B. Dataproc workflow templates
- C. Cloud Composer
- D. Dataflow

**Answer:** A

**Explanation:** Workflows is a serverless orchestrator for sequencing HTTP-based service calls, including Google Cloud APIs, with pay-per-step pricing and no environment. Cloud Composer runs a persistent Airflow environment that is heavier than needed, Dataproc workflow templates orchestrate jobs on a Dataproc cluster, and Dataflow is a data processing engine rather than an API orchestrator.

### Question 8 of 10

A team runs a sequence of dependent Spark jobs that should create a managed Dataproc cluster, run the jobs in order, and delete the cluster afterward, all defined in one reusable YAML resource. What should they use?

- A. A scheduled query that calls the Spark jobs
- B. A Dataproc workflow template with a managed cluster
- C. A Cloud Scheduler job that submits each Spark job directly
- D. An Eventarc trigger on the Dataproc cluster creation

**Answer:** B

**Explanation:** Dataproc workflow templates define a DAG of jobs and can create an ephemeral managed cluster, run the jobs in order, and delete it when done. Cloud Scheduler alone does not manage dependencies or cluster lifecycle, scheduled queries run SQL rather than orchestrating Spark jobs on a cluster, and an Eventarc trigger reacts to events but does not define a job sequence.

### Question 9 of 10

A compliance team keeps audit logs in Cloud Storage. The logs are rarely read after the first month but must be retained for seven years at the lowest storage cost. Which configuration is MOST cost-effective?

- A. A lifecycle rule that moves objects to Archive storage after 30 days
- B. A lifecycle rule that moves objects to Nearline storage after 30 days
- C. Enabling Autoclass so that objects are moved to Coldline after 30 days
- D. Keeping objects in Standard storage with versioning enabled

**Answer:** A

**Explanation:** Archive storage has the lowest at-rest price and suits data kept for years and almost never read, so a SetStorageClass rule to Archive after 30 days is cheapest. Nearline costs more per GB and targets roughly monthly access, Standard with versioning is the most expensive option, and Autoclass moves objects based on access patterns, reaching Coldline only after 90 days without access and Archive only after a year, so it is slower to reach the cheapest tier.

### Question 10 of 10

A company stores critical data in a dual-region Cloud Storage bucket and needs a guaranteed recovery point objective of 15 minutes for newly written objects if one region fails. What should it enable?

- A. A second bucket in a different multi-region
- B. Autoclass with Standard as the starting class
- C. Object versioning plus soft delete
- D. Turbo replication on the dual-region bucket

**Answer:** D

**Explanation:** Turbo replication provides a 15-minute RPO for objects written to dual-region buckets, compared with default replication that targets most objects within an hour and all within 12 hours. Versioning and soft delete protect against deletion, not regional loss, a second bucket needs a copy process with no RPO guarantee, and Autoclass changes storage classes rather than replication speed.

Ready for a timed run? Take the free 15-question GADP mini exam: https://devopscodelab.com/app/exams/google-associate-data-practitioner/mini/

DevOpsCode Lab is not affiliated with Google Cloud. GADP and related names are trademarks of their owners. We write every question ourselves; these are not real exam questions.
