Professional Cloud Developer · Free Practice Question Medium
Question 18
Your organization utilizes a 2 PBs data warehouse in BigQuery to maintain application data. To comply with EU regulations, the company has expanded its user base to include EU users and must adhere to the following regulations:
✑ The company should have the capability to delete all user account information as per user requests.
✑ All EU user data must be stored in a region designated for EU users.
Please choose two options.
What are the two recommended actions you should take?
- A Use DML statements in BigQuery to modify user records according to their requests.
- B Re-upload your data using to a Cloud Dataflow pipeline by filtering out user records.
- C Use BigQuery federated queries to query data from Cloud Storage.
- D Create a dataset in the EU region that will keep information about EU users only.
- E Create a Cloud Storage bucket in the EU region to store information for EU users only.
Reveal correct answers
Correct answers: A, D
Explanation
To comply with EU regulations, two actions should be taken. Firstly, a dataset in the EU region should be created to store information about EU users only. This will ensure that all EU user data is stored in a single region specifically for EU users. Secondly, DML statements in BigQuery should be used to update or delete user records based on their requests. This will ensure that all user account information can be deleted upon user request, which is a requirement for compliance. According to the Professional Google Cloud Developer documentation, a dataset is bound to a location, and the dataset locations include multi-regional areas, such as the United States, that contain two or more geographic places. Therefore, creating a dataset in the EU region will ensure compliance with EU regulations. Additionally, using DML statements in BigQuery will allow for the efficient deletion of user account information upon request.Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
