Exam DP-900 topic 1 question 226 discussion

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

Isn't that isolation?

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

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

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

Isolation

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.

the exam on 07/03/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.

shouldn't it be consistency? what isolation

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.

ISOLATION

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

C is correct