ADP sample questions with answers
The other 92 questions are in the practice tool, with answers revealed as you go.
Start 20 questionsData preparation and ingestion
- A data scientist wants to run SQL in BigQuery over Parquet files that remain in a Cloud Storage bucket, with no copy made into BigQuery storage. Which table type supports this?
- A telemetry service pushes rows into BigQuery through the streaming API. After a client library retry, some events appear twice in the destination table. Which field in the streaming request helps BigQuery suppress such repeats on a best-effort basis?
Data analysis and presentation
- Which statement correctly distinguishes Looker from Looker Studio?
- A reporting team wants to join a live customer table in a Cloud SQL for PostgreSQL instance with BigQuery sales data, without copying the customer table into BigQuery. Which capability should it use?
- A FinOps analyst needs the top spenders by compute usage over the last week, broken down by user and by job, using BigQuery metadata. Which source provides per-job compute totals?
Data pipeline orchestration
Data management
- A healthcare analytics team keeps all clinic visits in one BigQuery table. Each regional manager should see only their own region's rows, and the team does not want copies of the table. Which DDL statement defines that restriction on the table itself?
- A healthcare company stores patient records in BigQuery. Auditors worry that an insider with valid credentials could copy the data to a personal project outside the company. Which control creates a boundary that blocks such copies even when IAM permits access?