nerdexam
Microsoft

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.

Submitted by khalil_dz· Mar 30, 2026Implement data processing solutions

Question

Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or tails completely?

Options

  • Aisolation
  • Batomicity
  • Cconsistency
  • Ddurability

How the community answered

(25 responses)
  • A
    4% (1)
  • B
    92% (23)
  • D
    4% (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.

Aisolation

Isolation ensures that concurrent transactions appear to execute sequentially, meaning one transaction's intermediate state is not visible to other concurrent transactions.

BatomicityCorrect

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.

Cconsistency

Consistency ensures that a transaction brings the database from one valid state to another, maintaining all defined rules, constraints, and relationships.

Ddurability

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

#Atomicity#ACID properties#Data integrity

Community Discussion

No community discussion yet for this question.

Full AI-102 Practice