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

Suggested Answer: A 🗳️

by tkg13 at Aug. 24, 2023, 4:24 a.m.

Comments

Submit Cancel

IT3008

Highly Voted 1 year, 2 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 8 times

...

dd1192d

Most Recent 1 month, 2 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 1 times

...

alexvno

11 months, 1 week ago

Selected Answer: A

A - for sure this is NOT ACID operations

upvoted 3 times

...

tkg13

1 year, 3 months ago

Correct answer should be B as Databricks is ACID compliant

upvoted 2 times

eli91

1 year, 2 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

...

Exam Certified Data Engineer Professional All Questions

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