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.
Question
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)- A3% (1)
- B3% (1)
- C82% (27)
- D12% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.