Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
How can a data lakehouse storing highly sensitive personal data subject to regulatory compliance best ensure compliance while maintaining usability for analytics?
A
Store sensitive data in encrypted form within the same tables as non-sensitive data, decrypting on-the-fly during query execution.
B
Segment sensitive data into a dedicated, secured area of the lakehouse, applying column-level security and masking where necessary.
C
Encrypt all data at rest and in transit, applying fine-grained access control at the file level based on user roles.
D
Utilize a hybrid approach, keeping sensitive data in a fully encrypted and isolated storage account with restricted access, and non-sensitive data in a general-purpose lakehouse area.
