Google Cloud Professional Cloud Developer — Question 50

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.)

Answer options

• A. Use BigQuery federated queries to query data from Cloud Storage.
• B. Create a dataset in the EU region that will keep information about EU users only.
• C. Create a Cloud Storage bucket in the EU region to store information for EU users only.
• D. Re-upload your data using to a Cloud Dataflow pipeline by filtering your user records out.
• E. Use DML statements in BigQuery to update/delete user records based on their requests.

Correct answer: B, E

Explanation

The correct actions are B and E. Creating a dataset in the EU region ensures compliance with data residency requirements for EU users, while using DML statements allows for the deletion of user records upon request. Options A, C, and D do not address the need for compliance with data deletion and regional storage specifically for EU users.