Topic 1 Question 127
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?
Use Cloud SQL instance monitoring.
Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
Use Cloud SQL logs.
Use the SQL Server Always On Availability Group dashboard.
γ³γ‘γ³γ(1)
D. 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
π 3dynamic_dba2023/03/27
γ·γ£γγγ«γ’γΌγ