nerdexam
Isaca

CISA · Question #101

Transaction records from a business database were inadvertently deleted, and system operators decided to restore from a snapshot copy. Which of the following provides the BEST assurance that the trans

The correct answer is D. Review transaction recovery logs to ensure no errors were recorded.. To ensure successful recovery of database transactions from a snapshot, reviewing recovery logs for errors provides the best assurance that the restoration process itself completed without issues.

Submitted by renata2k· Apr 18, 2026Information Systems Operations and Business Resilience

Question

Transaction records from a business database were inadvertently deleted, and system operators decided to restore from a snapshot copy. Which of the following provides the BEST assurance that the transactions were recovered successfully?

Options

  • ARecount the transaction records to ensure no records are missing.
  • BCompare transaction values against external statements to verify accuracy.
  • CRerun the process on a backup machine to verify the results are the same.
  • DReview transaction recovery logs to ensure no errors were recorded.

How the community answered

(41 responses)
  • A
    15% (6)
  • B
    2% (1)
  • C
    7% (3)
  • D
    76% (31)

Why each option

To ensure successful recovery of database transactions from a snapshot, reviewing recovery logs for errors provides the best assurance that the restoration process itself completed without issues.

ARecount the transaction records to ensure no records are missing.

Recounting records only verifies the quantity, not the content or integrity of the restored data.

BCompare transaction values against external statements to verify accuracy.

Comparing against external statements verifies data accuracy but doesn't directly confirm the *recovery process* was successful without errors; it's a data validation step after recovery.

CRerun the process on a backup machine to verify the results are the same.

Rerunning a process on a backup machine tests the process itself, not the success of the data restoration from a snapshot.

DReview transaction recovery logs to ensure no errors were recorded.Correct

Transaction recovery logs document the restoration process, detailing the operations performed and any errors or warnings encountered, which directly indicates whether the data was physically recovered without technical faults during the snapshot restoration. A clean log confirms the recovery mechanism functioned as expected, providing assurance in the integrity of the restore operation.

Concept tested: Database recovery validation

Source: https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/view-the-sql-server-error-log-ssms?view=sql-server-ver16

Topics

#Data Recovery#Audit Verification#System Logs#Business Resilience

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full CISA Practice