Your Company Has a Data Warehouse That Keeps Your Application

question 50

Multiple Choice

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.

---

Definitions:

Pressure

The sensation of physical force being applied to an object or a feeling of stress and urgency induced by the demands and expectations of others.

Somatic Pain

Pain that originates from the skin, muscles, bones, or connective tissues, usually localized and easier to pinpoint than visceral pain.

Deep Ache

A profound or intense pain that is often felt at deeper bodily structures or tissues.

Life Expectancy

The statistical measure of the average time an organism is expected to live, based on factors like genetics, lifestyle, and environment at the time of birth.