FC0-U61 · Question #452
An organization exports an inventory database nightly. This is an example of:
The correct answer is C. database backup.. Exporting an inventory database nightly primarily serves as a database backup, creating a copy of the data for recovery in case of data loss or corruption.
Question
An organization exports an inventory database nightly. This is an example of:
Options
- Adatabase query.
- Bdatabase report.
- Cdatabase backup.
- Ddatabase import.
How the community answered
(38 responses)- B5% (2)
- C92% (35)
- D3% (1)
Why each option
Exporting an inventory database nightly primarily serves as a database backup, creating a copy of the data for recovery in case of data loss or corruption.
A database query is a request for data from the database, not an export of the entire database for archival purposes.
A database report presents organized data from the database, typically summarizing specific information, rather than a full data copy for recovery.
A database backup involves creating a copy of the database's data, which can then be used to restore the database to a previous state in the event of failure or data loss. Nightly exports are a common strategy for maintaining up-to-date backups.
A database import is the process of bringing data into a database, which is the opposite of exporting data out.
Concept tested: Database backup purpose and function
Source: https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/backup-overview-sql-server
Topics
Community Discussion
No community discussion yet for this question.