Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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?
A
Store each version as a separate record in a flat table, using a timestamp and version identifier as part of the primary key.
B
Implement a custom versioning layer atop Delta tables that tracks changes in an external system for faster version retrieval.
C
Leverage Delta Lake‘s time travel feature, partitioning data by change date to optimize retrieval of specific versions.
D
Use a combination of materialized views and Delta Lake‘s event log to reconstruct historical states efficiently.
