data-engineer-pro video for scenario: A shipping company processes real-time package-tracking data sent to an Apache Kafka stream, which is then loaded into
Scenario: A shipping company processes real-time package-tracking data sent to an Apache Kafka stream, which is then loaded into BigQuery. Analysts need to query this data to analyze geospatial trends in the package lifecycle. The table is currently partitioned by the ingest date. However, query performance has slowed over time. The goal is to optimize the query performance by copying all the data into a new clustered table. Question: What action should you take to create a new clustered table in BigQuery for better query performance when analyzing geospatial trends in package tracking data?