
Ultimate access to all questions.
A shipping company operates with real-time live package-tracking data, which is streamed into Apache Kafka and subsequently loaded into BigQuery. The company's analysts aim to query this tracking data within BigQuery to examine geospatial trends throughout a package's lifecycle. The original table was created using ingest-date partitioning. However, as time has progressed, the query processing time has significantly increased. Your task is to migrate all data to a new table that utilizes clustering. What steps should you take?
A
Re-create the table using data partitioning on the package delivery date.
B
Implement clustering in BigQuery on the package-tracking ID column.
C
Implement clustering in BigQuery on the ingest date column.
D
Tier older data onto Cloud Storage files and create a BigQuery table using Cloud Storage as an external data source.