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

Question

Quizplus · Accepted Answer

The Answer of 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.)
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.

Your Company Has a Data Warehouse That Keeps Your Application