
Ultimate access to all questions.
As a data engineer tasked with managing and analyzing vast quantities of IoT sensor data collected from millions of devices worldwide, you are responsible for storing this data in BigQuery. The typical queries you will be running are primarily focused on accessing the most recent data, and these queries are filtered by location_id and device_version. In order to optimize these queries for both cost efficiency and performance, how should you structure your data in BigQuery?
A
Partition 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
Cluster table data by create_date, location_id, and device_version._
D
Cluster table data by create_date, partition by location_id, and device_version._