
Ultimate access to all questions.
A shipping company streams live package-tracking data to an Apache Kafka stream in real time, which is subsequently loaded into BigQuery. The analysts in your company aim to query this tracking data in BigQuery to analyze geospatial trends throughout the lifecycle of a package. The table holding this data was initially created with ingest-date partitioning. However, the query processing time has gradually increased. To enhance the performance of queries in BigQuery, what should you do?
A
Implement clustering in BigQuery on the ingest date column.
B
Implement clustering in BigQuery on the package-tracking ID column.
C
Tier older data onto Cloud Storage files and create a BigQuery table using Cloud Storage as an external data source.
D
Re-create the table using data partitioning on the package delivery date.