nerdexam
Microsoft

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.

Submitted by layla.eg· Mar 30, 2026

Question

Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?

Options

  • Adurability
  • Batomicity
  • Cconsistency
  • Disolation

How the community answered

(50 responses)
  • A
    86% (43)
  • B
    8% (4)
  • C
    4% (2)
  • D
    2% (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.

AdurabilityCorrect

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.

Batomicity

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.

Cconsistency

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.

Disolation

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

#Database transactions#ACID properties#Durability

Community Discussion

No community discussion yet for this question.

Full AI-102 Practice