Answer-first summary for fast verification
Answer: Utilize the DESCRIBE HISTORY command on Delta tables to provide audit logs for data changes.
Option C is the correct choice because the DESCRIBE HISTORY command in Delta Lake offers a detailed view of all changes made to a Delta table, including timestamps, operation types, user details, and table versions. This feature provides a comprehensive audit trail that meets regulatory compliance requirements efficiently. Other options like enabling automatic versioning on Azure Blob Storage (Option A), manual logging (Option B), or periodic snapshots (Option D) either lack the necessary detail or are too resource-intensive to be practical solutions.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
How can you leverage Delta Lake's time travel feature to create an audit trail for changes in critical datasets, as required by your regulatory compliance team?
A
Enable automatic versioning on the underlying Azure Blob Storage account of the Delta Lake.
B
Manually log all changes to data in a custom Delta table designed for audit logging.
C
Utilize the DESCRIBE HISTORY command on Delta tables to provide audit logs for data changes.
D
Periodically take snapshots of Delta tables and store them in separate storage accounts.