Topic 1 Question 99
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?
Create a separate table for each ID.
Use the LIMIT keyword to reduce the number of rows returned.
Recreate the table with a partitioning column and clustering column.
Use the bq query --maximum_bytes_billed flag to restrict the number of bytes billed.
ユーザの投票
コメント(17)
- 👍 42rickywck2020/03/17
Correct - C
👍 17[Removed]2020/03/22Are they having a laugh at us by giving so many bad answers?
👍 5Crudgey2021/11/09
シャッフルモード