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:

Balance Sheet

Rephrased: The balance sheet is a key financial statement that presents the assets, liabilities, and equity of a company, offering insight into its financial health at a particular moment.

Credits

Entries in accounting that increase liabilities or equity accounts, or decrease asset or expense accounts, reflecting transactions.

Debits

Entries in accounting that are used to record increases in assets or expenses and decreases in liabilities, equity, and revenue.

Capital Balance

The amount of money that a business or individual has invested in an entity, not including profits or losses from operations.