Topic 1 Question 63
2 つ選択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?
Use BigQuery federated queries to query data from Cloud Storage.
Create a dataset in the EU region that will keep information about EU users only.
Create a Cloud Storage bucket in the EU region to store information for EU users only.
Re-upload your data using to a Cloud Dataflow pipeline by filtering your user records out.
Use DML statements in BigQuery to update/delete user records based on their requests.
ユーザの投票
コメント(9)
B and E is correct answer for me.
👍 10saurabh18052020/11/11https://cloud.google.com/bigquery/docs/reference/standard-sql/data-manipulation-language The link above supports E since "delete all user account information upon user request" as per qn
https://cloud.google.com/architecture/bigquery-data-warehouse: "A dataset is bound to a location. The dataset locations are as follows: Multi-regional: A large geographic area, such as the United States, that contains two or more geographic places."
B is the other answer
👍 5syu31svc2021/07/09B & E. Data is already stored in BigQuery, I do not see any reason to have anything to do with Cloud Storage. Also, BigQuery allows DML to do updates and deletes. So I would choose B & E
👍 2Gini2021/11/30
シャッフルモード