Google Cloud Professional Cloud Database Engineer — Question 126

You have deployed a Cloud SQL for SQL Server instance. In addition, you created a cross-region read replica for disaster recovery (DR) purposes. Your company requires you to maintain and monitor a recovery point objective (RPO) of less than 5 minutes. You need to verify that your cross-region read replica meets the allowed RPO. What should you do?

Answer options

• A. Use Cloud SQL instance monitoring.
• B. Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
• C. Use Cloud SQL logs.
• D. Use the SQL Server Always On Availability Group dashboard.

Correct answer: D

Explanation

The correct answer is D because the SQL Server Always On Availability Group dashboard provides specific metrics regarding the health and performance of the replicas, including RPO data. Options A and B offer general monitoring and metrics but do not specifically address RPO, while option C provides logs that are not real-time indicators of RPO compliance.