
Ultimate access to all questions.
A shipping company is streaming live package-tracking data to Apache Kafka, which is then loaded into BigQuery. Analysts are facing slower query processing times when analyzing geospatial trends in the package lifecycle, despite the table being initially partitioned by ingest-date. What is the most effective way to enhance query performance by transferring all data to a new clustered table in BigQuery?
A
Tier older data onto Cloud Storage files and create a BigQuery table using Cloud Storage as an external data source.
B
Implement clustering in BigQuery on the package-tracking ID column.
C
Re-create the table using data partitioning on the package delivery date.
D
Implement clustering in BigQuery on the ingest date column.