You store 2 PB in BigQuery and now must: 1) delete any user account data on request, and 2) keep all EU user data in a single EU region. Which two actions address these requirements? (Select two.)
Choose an answer
Tap an option to check your answer.
Correct answer: Create a BigQuery dataset in an EU region to contain EU-user data only., Use BigQuery DML to update/delete user records when requested..
Why this is the answer
To address the requirement of keeping all EU user data in a single EU region, creating a BigQuery dataset in an EU region specifically for EU-user data is the correct approach. BigQuery datasets are regional resources, ensuring data residency. For deleting user account data on request, BigQuery Data Manipulation Language (DML) statements (specifically DELETE statements) allow for precise record removal, fulfilling the "right to be forgotten" requirement. Using federated queries or Cloud Storage buckets alone does not directly address BigQuery data residency or in-place deletion. Re-uploading data with Dataflow is inefficient and not suitable for on-demand deletions.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed