exam questions

Exam DP-900 All Questions

View all questions & answers for the DP-900 exam

Exam DP-900 topic 1 question 259 discussion

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

A bank needs to ensure that after an account transfer transaction completes, the revised account balances persists even if the database system hosting the transaction becomes temporarily unavailable.

Of which ACID semantic is this an example?

  • A. durability
  • B. isolation
  • C. atomicity
  • 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
naronomous
10 months, 3 weeks ago
Correct: 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 3 times
...
Erich_1970
10 months, 4 weeks ago
Durability ensures that once a transaction is committed, its effects persist even in the face of system failures. The changes made by a committed transaction should be permanent. Example: After Alice's transfer to Bob is successful and the system acknowledges the completion, even if there's a power outage or system crash, the $100 transfer should still be reflected in the database once the system is restored.
upvoted 1 times
...
testdumps2017
1 year, 2 months ago
Isolation, it talks about two different transactions. Durability refers to the data being consistent after a crash recovery.
upvoted 1 times
Yomzie
8 months, 2 weeks ago
Transaction Durability: Simple English. **The previously completed (committed) transaction must PERSIST even if there is a system crash/outage thereafter.
upvoted 1 times
...
Ashishn132
1 year ago
Answer is correct. Isolation talks about two concurrent transactions are isolated such way one transaction does not affect other other transaction
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago