PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #99
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…
The correct answer is D. Use the SQL Server Always On Availability Group dashboard. Note, you cannot create a read replica in Cloud SQL for SQL Server unless you use an Enterprise Edition. Which is also a requirement for configuring SQL Server AG. That's not a coincidence. That's how Cloud SQL for SQL Server creates SQL Server read replicas. To find out about…
Question
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?
Options
- AUse Cloud SQL instance monitoring.
- BUse the Cloud Monitoring dashboard with available metrics from Cloud SQL.
- CUse Cloud SQL logs.
- DUse the SQL Server Always On Availability Group dashboard.
How the community answered
(34 responses)- A9% (3)
- B6% (2)
- C3% (1)
- D82% (28)
Explanation
Note, you cannot create a read replica in Cloud SQL for SQL Server unless you use an Enterprise Edition. Which is also a requirement for configuring SQL Server AG. That's not a coincidence. That's how Cloud SQL for SQL Server creates SQL Server read replicas. To find out about the replication, use the AG Dashboard in SSMS. https://cloud.google.com/sql/docs/sqlserver/replication/manage-replicas#promote-replica
Topics
Community Discussion
No community discussion yet for this question.