PROFESSIONAL-DATA-ENGINEER · Question #182
PROFESSIONAL-DATA-ENGINEER Question #182: Real Exam Question with Answer & Explanation
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.
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.