nerdexam
CompTIA

SK0-005 · Question #462

An administrator restores several database files without error while participating in a mock disaster recovery exercise. Later, the administrator reports that the restored databases are corrupt and ca

The correct answer is A. The databases were not backed up to be application consistent.. Application consistent backup is a method of backing up data that ensures the integrity and consistency of the application state. It involves notifying the application to flush its data from memory to disk and quiescing any write operations before taking a snapshot of the data. I

Security and disaster recovery

Question

An administrator restores several database files without error while participating in a mock disaster recovery exercise. Later, the administrator reports that the restored databases are corrupt and cannot be used. Which of the following would best describe what caused this issue?

Options

  • AThe databases were not backed up to be application consistent.
  • BThe databases were asynchronously replicated
  • CThe databases were mirrored
  • DThe database files were locked during the restoration process.

How the community answered

(28 responses)
  • A
    71% (20)
  • B
    18% (5)
  • C
    4% (1)
  • D
    7% (2)

Explanation

Application consistent backup is a method of backing up data that ensures the integrity and consistency of the application state. It involves notifying the application to flush its data from memory to disk and quiescing any write operations before taking a snapshot of the data. If the databases were not backed up to be application consistent, they might contain incomplete or corrupted data that cannot be restored properly.

Topics

#Database Backup#Application Consistency#Disaster Recovery#Data Corruption

Community Discussion

No community discussion yet for this question.

Full SK0-005 Practice