exam questions

Exam DP-900 All Questions

View all questions & answers for the DP-900 exam

Exam DP-900 topic 1 question 270 discussion

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

A bank needs to ensure that a transaction involving debiting funds from a source account and crediting the same funds to a destination account must complete both actions. If either action falls to complete, the other action must fail.

Of which ACID semantic is this an example?

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

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
Kebedegn
2 months, 1 week ago
Selected Answer: C
c is right answer
upvoted 1 times
...
Kapello10
8 months, 1 week ago
Atomicity guarantees that each transaction is treated as a single "unit", which either succeeds completely or fails completely: if any of the statements constituting a transaction fails to complete, the entire transaction fails and the database is left unchanged Consistency ensures that a transaction can only bring the database from one consistent state to another, preserving database invariants: any data written to the database must be valid according to all defined rules Isolation ensures that concurrent execution of transactions leaves the database in the same state that would have been obtained if the transactions were executed sequentially Durability guarantees that once a transaction has been committed, it will remain committed even in the case of a system failure (e.g., power outage or crash).
upvoted 4 times
Kapello10
8 months, 1 week ago
Ans is C Atomicty
upvoted 3 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 ...