An organization maintains a Google BigQuery dataset that contains tables with user-level data. They want to expose aggregates of this data to other Google Cloud projects, while still controlling…

Question

Options

• AEncrypted on Cloud Storage with user-supplied encryption keys. A separate decryption key will be given to each authorized user.
• BIn a BigQuery dataset that is viewable only by authorized personnel, with the Data Access log used to provide the auditability.
• CIn Cloud SQL, with separate database user names to each user. The Cloud SQL Admin activity logs will be used to provide the auditability.
• DIn 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

• A
  5% (2)
• B
  61% (23)
• C
  24% (9)
• D
  11% (4)

Explanation

Explanation/Reference: Government regulations in your industry mandate that you have to maintain an auditable record of access to certain types of data. Assuming that all expiring logs will be archived correctly, where should you store data that is subject to that mandate? Explanation/Reference: Bigquery is used to analyse access logs, data access logs capture the details of the user that accessed the data.

No community discussion yet for this question.