ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam
Go to Exam

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 Hide Answer
Suggested Answer: D 🗳️
by dynamic_dba at March 28, 2023, 1:29 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
dynamic_dba
Highly Voted 2 years, 1 month 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 3 months 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
...
kitechen
7 months ago
Selected Answer: B
Always On Availability Groups are a feature of on-premises SQL Server or SQL Server running on VMs, not Cloud SQL
upvoted 1 times
...
Pime13
12 months ago
Selected Answer: D
D- https://cloud.google.com/sql/docs/sqlserver/replication/manage-replicas#console_1
upvoted 2 times
...
nmnm22
1 year, 1 month ago
Selected Answer: D
option D no doubt
upvoted 2 times
...
PKookNN
1 year, 3 months ago
Selected Answer: D
https://cloud.google.com/sql/docs/sqlserver/replication/manage-replicas#replication-status explains it.
upvoted 2 times
...
Andrei_Z
1 year, 5 months ago
Selected Answer: B
I thought it was B at first but apparently, we can use Cloud Monitoring to see all the metrics for the recovery an replication.
upvoted 1 times
...
sapsant
1 year, 9 months ago
Selected Answer: D
D is the correct answer
upvoted 3 times
...
sapsant
1 year, 9 months ago
Selected Answer: D
https://cloud.google.com/sql/docs/sqlserver/replication/manage-replicas#promote-replica
upvoted 3 times
...
dedotes
1 year, 9 months ago
Vote for D! Agreed with dynamic_dba
upvoted 2 times
...
abdenago
1 year, 10 months ago
Selected Answer: B
https://medium.com/google-cloud/cloud-sql-recovering-from-regional-failure-in-10-minutes-or-less-mysql-fc055540a8f0
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago