ADP Question 20

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A2

  When you set table-level retention (an expiration time) for a BigQuery table, it means the entire table will expire and be deleted at that specified time. This includes all data within the table, regardless of when that specific data was added. In order for only 7 year old data to expire we need to set up partitions and expire partitions

• 1

  and how, in option A, do prevent a user with the necessary permissions from running a DELETE?

• Chose D1

  Not A because does not prevent a user with the necessary permissions from running a DELETE Not B because there ir no table-level retention policy (different than table expiration and fail-safe period) Not C because there ir no dataset-level retention policy