Answer-first summary for fast verification
Answer: In a BigQuery dataset that is viewable only by authorized personnel, with the Data Access log used to provide the auditability.
The correct answer is B. Storing the data in a BigQuery dataset that is viewable only by authorized personnel ensures control over who can access the data. Additionally, BigQuery provides built-in Data Access logs, which capture details such as the user's identity, the specific query run, and the time of the query. These logs provide a comprehensive audit trail for compliance purposes, making BigQuery a suitable option for maintaining an auditable record as mandated by government regulations.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Government regulations in your industry mandate that you maintain an auditable record of access to certain types of sensitive data, ensuring that every access event is logged and can be reviewed in the future for compliance and auditing purposes. Given that all expiring logs will be archived correctly according to these regulations, where should you store the data that is subject to this mandate to ensure compliance and security?
A
Encrypted on Cloud Storage with user-supplied encryption keys. A separate decryption key will be given to each authorized user.
B
In a BigQuery dataset that is viewable only by authorized personnel, with the Data Access log used to provide the auditability.
C
In Cloud SQL, with separate database user names to each user. The Cloud SQL Admin activity logs will be used to provide the auditability.
D
In a bucket on Cloud Storage that is accessible only by an AppEngine service that collects user information and logs the access before providing a link to the bucket.