solutions-architect-pro video for scenario: Your applications are configured to write logs to BigQuery for analysis. It is required that each application has
Scenario: Your applications are configured to write logs to BigQuery for analysis. It is required that each application has its own table, and logs older than 45 days should be deleted to optimize storage and adhere to Google's best practices. Question: What steps should be taken to ensure each application has its own table in BigQuery and to remove logs older than 45 days for storage optimization and compliance with Google's recommendations?