Google Cloud Professional Data Engineer PDE — Topic 1 Question 309

Question

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?

Accepted Answer

Correct answer: B. The correct answer is B. Option B: Create a BigQuery table partitioned by datetime value of the weather date. Set up partition expiration to 30 days. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage. This option delivers the requirement at the lowest cost.

Google Cloud Professional Data Engineer PDE — Question 309