Question 251 of 307
Single answerYou work for an airline and you need to store weather data in a BigQuery table. Weather data will be used as input to a machine learning model. The model only uses the last 30 days of weather data. You want to avoid storing unnecessary data and minimize costs. What should you do?
ACreate a BigQuery table where each record has an ingestion timestamp. Run a scheduled query to delete all the rows with an ingestion timestamp older than 30 days.
✓BCreate a BigQuery table partitioned by datetime value of the weather date. Set up partition expiration to 30 days.
CCreate a BigQuery table partitioned by ingestion time. Set up partition expiration to 30 days.
DCreate a BigQuery table with a datetime column for the day the weather data refers to. Run a scheduled query to delete rows with a datetime value older than 30 days.
✓
Correct Answer: B
Create a BigQuery table partitioned by datetime value of the weather date. Set up partition expiration to 30 days.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.