FC0-U61 · Question #556
Which of the following methods of access is MOST likely to be used during a database recovery?
The correct answer is C. Utility. During a database recovery, a utility method of access is most likely used because it provides specialized tools designed for database administration tasks like backup and restoration. These utilities often bypass normal application interfaces to perform low-level operations dire
Question
Which of the following methods of access is MOST likely to be used during a database recovery?
Options
- AGraphical user interface
- BDirect
- CUtility
- DProgrammatic
How the community answered
(18 responses)- A6% (1)
- B6% (1)
- C89% (16)
Why each option
During a database recovery, a utility method of access is most likely used because it provides specialized tools designed for database administration tasks like backup and restoration. These utilities often bypass normal application interfaces to perform low-level operations directly on the database files or structures.
A graphical user interface (GUI) is usually for normal user interaction and data entry, not for low-level recovery operations.
Direct access might imply interacting with raw database files, which is risky and usually performed through utilities for safety and integrity.
Database recovery typically involves specialized software utilities provided by the database management system (DBMS) itself. These utilities are designed to repair corrupted databases, restore from backups, or apply transaction logs, operating at a lower level than standard user interfaces to ensure data integrity and availability.
Programmatic access is for applications to interact with the database during normal operation, not typically for recovery which requires administrative tools.
Concept tested: Database recovery methods
Source: https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-and-recovery-overview-sql-server
Topics
Community Discussion
No community discussion yet for this question.