Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
How can you implement a bi-temporal model in a lakehouse for financial data under regulatory compliance, enabling queries on both transaction and valid times without data duplication?
A
Store transaction logs in an append-only table, with another table capturing the state of data at specific valid times, facilitating bi-temporal queries through joins.
B
Create separate columns for transaction time and valid time in a single table, with partitions based on transaction time and clustering on valid time.
C
Implement a versioned approach where each record update duplicates the data row with new transaction and valid times, using Delta Lake‘s time travel for querying specific versions.
D
Utilize two parallel tables, one for transaction time and another for valid time, with a process to synchronize updates across both.
