nerdexam
Citrix

1Y0-401 · Question #143

How should the architect implement database protection in Access?

The correct answer is C. By enabling Volume Shadow Copy. Database protection in Access is best implemented by enabling Volume Shadow Copy Service (VSS), which creates consistent point-in-time snapshots of the database file.

Design Operational Management and Security

Question

How should the architect implement database protection in Access?

Options

  • ABy making copies of the .MDB file
  • BBy hosting the .MDB file on a network share
  • CBy enabling Volume Shadow Copy
  • DBy taking hypervisor snapshots of the VM running Access

How the community answered

(33 responses)
  • A
    3% (1)
  • B
    3% (1)
  • C
    82% (27)
  • D
    12% (4)

Why each option

Database protection in Access is best implemented by enabling Volume Shadow Copy Service (VSS), which creates consistent point-in-time snapshots of the database file.

ABy making copies of the .MDB file

While making copies is a form of backup, it may not guarantee a consistent state if the Access database is actively being used, potentially leading to data corruption in the backup.

BBy hosting the .MDB file on a network share

Hosting an .MDB file on a network share is primarily about file accessibility and does not inherently provide backup, recovery, or consistency features for database protection.

CBy enabling Volume Shadow CopyCorrect

Volume Shadow Copy Service (VSS) provides a mechanism to create consistent backups of open files, including live Microsoft Access database files, by creating a point-in-time snapshot of the volume. This ensures data integrity and prevents corruption when backing up the database.

DBy taking hypervisor snapshots of the VM running Access

Taking hypervisor snapshots of the VM might result in a crash-consistent backup of the database, but without VSS integration within the guest OS, it does not guarantee an application-consistent snapshot, which is crucial for database integrity.

Concept tested: Access database backup using VSS

Source: https://learn.microsoft.com/windows-server/storage/volume-shadow-copy-service/volume-shadow-copy-service-overview

Topics

#database protection#VSS#Access database

Community Discussion

No community discussion yet for this question.

Full 1Y0-401 Practice