exam questions

Exam DP-900 All Questions

View all questions & answers for the DP-900 exam

Exam DP-900 topic 1 question 194 discussion

Actual exam question from Microsoft's DP-900
Question #: 194
Topic #: 1
[All DP-900 Questions]

Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?

  • A. atomicity
  • B. durability
  • C. isolation
  • D. consistency
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

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
thewrongbeckie
Highly Voted 2 years, 1 month ago
Selected Answer: A
Atomicity is the right 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.
upvoted 15 times
...
jellybiscuit
Highly Voted 2 years, 1 month ago
Selected Answer: A
atomicity
upvoted 8 times
...
james2033
Most Recent 1 year ago
Selected Answer: A
Atomicity: All changes to data are performed as if they are a single operation. That is, all the changes are performed, or none of them are. For example, in an application that transfers funds from one account to another, the atomicity property ensures that, if a debit is made successfully from one account, the corresponding credit is made to the other account. https://www.ibm.com/docs/en/cics-ts/5.4?topic=processing-acid-properties-transactions
upvoted 2 times
...
testdumps2017
1 year, 2 months ago
it is consistency. Atomic: it is indivisible. Consistent: leaves data in a consistent state (either commits or rolls back the entire transaction). Independent: a transaction does not depend on other transactions to complete. Durable: data is left in a durable state in case of failure (hardware). Last one is up for debate with in-memory structures.
upvoted 1 times
...
VNR25
1 year, 3 months ago
This question appeared in the 07/07/23 exam and the answer is correct.
upvoted 1 times
...
Pranava_GCP
1 year, 6 months ago
Atomicity – each transaction is treated as a single unit, which succeeds completely or fails completely. For example, a transaction that involved debiting funds from one account and crediting the same amount to another account must complete both actions. If either action can't be completed, then the other action must fail.
upvoted 2 times
...
Maria86
1 year, 7 months ago
A is correct, appeared on exam today - I chose A, and scored 1000
upvoted 3 times
...
reza88
2 years ago
Exam: 20/10/2022
upvoted 1 times
...
pallmall
2 years, 1 month ago
Selected Answer: A
A is correct Atomicity ensures the requirement
upvoted 1 times
...
[Removed]
2 years, 1 month ago
Shouldn't this be B
upvoted 1 times
JA2018
2 years ago
Durability – when a transaction has been committed, it will remain committed. After the account transfer transaction has completed, the revised account balances are persisted so that even if the database system were to be switched off, the committed transaction would be reflected when it is switched on again. https://learn.microsoft.com/en-us/training/modules/explore-core-data-concepts/5-transactional-data-processing
upvoted 1 times
Yomzie
8 months ago
Atomicity: the smallest indivisible set of operations, that must ALL succeed together, or ALL fail (and reversed) together.
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