When designing a data model in a lakehouse environment that requires frequent access to historical versions for compliance and auditing purposes, which strategy best optimizes access to these historical data points?

Real Exam

Store each version as a separate record in a flat table, using a timestamp and version identifier as part of the primary key.

9.3%

Implement a custom versioning layer atop Delta tables that tracks changes in an external system for faster version retrieval.

6.8%

Leverage Delta Lake‘s time travel feature, partitioning data by change date to optimize retrieval of specific versions.

76.3%

Use a combination of materialized views and Delta Lake‘s event log to reconstruct historical states efficiently.

7.6%

Databricks Certified Data Engineer - Professional