Applications write logs to BigQuery with a separate table per application; logs older than 45 days must be removed and storage optimized. What should you do?

Making tables time-partitioned and configuring partition expiration at 45 days is the most efficient and cost-effective solution. BigQuery automatically deletes data in expired partitions, ensuring logs older than 45 days are removed and optimizing storage without manual intervention. Configuring the expiration time for the entire table would delete all data, not just old logs. Relying on BigQuery's default behavior is incorrect as BigQuery does not automatically prune data based on age without explicit configuration. Creating a script to remove records is less efficient, more complex to maintain, and incurs query costs for deletions, making it a less optimal choice compared to native partitioning.