Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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.