AI-102 · Question #141
Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?
The correct answer is A. durability. Durability, one of the ACID properties, guarantees that once a transaction is committed, its changes are permanently stored and will survive any system failures, including operating system restarts.
Question
Options
- Adurability
- Batomicity
- Cconsistency
- Disolation
How the community answered
(50 responses)- A86% (43)
- B8% (4)
- C4% (2)
- D2% (1)
Why each option
Durability, one of the ACID properties, guarantees that once a transaction is committed, its changes are permanently stored and will survive any system failures, including operating system restarts.
Durability ensures that once a transaction has been successfully committed, the changes made to the database are permanent and will persist even through system outages like unexpected operating system restarts or power failures.
Atomicity ensures that a transaction is treated as an indivisible unit, either fully committing or fully rolling back, but doesn't specifically address persistence across system restarts.
Consistency ensures that a transaction brings the database from one valid state to another, maintaining all defined rules and constraints, but doesn't directly relate to data survival after system failure.
Isolation ensures that concurrent transactions do not interfere with each other and appear to execute sequentially, not that committed changes survive system restarts.
Concept tested: ACID properties - Durability
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.