As a data engineer for an airline, you're tasked with efficiently storing weather data in BigQuery for a machine learning model that only uses the most recent 30 days of data. What's the best approach to minimize costs and avoid storing unnecessary data?

Real Exam

Create a BigQuery table with a datetime column for the weather date. Schedule a query to delete rows older than 30 days.

0.0%

Create a BigQuery table partitioned by the weather date's datetime value and set partition expiration to 30 days.

75.0%

Create a BigQuery table where each record has an ingestion timestamp. Schedule a query to delete rows older than 30 days.

12.5%

Create a BigQuery table partitioned by ingestion time and set partition expiration to 30 days.

12.5%

Google Professional Data Engineer