PROFESSIONAL-DATA-ENGINEER Question #391: Real Exam Question with Answer & Explanation

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?

Options

• 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
• BCreate a BigQuery table partitioned by ingestion time Set up partition expiration to 30 days.
• CCreate a BigQuery table partitioned by datetime value of the weather date 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