AI-102 · Question #140
Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or tails completely?
The correct answer is B. atomicity. The Atomicity property of ACID transactions ensures that each transaction is an indivisible unit of work, meaning all operations within it either complete successfully or none of them do.
Question
Options
- Aisolation
- Batomicity
- Cconsistency
- Ddurability
How the community answered
(25 responses)- A4% (1)
- B92% (23)
- D4% (1)
Why each option
The Atomicity property of ACID transactions ensures that each transaction is an indivisible unit of work, meaning all operations within it either complete successfully or none of them do.
Isolation ensures that concurrent transactions appear to execute sequentially, meaning one transaction's intermediate state is not visible to other concurrent transactions.
Atomicity guarantees that a transaction is treated as a single, indivisible unit; all of its operations must either complete successfully or the entire transaction fails and leaves the database unchanged, preventing partial updates.
Consistency ensures that a transaction brings the database from one valid state to another, maintaining all defined rules, constraints, and relationships.
Durability guarantees that once a transaction has been committed, its changes will persist and remain permanent, even in the event of system failures.
Concept tested: ACID properties - Atomicity
Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-service-tiers-vcore?view=azuresql#transactional-consistency
Topics
Community Discussion
No community discussion yet for this question.