GCP-ADP Data Analysis And Presentation Practice Question
You have a query that processes 500GB of data. You want to reduce the cost of this query. What is the most effective approach?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Add a WHERE clause to filter by the partitioned column.
Filtering by partition columns drastically reduces the amount of data scanned, directly lowering the cost.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use a smaller machine type for the project.
Why it's wrong here
BigQuery is serverless; you don't control the machine size.
- ✗
Increase the query timeout limit.
Why it's wrong here
This does not reduce the data scanned or the cost.
- ✗
Switch to BigQuery Omni.
Why it's wrong here
Omni is for multi-cloud queries and does not reduce cost.
- ✓
Add a WHERE clause to filter by the partitioned column.
Why this is correct
Limiting the data scanned is the primary cost-saving technique in BigQuery.
About these practice questions
This GCP-ADP question is part of Courseiva's 205-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed August 2026 · checked against the official Google Cloud exam blueprint
This GCP-ADP practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the GCP-ADP exam.