Topic 1 Question 309
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?
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.
Create a BigQuery table partitioned by datetime value of the weather date. Set up partition expiration to 30 days.
Create a BigQuery table partitioned by ingestion time. Set up partition expiration to 30 days.
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.
ユーザの投票
コメント(7)
- 正解だと思う選択肢: B
Partitioned based on weather date, with partition expiration set
👍 6AllenChen1232024/01/25 - 正解だと思う選択肢: B
got this one on the exam, aug 2024, passed
👍 6iooj2024/08/04 - 正解だと思う選択肢: B
We need the last 30 days, we don't care about ingestion time
👍 4Sofiia982024/02/02
シャッフルモード