ExamTopics Logo
Mail Us[email protected]
Menu
Databricks Discussions
exam questions

Exam Certified Data Engineer Professional All Questions

View all questions & answers for the Certified Data Engineer Professional exam
Go to Exam

Exam Certified Data Engineer Professional topic 1 question 58 discussion

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

A Databricks job has been configured with 3 tasks, each of which is a Databricks notebook. Task A does not depend on other tasks. Tasks B and C run in parallel, with each having a serial dependency on task A.
If tasks A and B complete successfully but task C fails during a scheduled run, which statement describes the resulting state?

  • A. All logic expressed in the notebook associated with tasks A and B will have been successfully completed; some operations in task C may have completed successfully.
  • B. All logic expressed in the notebook associated with tasks A and B will have been successfully completed; any changes made in task C will be rolled back due to task failure.
  • C. All logic expressed in the notebook associated with task A will have been successfully completed; tasks B and C will not commit any changes because of stage failure.
  • D. Because all tasks are managed as a dependency graph, no changes will be committed to the Lakehouse until ail tasks have successfully been completed.
  • E. Unless all tasks complete successfully, no changes will be committed to the Lakehouse; because task C failed, all commits will be rolled back automatically.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by tkg13 at Aug. 24, 2023, 4:24 a.m.

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
Submit Cancel
IT3008
Highly Voted 1 year, 7 months ago
Should be 'A' only, as ACID compliance is applicable at operation level. For example if task C is having 3 target delta table writes (in independent Notebook cells) then it could have after 1 write the task fails during 2nd write. In that case 1st write will still be persisted. The ACID compliance will be applicable for only the 2nd write.
upvoted 9 times
...
alexvno
Highly Voted 1 year, 4 months ago
Selected Answer: A
A - for sure this is NOT ACID operations
upvoted 5 times
...
dd1192d
Most Recent 6 months, 4 weeks ago
Selected Answer: A
https://community.databricks.com/t5/data-engineering/does-cancelling-a-job-run-rollback-any-actions-performed-by/td-p/8135
upvoted 2 times
...
tkg13
1 year, 8 months ago
Correct answer should be B as Databricks is ACID compliant
upvoted 2 times
arekm
4 months ago
A single SQL command is ACID compliant, not a whole notebook.
upvoted 1 times
...
eli91
1 year, 8 months ago
What if an operation of C is to delete a file, will the file be created after a roll back?
upvoted 2 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago