Ultimate access to all questions.
A shipping company is streaming live package-tracking data to Apache Kafka, which is then loaded into BigQuery. Analysts are facing slower query processing times when analyzing geospatial trends in the package lifecycle, despite the table being initially partitioned by ingest-date. What is the most effective way to enhance query performance by transferring all data to a new clustered table in BigQuery?