For a large-scale data lakehouse with petabytes of data, what is the most efficient method to implement data masking for Personally Identifiable Information (PII) across multiple datasets to comply with privacy regulations?

Real Exam

Utilize an on-the-fly encryption model where data is only decrypted and masked as needed when accessed by unauthorized users.

8.3%

Apply real-time data masking at the query level, using dynamic data masking capabilities of the lakehouse platform.

19.0%

Implement column-level security, restricting access to sensitive columns and providing masked views to unauthorized users.

70.2%

Perform batch data masking operations during off-peak hours, rewriting datasets with masked versions of sensitive fields.

2.4%

Databricks Certified Data Engineer - Professional