Free PROFESSIONAL-DATA-ENGINEER Web TestEngine Demo

Q39 Single choice

You 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?

A
Create 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.
B
Create a BigQuery table partitioned by ingestion time Set up partition expiration to 30 days.
C
Create a BigQuery table partitioned by datetime value of the weather date Set up partition expiration to
30 days.
D
Create 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.

PROFESSIONAL-DATA-ENGINEER Web TestEngine demo