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…

Question

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

• A
  6% (3)
• B
  88% (43)
• C
  2% (1)
• D
  4% (2)

Explanation

Explanation/Reference: Partitioning a table by ingestion time means that the data is divided into partitions based on the time when the data was loaded into the table. This allows you to delete or archive old data by setting a partition expiration policy. You can specify the number of days to keep the data in each partition, and BigQuery automatically deletes the data when it expires. This way, you can avoid storing unnecessary data and minimize costs.

No community discussion yet for this question.