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 34 discussion

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

Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database. Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us-central1 and the backup region of us-east1. What should you do?

  • A. 1. Provision a Cloud SQL for MySQL instance in us-central1-a.
    2. Create a multiple-zone instance in us-west1-b.
    3. Create a read replica in us-east1-c.
  • B. 1. Provision a Cloud SQL for MySQL instance in us-central1-a.
    2. Create a multiple-zone instance in us-central1-b.
    3. Create a read replica in us-east1-b.
  • C. 1. Provision a Cloud SQL for MySQL instance in us-central1-a.
    2. Create a multiple-zone instance in us-east-b.
    3. Create a read replica in us-east1-c.
  • D. 1. Provision a Cloud SQL for MySQL instance in us-central1-a.
    2. Create a multiple-zone instance in us-east1-b.
    3. Create a read replica in us-central1-b.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by fredcaram at Dec. 20, 2022, 10:47 p.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
Steve8512
4 weeks, 1 day ago
Selected Answer: B
The answers are badly worded. B looks right, but reads like there will be two instances, one single-zone and one HA, in the same region. Presumably it's actually describing a single HA instance in central1.
upvoted 1 times
...
Ral17
4 months, 3 weeks ago
Selected Answer: B
Cloud SQL is a regional service with read replicas allowed in other regions. So the answer must reference 2 different zones in the us-central1 region, one for the primary and one for the HA replica. A read replica needs to be in a zone within us-east1.
upvoted 1 times
...
dynamic_dba
1 year, 1 month ago
B. Cloud SQL is a regional service with read replicas allowed in other regions. So the answer must reference 2 different zones in the us-central1 region, one for the primary and one for the HA replica. A read replica needs to be in a zone within us-east1. The only options which provides that is B.
upvoted 4 times
...
sp57
1 year, 4 months ago
B is correct. DR write-up helps... https://cloud.google.com/sql/docs/sqlserver/intro-to-cloud-sql-disaster-recovery
upvoted 2 times
...
pk349
1 year, 4 months ago
D: Provision a Cloud SQL for MySQL instance in us-central1-a. Create a multiple-zone instance in ***** us-east1-b. Create a read replica in us-central1-b.
upvoted 1 times
...
GCP72
1 year, 4 months ago
Selected Answer: B
B is the correct answer
upvoted 4 times
...
chelbsik
1 year, 4 months ago
Selected Answer: B
Very confusing description. My only guess is that steps 1 and 2 describe the same action - creating primary instance with multiple zones HA. This eliminates all answers but B, because you can only have HA setup within the same region.
upvoted 2 times
...
range9005
1 year, 4 months ago
I guess D Primary Instance Us-Central For HA, Multi-Region us-east Replica on the top of primary i.e Us-central for low latency
upvoted 1 times
...
fredcaram
1 year, 4 months ago
I got a little confused about the text, for B to be the correct answer the multiple-zone instance would be the stand-by instance and the read replica would be the cross-region read replica.
upvoted 1 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