PROFESSIONAL-CLOUD-DEVELOPER · Question #11
Your company has a data warehouse that keeps your application information in BigQuery. The BigQuery data warehouse keeps 2 PBs of user data. Recently, your company expanded your user base to include E
The correct answer is B. Create a dataset in the EU region that will keep information about EU users only. E. Use DML statements in BigQuery to update/delete user records based on their requests.. Two requirements must be met: (1) EU user data must reside in an EU region, and (2) the company must be able to delete individual user records on request. Option B directly addresses the data residency requirement-BigQuery datasets are region-specific, so creating a new dataset i
Question
Your company has a data warehouse that keeps your application information in BigQuery. The BigQuery data warehouse keeps 2 PBs of user data. Recently, your company expanded your user base to include EU users and needs to comply with these requirements:
- Your company must be able to delete all user account information upon
user request.
- All EU user data must be stored in a single region specifically for
EU users. Which two actions should you take? (Choose two.)
Options
- AUse BigQuery federated queries to query data from Cloud Storage.
- BCreate a dataset in the EU region that will keep information about EU users only.
- CCreate a Cloud Storage bucket in the EU region to store information for EU users only.
- DRe-upload your data using to a Cloud Dataflow pipeline by filtering your user records out.
- EUse DML statements in BigQuery to update/delete user records based on their requests.
How the community answered
(37 responses)- A3% (1)
- B84% (31)
- C5% (2)
- D8% (3)
Explanation
Two requirements must be met: (1) EU user data must reside in an EU region, and (2) the company must be able to delete individual user records on request. Option B directly addresses the data residency requirement-BigQuery datasets are region-specific, so creating a new dataset in a European region (e.g., eu or europe-west1) ensures EU user data never leaves that region. Option E addresses the deletion requirement-BigQuery supports DML statements (DELETE and UPDATE), so individual user rows can be targeted and removed in response to erasure requests, satisfying GDPR's right to be forgotten. Option A (federated queries from Cloud Storage) does not change where data lives and adds complexity. Option C (Cloud Storage bucket in EU) is redundant if data is already in a BigQuery EU dataset and doesn't address the deletion workflow. Option D (a Dataflow pipeline to filter records) is an overly complex, batch-oriented approach to what DML can accomplish directly.
Topics
Community Discussion
No community discussion yet for this question.