DS0-001 Question #33: Real Exam Question with Answer & Explanation

Question

A database administrator needs to ensure continuous availability of a database in case the server fails. Which of the following should the administrator implement to ensure high availability of the database?

Options

• AETL
• BReplication
• CDatabase dumping
• DBackup and restore

Explanation

The option that the administrator should implement to ensure high availability of the database is replication. Replication is a process that copies and synchronizes data from one database server (the primary or source) to one or more database servers (the secondary or target). Replication helps ensure high availability of the database by providing redundancy, fault tolerance, and load balancing. If the primary server fails, the secondary server can take over and continue to serve the data without interruption or data loss. The other options are either not related or not suitable for this purpose. For example, ETL is a process that extracts, transforms, and loads data from one source to another for analysis or reporting purposes; database dumping is a process that exports the entire content of a database to a file for backup or migration purposes; backup and restore is a process that copies and recovers data from a backup device or media in case of a disaster or corruption.

No community discussion yet for this question.