Google Professional Cloud Architect

Get started today

Ultimate access to all questions.

You need to design a BigQuery solution that allows for the deletion of individual health records to comply with data privacy regulations requiring data removal upon a subject's request. What is your recommended approach?

Exam-Like

Use a unique identifier for each individual. Upon a deletion request, delete all rows from BigQuery with this identifier.

100.0%

When ingesting new data in BigQuery, run the data through the Data Loss Prevention (DLP) API to identify any personal information. As part of the DLP scan, save the result to Data Catalog. Upon a deletion request, query Data Catalog to find the column with personal information.

Comments

Loading comments...

Create a BigQuery view over the table that contains all data. Upon a deletion request, exclude the rows that affect the subject's data from this view. Use this view instead of the source table for all analysis tasks.

0.0%

Use a unique identifier for each individual. Upon a deletion request, overwrite the column with the unique identifier with a salted SHA256 of its value.

0.0%