You work for a healthcare company that has a large on-premises data system containing patient records with personally identifiable information (PII) such as names, addresses, and medical diagnoses. You need a standardized managed solution that de-identifies PII across all your data feeds prior to ingestion to Google Cloud. What should you do?

• A.Use Cloud Run functions to create a serverless data cleaning pipeline. Store the cleaned data in BigQuery.
• B.Use Cloud Data Fusion to transform the data. Store the cleaned data in BigQuery.
• C.Load the data into BigQuery, and inspect the data by using SQL queries. Use Dataflow to transform the data and remove any errors.
• D.Use Apache Beam to read the data and perform the necessary cleaning and transformation operations. Store the cleaned data in BigQuery.

Comment: *

Name: *

Email: *

Verification: *

You are a database administrator managing sales transaction data by region stored in a BigQuery table. You need to ensure that each sales representative can only see the transactions in their region. What should you do?

• A.Add a policy tag in BigQuery.
• B.Create a row-level access policy.
• C.Create a data masking rule.
• D.Grant the appropriate 1AM permissions on the dataset.

Comment: *

Name: *

Email: *

Verification: *

Your organization sends IoT event data to a Pub/Sub topic. Subscriber applications read and perform transformations on the messages before storing them in the data warehouse. During particularly busy times when more data is being written to the topic, you notice that the subscriber applications are not acknowledging messages within the deadline. You need to modify your pipeline to handle these activity spikes and continue to process the messages. What should you do?

• A.Retry messages until they are acknowledged.
• B.Implement flow control on the subscribers
• C.Forward unacknowledged messages to a dead-letter topic.
• D.Seek back to the last acknowledged message.

Comment: *

Name: *

Email: *

Verification: *

Your company is building a near real-time streaming pipeline to process JSON telemetry data from small appliances. You need to process messages arriving at a Pub/Sub topic, capitalize letters in the serial number field, and write results to BigQuery. You want to use a managed service and write a minimal amount of code for underlying transformations. What should you do?

• A.Use a Pub/Sub to BigQuery subscription, write results directly to BigQuery, and schedule a transformation query to run every five minutes.
• B.Use a Pub/Sub to Cloud Storage subscription, write a Cloud Run service that is triggered when objects arrive in the bucket, performs the transformations, and writes the results to BigQuery.
• C.Use the "Pub/Sub to BigQuery" Dataflow template with a UDF, and write the results to BigQuery.
• D.Use a Pub/Sub push subscription, write a Cloud Run service that accepts the messages, performs the transformations, and writes the results to BigQuery.

Comment: *

Name: *

Email: *

Verification: *

You are constructing a data pipeline to process sensitive customer data stored in a Cloud Storage bucket. You need to ensure that this data remains accessible, even in the event of a single-zone outage. What should you do?

• A.Set up a Cloud CDN in front of the bucket.
• B.Enable Object Versioning on the bucket.
• C.Store the data in a multi-region bucket.
• D.Store the data in Nearline storaqe.

Comment: *

Name: *

Email: *

Verification: *