Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
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 99 discussion

Actual exam question from Google's Professional Cloud Database Engineer
Question #: 99
Topic #: 1
[All Professional Cloud Database Engineer Questions]

You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?

  • A. Create one regional Cloud SQL instance with a read replica in another region.
  • B. Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
  • C. Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.
  • D. Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by pk349 at Dec. 24, 2022, 11:20 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
chelbsik
Highly Voted 1 year, 11 months ago
Selected Answer: B
In HA configuration standby instance can't be in another region
upvoted 7 times
...
pico
Most Recent 1 year, 3 months ago
Selected Answer: A
A From: https://cloud.google.com/sql/docs/mysql/high-availability The HA configuration provides data redundancy. A Cloud SQL instance configured for HA is also called a regional instance and has a primary and secondary zone within the configured region. When we say: regional Cloud SQL that already means that the instance has the configuration made up of a primary instance and a standby instance. If we want to have the maximum availability If a replica is a cross-region replica, you can perform a failover to another region; specifically, you can promote a replica to a standalone instance
upvoted 1 times
Zek
1 week, 1 day ago
Your explanation support B as the answer. With cross-region replica, you cannot do automatic failover, it has to be manually promoted. Automatic failover is achievable within the region using different zones in same region.
upvoted 1 times
...
...
dynamic_dba
1 year, 8 months ago
B. A is not HA. B would be HA. C doesn’t make sense and neither does D. Cloud SQL is a regional service which means the failover replica is in the same region as the primary - hopefully in a different zone. Read replicas can be in different regions, but they’re read replicas not failover replicas.
upvoted 3 times
...
pk349
1 year, 11 months ago
B: Create one regional Cloud SQL instance in one zone with a standby ***** instance in another zone in the same region.
upvoted 1 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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