Answer: Enforcing row-level security measures that are tailored to user roles, thereby limiting data access.

Enforcing row-level security measures based on user roles is a highly effective strategy for bolstering data security within a lakehouse architecture, especially when handling sensitive data. This method ensures that data access is meticulously controlled, allowing only users with the appropriate roles to view specific data rows. Such granularity in access control significantly mitigates the risk of unauthorized data exposure or breaches, thereby enhancing the overall security posture. Importantly, this approach maintains optimal performance levels since the security checks are integrated at the database level, eliminating the need for additional processing steps like encryption and decryption during query execution. Alternatives such as encrypting data (options B and D) introduce performance overheads due to the extra processing required. Similarly, segregating data by sensitivity levels into different storage accounts (option A) may complicate data management without offering the precise access control afforded by row-level security policies.

Author: LeetQuiz Editorial Team