Câu 56: Google Cloud Professional Data Engineer

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?

1. A. Create a separate table for each ID.
2. B. Use the LIMIT keyword to reduce the number of rows returned.
3. C. Recreate the table with a partitioning column and clustering column. — đáp án hiện tại
4. D. Use the bq query --maximum_bytes_billed flag to restrict the number of bytes billed.