Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Your colleague is manually copying data to a backup folder before running an update command, as a precaution in case the update doesn't yield the expected results. Which Delta Lake feature would you recommend to simplify this process?
Your colleague is manually copying data to a backup folder before running an update command, as a precaution in case the update doesn't yield the expected results. Which Delta Lake feature would you recommend to simplify this process?
Explanation:
The correct answer is to use the time travel feature to refer to old data instead of manually copying. This feature allows you to query previous versions of your data without the need for manual backups. For more information, you can refer to the Delta Lake documentation on time travel: Introducing Delta Time Travel for Large-Scale Data Lakes. Example queries include: SELECT count(*) FROM my_table TIMESTAMP AS OF '2019-01-01', SELECT count(*) FROM my_table TIMESTAMP AS OF date_sub(current_date(), 1), and SELECT count(*) FROM my_table TIMESTAMP AS OF '2019-01-01 01:30:00.000'.