DP-900 Exam QuestionsBrowse all questions from this exam

DP-900 Exam - Question 226


A bank has a system that manages financial transactions.

When transferring money between accounts. the system must never retrieve a value for the source account that reflects the balance before the transfer and a value for the destination account that reflects the balance after the transfer.

Of which ACID semantic is this an example?

Show Answer
Correct Answer: AD

Isolation ensures that transactions occur independently of one another. In the scenario where the system must not retrieve a value for the source account that reflects the balance before the transfer and a value for the destination account that reflects the balance after the transfer, isolation guarantees that each transaction is executed in isolation. This way, concurrently running transactions do not affect each other's operations, ensuring consistency and correctness of financial transactions.

Discussion

17 comments
Sign in to comment
studysmartOption: D
Sep 26, 2022

Confirmed is Isolation. It was in 26/09/2022 exam and I scored 1000.

Maaran07
Oct 22, 2022

Congrats, Fully Trusting ur answers ! Let's see

pallmallOption: D
Sep 6, 2022

Isn't that isolation?

snowfox
Sep 14, 2022

I agreed. The answer should be D--Isolation

ArchMelodyOption: D
Oct 6, 2022

It's definitely isolation, based on official Microsoft example: https://learn.microsoft.com/en-us/training/modules/explore-core-data-concepts/5-transactional-data-processing

PinhaOption: D
Jan 26, 2023

Isolation is one of the four ACID semantic properties of a database management system that ensure that different transactions do not interfere with each other. Isolation property guarantees that each transaction is executed in a isolated manner as if it is the only transaction taking place.

tangerine141Option: D
Mar 15, 2023

In the scenario described, the system must ensure that the balance of the source account is not retrieved until the transfer transaction is completed, and the balance of the destination account reflects the updated balance after the transfer transaction is completed. This ensures that the transfer transaction appears to execute sequentially, even if other transactions are executing concurrently.

[Removed]Option: D
Dec 16, 2022

Isolation. See course material: o concurrent transactions cannot interfere with one another, and must result in a consistent database state. o For example, while the transaction to transfer funds from one account to another is in-process, another transaction that checks the balance of these accounts must return consistent results - the balance-checking transaction can't retrieve a value for one account that reflects the balance before the transfer, and a value for the other account that reflects the balance after the transfer.

PhyoPluto
Mar 9, 2023

the exam on 07/03/2023

EstbanFTPOption: D
Oct 31, 2023

https://learn.microsoft.com/en-us/training/modules/explore-core-data-concepts/5-transactional-data-processing Isolation. Almost the same senerio

duyhai707Option: C
Sep 28, 2022

C is correct

azure_doriOption: D
Oct 17, 2022

D: Isolation

DusicaOption: D
Nov 22, 2022

ISOLATION

nmnm22Option: D
Dec 17, 2022

shouldn't it be consistency? what isolation

Anuragsharma83Option: D
Oct 12, 2023

Isolation

FoadDeveloperOption: A
Oct 28, 2023

A is correct https://learn.microsoft.com/en-us/training/modules/explore-core-data-concepts/5-transactional-data-processing

AGTrainingOption: D
Mar 2, 2024

Option D

b708c7eOption: D
Mar 20, 2024

Its D - Isolation

CARODRIOption: A
Jul 16, 2024

Atomicity - each statement in a transaction (to read, write, update or delete data) is treated as a single unit. Either the entire statement is executed, or none of it is executed. This property prevents data loss and corruption from occurring if, for example, if your streaming data source fails mid-stream. Isolation - when multiple users are reading and writing from the same table all at once, isolation of their transactions ensures that the concurrent transactions don't interfere with or affect one another. Each request can occur as though they were occurring one by one, even though they're actually occurring simultaneously.