Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
A data architect is evaluating two methods for auditing historical street addresses in a customers table. They are comparing the use of Delta Lake’s time travel on a Type 1 table for long-term auditing versus implementing a standard SCD Type 2 table.
Which of the following critical factors should influence the decision to choose a Type 2 table over relying solely on time travel?
A
SCD Type 2 tables require updating multiple fields in a single operation, which can lead to data corruption if a query fails during a partial update.
B
Delta Lake time travel is not efficient in terms of cost or latency for long-term historical versioning and auditing.
C
Delta Lake time travel cannot access previous versions of Type 1 tables because changes modify data files in place.
D
Combining shallow clones with Type 1 tables is the standard architectural pattern to speed up historical queries for long-term versioning.