Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
What strategies can enhance query performance in BigQuery for analyzing geospatial trends within a package-tracking data table that utilizes ingest-date partitioning and originates from an Apache Kafka stream?
A
Implement clustering in BigQuery on the package-tracking ID column to organize data efficiently.
B
Opt for clustering in BigQuery based on the ingest date column to streamline data retrieval.
C
Leverage an external data source by archiving older data to Cloud Storage files and establishing a new table.
D
Reconstruct the table with data partitioning focused on the package delivery date for optimized query execution.
