Exam Professional Cloud Developer topic 1 question 63 discussion

Second point "must be stored in a single region specifically for EU users " will achieve through option C only hence for me C and E is correct answer

Here's why the other options are less suitable: A. Use BigQuery federated queries to query data from Cloud Storage: Federated queries are useful for accessing data in other sources, but they don't solve the problem of storing EU user data in a specific region or providing a mechanism for deleting user data. C. Create a Cloud Storage bucket in the EU region to store information for EU users only: While Cloud Storage can be used for data storage, it's not the primary data warehouse for your application. You'd need to manage data movement between BigQuery and Cloud Storage, which adds complexity. D. Re-upload your data using to a Cloud Dataflow pipeline by filtering your user records out: This is a time-consuming and potentially disruptive process. It's not the most efficient way to handle user data deletion requests.

A is not a good solution because using BigQuery federated queries to query data from Cloud Storage does not address either of the requirements. Federated queries allow you to query data that is stored outside of BigQuery, such as in Cloud Storage, but they do not help you store data in a specific region or delete data upon request

C is not a good solution because creating a Cloud Storage bucket in the EU region does not address either of the requirements. A Cloud Storage bucket is simply a storage location, and it does not allow you to store data in a specific region or delete data upon request.

D is not a good solution because re-uploading your data using a Cloud Dataflow pipeline is unnecessarily complex and does not address either of the requirements. Filtering user records out during the re-upload process does not allow you to store data in a specific region or delete data upon request.