A shipping company has live package-tracking data that is sent to an Apache Kafka stream in real time. This is then loaded into BigQuery. Analysts in your company want to query the tracking data in BigQuery to analyze geospatial trends in the lifecycle of a package. The table was originally created with ingest-date partitioning. Over time, the query processing time has increased. You need to implement a change that would improve query performance 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 leverage extended tables.
D) Re-create the table using data partitioning on the package delivery date.
Correct Answer:
Verified
Q83: You decided to use Cloud Datastore to
Q84: You operate a database that stores stock
Q85: A data scientist has created a BigQuery
Q86: You are creating a new pipeline in
Q87: You are building an application to share
Q89: Your United States-based company has created an
Q90: You are operating a Cloud Dataflow streaming
Q91: You are managing a Cloud Dataproc cluster.
Q92: You are a retailer that wants to
Q93: The marketing team at your organization provides
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents