Trang chủ Professional Data Engineer 229 / 343
Quay lại bộ đề
Question #229 Topic 1
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 datetime value of the weather date. Set up partition expiration to 30 days.
C
Create a BigQuery table partitioned by ingestion time. 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.