logo
Exam overview and study plan

Associate Data Practitioner Practice Questions

Associate Data Practitioner

Read questions, check verified answers and discuss the reasoning. Use reading options to shape your revision, or switch to the simulator for timed practice.

View 47 free questions

47 questions in this view

Page 1 of 8

Question 1

You are constructing a data pipeline to process sensitive customer data stored in a Cloud Storage bucket. You need to ensure that this data remains accessible, even in the event of a single-zone outage. What should you do?

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 2

You have a Cloud SQL for PostgreSQL database that stores sensitive historical financial data. You need to ensure that the data is uncorrupted and recoverable in the event that the primary region is destroyed. The data is valuable, so you need to prioritize recovery point objective (RPO) over recovery time objective (RTO). You want to recommend a solution that minimizes latency for primary read and write operations. What should you do?

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 3

Your team at a national retail chain trained a logistic regression model named cx.churn_model in BigQuery ML to estimate whether customers will cancel their loyalty subscriptions. The features used during training—tenure_months, avg_monthly_spend, and support_tickets—are available in the cx.active_customers table. You need to score every customer in this table so the customer experience team can send targeted, personalized offers. What should you do?

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 4

Your team runs a streaming Dataflow pipeline that reads from Pub/Sub, joins reference data, and writes to BigQuery. Downstream analysts report that BigQuery tables are showing records that are several hours behind the events being published, even though the job status in the console is still Running and no errors have been raised. You need to use the Dataflow jobs UI to identify which step in the pipeline is causing the lag. What should you do?

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 5

Your team manages a daily sales reporting process at a regional retailer. Raw transaction data lands in a BigQuery staging table throughout the day. The analytics team needs an aggregated summary table refreshed every morning at 06:00 UTC. The aggregation logic is a single SQL statement that overwrites the destination table with the latest results. You want a low-maintenance approach that runs the SQL on a recurring schedule directly within BigQuery, with built-in run history and minimal additional services. What should you do?

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 6

Your team at a European insurance company manages claim documents that must be retained for ten years to satisfy regulatory requirements. The documents are accessed less than once per year, almost exclusively for legal discovery. Auditors require that all retained data remain in EU regions and that no records can be deleted or overwritten before the retention period ends. You need to choose a Google Cloud archiving approach that meets the residency, immutability, and access-frequency requirements at the lowest storage cost. What should you do?

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.