Exam DP-900 Topic 2 Question 2 Discussion

Actual exam question for Microsoft's DP-900 exam
Question #: 2
Topic #: 2
Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?

Suggested Answer: C Vote an answer

An atomic transaction is an indivisible and irreducible series of database operations such that either all occurs, or nothing occurs. A guarantee of atomicity prevents updates to the database occurring only partially, which can cause greater problems than rejecting the whole series outright. As a consequence, the transaction cannot be observed to be in progress by another database client.

by Kennedy at Jun 20, 2026, 09:46 AM

Limited Time Offer

15%

Off

Get Premium DP-900 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
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.
0
0
0
10