exam questions

Exam Certified Data Engineer Associate All Questions

View all questions & answers for the Certified Data Engineer Associate exam

Exam Certified Data Engineer Associate topic 1 question 148 discussion

Actual exam question from Databricks's Certified Data Engineer Associate
Question #: 148
Topic #: 1
[All Certified Data Engineer Associate Questions]

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.)

  • A. SELECT * FROM students@v4
  • B. SELECT * FROM students TIMESTAMP AS OF ‘2024-04-22T 14:32:47.000+00:00’
  • C. SELECT * FROM students FROM HISTORY VERSION AS OF 3
  • D. SELECT * FROM students VERSION AS OF 5
  • E. SELECT * FROM students TIMESTAMP AS OF ‘2024-04-22T 14:32:58.000+00:00’
Show Suggested Answer Hide Answer
Suggested Answer: AB 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
DipeshGandhi131
23 hours, 8 minutes ago
Selected Answer: AB
https://docs.databricks.com/en/delta/history.html#delta-time-travel-syntax
upvoted 1 times
...
MultiCloudIronMan
5 days, 22 hours ago
Selected Answer: BD
Option A (SELECT * FROM students@v4) is not correct because the syntax students@v4 is not valid in SQL for querying a specific version of a Delta table. The correct syntax to query a specific version of a Delta table is to use the VERSION AS OF or TIMESTAMP AS OF clauses. Therefore, the correct options are: B. SELECT * FROM students TIMESTAMP AS OF ‘2024-04-22T 14:32:47.000+00:00’ D. SELECT * FROM students VERSION AS OF 5
upvoted 1 times
...
Worldmaster
2 weeks, 6 days ago
Selected Answer: AB
AB correct https://docs.databricks.com/en/delta/history.html
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago