Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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?
location_id
device_version
A
Cluster table data by create_date, location_id, and device_version.
create_date
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.
