Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
In designing a data model that includes personally identifiable information (PII) within a lakehouse architecture, what is the most effective method to dynamically mask PII for unauthorized users at query time?
A
Utilize Delta Lake's column-level security features to automatically mask PII for specific roles.
B
Store all PII in encrypted columns and decrypt them in the application layer according to user roles.
C
Apply row-level security policies to dynamically adjust PII visibility based on the querying user's permissions.
D
Establish a view over the original data that implements conditional logic to mask PII fields, providing access to this view rather than the underlying table.
