For a data lakehouse designed to maintain immutable historical records of rapidly changing data, which strategy ensures efficient query performance and data integrity across versioned records?

Real Exam

Store each version as a separate file in a partitioned directory structure, leveraging metastore version annotations for query access.

3.8%

Implement a branching data model within the lakehouse, creating separate branches for each version and merging them for analysis.

7.7%

Utilize Delta Lake’s MERGE feature to upsert changes into a single versioned table, partitioned by the record timestamp.

26.9%

Use Delta Lake time travel capabilities to access historical versions, optimizing current version access via partitioning and z-ordering.

61.5%

Databricks Certified Data Engineer - Professional