Ultimate access to all questions.
A data architect is evaluating Delta Lake's versioning and time travel features for auditing purposes, needing to maintain a complete history of all valid street addresses in the customers table.
The architect proposes using a Type 1 table (overwriting records and relying on time travel for auditing), while a data engineer advocates for a Type 2 table for better performance and scalability.
What key factor should influence this decision?