medium10 pts · first answer countsdata-warehousingbigquerypartitioning

Stopping full scans of a big table

A 40 TB BigQuery events table is partitioned by event_date. Some users forget the date filter and scan everything. Which table option prevents this?

A.Set a default dataset expiryB.Turn on require_partition_filterC.Add a primary key on event_dateD.Switch the table to long-term storage

Discussion 0

Join free to post in the discussion.