QuestionQ65

VerifiedBusiness Continuity

An administrator must assess whether the current Protection Domain configuration satisfies the stated corporate recovery policy for SQL Data. The corporate policy requires that all SQL Servers be recoverable at the DR site within 30 minutes and that data loss be no greater than 60 minutes. 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 to take snapshots every 90 minutes from 7 am until 8 pm.

What must be changed to meet the required policy?

Explanation

Snapshot frequency establishes the maximum recovery point and therefore the possible amount of data loss. A 90-minute snapshot interval permits up to 90 minutes of lost SQL data, which violates a 60-minute maximum. A 60-minute interval satisfies that recovery-point requirement, while application-consistent snapshots and the dedicated consistency group preserve SQL consistency.

Community Discussion

No comments yet. Be the first to start the discussion!