
Ultimate access to all questions.
You are tasked with optimizing the structure of IoT sensor data stored in BigQuery for queries that frequently filter by location_id and device_version. Which data structuring strategy would best enhance both cost efficiency and performance?
A
Cluster table data by create_date, location_id, and device_version._
B
Partition table data by create_date, cluster table data by location_id, and device_version._
C
Partition table data by create_date, location_id, and device_version._
D
Cluster table data by create_date, partition by location_id, and device_version._