Google
PROFESSIONAL-CLOUD-ARCHITECT · Question #202
You are working at a sports association whose members range in age from 8 to 30. The association collects a large amount of health data, such as sustained injuries. You are storing this data in…
The correct answer is A. Use a unique identifier for each individual. Upon a deletion request, delete all rows from BigQuery. A is the correct answer because it is easier to operate. The question is not how to mask data and so on but just to delete data on request, so I don't think that we have to use for just the deletion of specific data DLP.
Submitted by ngozi_ng· Mar 30, 2026Designing for security and compliance
Question
You are working at a sports association whose members range in age from 8 to 30. The association collects a large amount of health data, such as sustained injuries. You are storing this data in BigQuery. Current legislation requires you to delete such information upon request of the subject. You want to design a solution that can accommodate such a request. What should you do?
Options
- AUse a unique identifier for each individual. Upon a deletion request, delete all rows from BigQuery
- BWhen ingesting new data in BigQuery, run the data through the Data Loss Prevention (DLP) API
- CCreate a BigQuery view over the table that contains all data. Upon a deletion request, exclude the
- DUse a unique identifier for each individual. Upon a deletion request, overwrite the column with the
How the community answered
(48 responses)- A63% (30)
- B8% (4)
- C6% (3)
- D23% (11)
Explanation
A is the correct answer because it is easier to operate. The question is not how to mask data and so on but just to delete data on request, so I don't think that we have to use for just the deletion of specific data DLP.
Topics
#BigQuery#data deletion#GDPR compliance#right to erasure
Community Discussion
No community discussion yet for this question.