Using AEAD Functions for Sensitive Data Protection in BigQuery
Short answer
D Use AEAD functions and delete keys when employees leave the organization to ensure sensitive data becomes unreadable.
Question
Key Takeaways
Tests the difference between access control (IAM/Policy Tags) and cryptographic data protection (AEAD), where key deletion provides permanent unreadability.
Learn why AEAD functions are the correct solution for ensuring sensitive data in BigQuery becomes unreadable when employees leave, compared to IAM controls or CMEK.
Common mistake: Choosing CMEK (Option C) because it involves key management, but failing to realize it encrypts entire datasets rather than allowing per-user granularity needed for individual departures.
Expert Analysis
The Requirement for Immediate Unreadability
The scenario demands that sensitive data become unreadable the moment an employee leaves. This is a critical distinction from standard access control mechanisms, which rely on permission revocation. While IAM changes are necessary, they do not inherently encrypt or obscure data already in transit or cached by the user's session. The solution must address the data itself.
Why AEAD is the Correct Mechanism
Option D leverages BigQuery’s native support for Authenticated Encryption with Associated Data (AEAD) SQL functions. These functions allow encryption and decryption of individual cell values using customer-managed keys. When an employee departs, deleting their specific cryptographic key renders the encrypted cells permanently unreadable to anyone lacking that key, including system administrators. This provides a technical guarantee of confidentiality that goes beyond logical access controls.
Limitations of Other Options
- Option A (Policy Tags): Column-level access controls via policy tags restrict who can query sensitive columns based on IAM roles. However, if an employee retains access before leaving, or if data is exported, this does not make the data unreadable upon departure; it only prevents future queries by unauthorized users. It relies on persistent identity management rather than cryptographic destruction.
- Option B (Dynamic Data Masking): Dynamic masking alters how data appears in query results based on user permissions. Like policy tags, it is a visibility layer, not a storage-layer encryption mechanism. Deleting viewer permissions stops access, but it does not encrypt the underlying stored values, nor does it provide the same level of cryptographic assurance as key deletion.
- Option C (CMEK): Customer-Managed Encryption Keys protect data at rest at the table or dataset level. Deleting a CMEK would render all data in that scope unreadable, which is disproportionate and disruptive to other employees' work. It lacks the granular, per-user granularity required to handle individual departures without impacting organizational operations.
Conclusion
Only AEAD allows for fine-grained, per-cell encryption tied to specific user identities. Destroying the key associated with a departing employee ensures their sensitive data is cryptographically erased, satisfying the strict privacy regulation requirement.
Exam Strategy
When questions specify 'unreadable' or 'cryptographic protection' triggered by a user event, prioritize options involving key deletion or token invalidation over permission revocation. Always check if the encryption scope (table-level vs. cell-level) matches the granularity required by the scenario.
Frequently Asked Questions
Why not use CMEK for employee data privacy?
Does dynamic data masking make data unreadable?
Community Votes
100% of anonymous learners picked answer D. Votes are pick records left by other test-takers — they are not the verified answer.
Discussion 3 contributions
Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.
From public community threads 3
-
DerfelCardarn 👍 3 Answered DC is too complex
-
StefG_ITA 👍 1 Answered DAEAD (Authenticated Encryption with Associated Data): BigQuery supports AEAD SQL functions that allow you to encrypt/decrypt values at the individual cell level. You can associate a key with an employee, and if they leave, you destroy their key. Granularity: Unlike other solutions, this one acts on the data itself, making it unreadable to anyone, regardless of their IAM permissions.
-
AwesomeGCP 👍 1 Answered DThe correct answer is D. Use AEAD functions and delete keys when employees leave the organization.
Reader comments & corrections
No reader corrections yet — spotted an error or have a note? Share it below.