You Have a Query That Filters a BigQuery Table Using

question 29

Multiple Choice

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?

• A) Create a separate table for each ID.
• B) Use the LIMIT keyword to reduce the number of rows returned.
• C) Recreate the table with a partitioning column and clustering column.
• D) Use the bq query - -maximum_bytes_billed flag to restrict the number of bytes billed. Use the bq query - -maximum_bytes_billed flag to restrict the number of bytes billed.

---

Definitions:

Standby Role

Describes a position or function where one is ready to engage or act but is not currently active.

Survivorship Care Plans

Individualized health care plans for cancer survivors that detail treatment received and outline follow-up care.

Cancer Screenings

Tests done to detect cancer before symptoms appear, aiming for early intervention.

Discharged

The process of formally releasing someone from a hospital or military service, or referring to the act of dispersing a substance.