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 Google Cloud Storage files and create a BigQuery table using GCS as an external data source.
D) Re-create the table using data partitioning on the package delivery date.
Correct Answer:
Verified
Q149: You are analyzing the price of a
Q150: You need to deploy additional dependencies to
Q151: You work for a large bank that
Q152: You are building new real-time data warehouse
Q153: You need to choose a database to
Q155: You work for a financial institution that
Q156: You are designing a pipeline that publishes
Q157: You work for a mid-sized enterprise that
Q158: MJTelco Case Study Company Overview MJTelco is
Q159: You want to process payment transactions in
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