Exam NCM-MCI All QuestionsBrowse all questions from this exam
Go to Exam
Question 31

An administrator needs to evaluate if the existing configuration of Protection Domains meets the specified corporate recovery policy for SQL Data. The corporate policy requires that all SQL Servers be recoverable at the DR site within 30 minutes, and must result in a maximum of 60 minutes of data loss. SQL data must be required.

The protection domain is configured as follows:

✑ Application consistent snapshots are enabled

✑ The SQL server VMs are assigned to the Protection Domain as their own Consistency Group

✑ The Protection Domain schedule is configured as snapshots taken every 90 minutes from 7 am until 8 pm

What must be changed to meet the required policy?

    Correct Answer: C

    The protection domain must align with the corporate recovery policy which states that the SQL data must be recoverable with a maximum of 60 minutes of data loss. This means snapshots should be taken often enough so that the maximum data loss does not exceed 60 minutes. The current configuration of taking snapshots every 90 minutes would result in a potential data loss of up to 90 minutes, which is not acceptable according to the policy. By revising the schedule to take snapshots every 30 minutes, the policy would be met because even in the event of a failure, at most, only 30 minutes of data would be lost, complying with the maximum of 60 minutes data loss requirement.

Discussion
klwood2000Option: C

C. You want to replicate half the time of the RPO. If you have a 60 min RPO, and you lose a replication point, you have to roll back 120 minutes. If you replicate every 30 minutes and lose a cycle, at most you have to go back is 60 minutes which meets the requirement.