When designing a data lakehouse for cross-geographical data analysis with strict data locality regulations, what is the best approach to ensure data compliance while optimizing analytical performance across different regions?

Real Exam

Utilize a federated query system across regional lakehouses, caching common datasets in each region for performance.

11.5%

Partition data by geography in a global lakehouse, implementing row-level security to enforce data access controls based on user location.

56.4%

Replicate data across regional lakehouses, applying data masking and anonymization to comply with local regulations.

15.4%

Implement geo-partitioning with automated data lifecycle policies that move data to specific regional lakehouses based on access patterns.

16.7%

Databricks Certified Data Engineer - Professional