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?

Real Exam

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.

12.3%

Create separate columns for transaction time and valid time in a single table, with partitions based on transaction time and clustering on valid time.

22.8%

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.

56.1%

Utilize two parallel tables, one for transaction time and another for valid time, with a process to synchronize updates across both.

8.8%

Databricks Certified Data Engineer - Professional

Get started today

Comments

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?