Google
PROFESSIONAL-DATA-ENGINEER · Question #182
You have a query that filters a BigQuery table using a WHERE clause on timestamp and ID columns. By using bq query -dry_run you learn that the query triggers a full scan of the table, even though the
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #182. The question stem and answer options stay visible for context.
Submitted by rania.sa· Mar 30, 2026Designing data processing systems
Question
You have a query that filters a BigQuery table using a WHERE clause on timestamp and ID columns. By using bq query -dry_run you learn that the query triggers a full scan of the table, even though the filter on timestamp and ID select a tiny fraction of the overall data. You want to reduce the amount of data scanned by BigQuery with minimal changes to existing SQL queries. What should you do?
Options
- ACreate a separate table for each ID.
- BUse the LIMIT keyword to reduce the number of rows returned.
- CRecreate the table with a partitioning column and clustering column.
- DUse the bq query - -maximum_bytes_billed flag to restrict the number of bytes billed.
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#BigQuery partitioning#BigQuery clustering#query optimization#cost reduction