Ultimate access to all questions.
A shipping company streams live package-tracking data to an Apache Kafka stream in real time, which is subsequently loaded into BigQuery. The analysts in your company aim to query this tracking data in BigQuery to analyze geospatial trends throughout the lifecycle of a package. The table holding this data was initially created with ingest-date partitioning. However, the query processing time has gradually increased. To enhance the performance of queries in BigQuery, what should you do?