Exam Professional Cloud Database Engineer topic 1 question 127 discussion

Actual exam question from Google's Professional Cloud Database Engineer

Question #: 127
Topic #: 1

[All Professional Cloud Database Engineer Questions]

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?

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.

Show Suggested Answer

Suggested Answer: D 🗳️

by dynamic_dba at March 28, 2023, 1:29 a.m.

Comments

Submit Cancel

dynamic_dba

Highly Voted 2 years, 4 months ago

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

upvoted 14 times

...

Popa

Most Recent 6 months, 1 week ago

Selected Answer: B

SQL Server Always On Availability Groups can be configured on GCP. This feature is valuable for high availability and disaster recovery. However, the Cloud Monitoring dashboard is specifically tailored for Google Cloud resources, including Cloud SQL instances. It offers built-in metrics and monitoring capabilities designed to track and ensure that the Read Replica meets the required RPO. Even though the Always On Availability Group can be configured, Cloud Monitoring is generally more streamlined for this purpose.

upvoted 1 times

...