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?
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.
Confirmed is Isolation. It was in 26/09/2022 exam and I scored 1000.
Congrats, Fully Trusting ur answers ! Let's see
Isn't that isolation?
I agreed. The answer should be D--Isolation
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
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.
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.
https://learn.microsoft.com/en-us/training/modules/explore-core-data-concepts/5-transactional-data-processing Isolation. Almost the same senerio
the exam on 07/03/2023
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.
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.
Its D - Isolation
Option D
A is correct https://learn.microsoft.com/en-us/training/modules/explore-core-data-concepts/5-transactional-data-processing
Isolation
shouldn't it be consistency? what isolation
ISOLATION
D: Isolation
C is correct