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 rec
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 th
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.