A customer has a SQL server with data and log files stored on the SAN. Data is replicated to an offsite SAN every night for the database and every hour for the log files. In the event of a failure, the SQL server can be brought up at the offsite location within 5 hours. Which of the following is true?

Question

Accepted Answer

A. The RTO is 5 hours, the RPO is one hour and the copy is disk to disk The Recovery Time Objective (RTO) is the maximum acceptable downtime for a service, which is stated as 5 hours to bring the SQL server online. The Recovery Point Objective (RPO) is the maximum acceptable data loss, and since log files are replicated hourly, the maximum data loss would be one hour of logs. The phrase "replicated to an offsite SAN" explicitly indicates a disk-to-disk replication method.

Answer

B. The RTO is one hour, the RPO is 5 hours and the copy is disk to tape This choice incorrectly reverses the RTO and RPO values and incorrectly states the copy as disk to tape, when it is disk to disk (SAN to SAN).

Answer

C. The RTO is one hour, the RPO is 5 hours and the copy is disk to disk This choice incorrectly reverses the RTO and RPO values, although it correctly identifies the copy as disk to disk.

Answer

D. The RTO is 5 hours, the RPO is one hour and the copy is disk to tape This choice incorrectly identifies the copy as disk to tape, when the replication from SAN to SAN clearly indicates a disk to disk copy.

A customer has a SQL server with data and log files stored on the SAN. Data is replicated to an offsite SAN every night for the database and every hour for the log files. In the event of a failure, th

Question

Options

How the community answered

Why each option

Topics

Community Discussion