Databricks Certified Data Engineer Associate DATA-ENGINEER-ASSOCIATE — Question 146

Topic 1 · Question 146 · Select all that apply

The Delta transaction log for the ‘students’ tables is shown using the ‘DESCRIBE HISTORY students’ command. A Data Engineer needs to query the table as it existed before the UPDATE operation listed in the log. Which command should the Data Engineer use to achieve this? (Choose two.)

• ASELECT * FROM students@v4
• BSELECT * FROM students TIMESTAMP AS OF ‘2024-04-22T 14:32:47.000+00:00’
• CSELECT * FROM students FROM HISTORY VERSION AS OF 3
• DSELECT * FROM students VERSION AS OF 5
• ESELECT * FROM students TIMESTAMP AS OF ‘2024-04-22T 14:32:58.000+00:00’

Select 2 answers to reveal the result.