exam questions

Exam Professional Cloud Database Engineer All Questions

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

Exam Professional Cloud Database Engineer topic 1 question 82 discussion

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

You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You need to test the high availability of your Cloud SQL instance by performing a failover. You want to use the cloud command. What should you do?

  • A. Use gcloud sql instances failover <PrimaryInstanceName>.
  • B. Use gcloud sql instances failover <ReplicaInstanceName>.
  • C. Use gcloud sql instances promote-replica <PrimaryInstanceName>.
  • D. Use gcloud sql instances promote-replica <ReplicaInstanceName>.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

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
dynamic_dba
Highly Voted 10 months, 4 weeks ago
A. We are not promoting a read replica to be the primary instance. Eliminate C and D. When HA is enabled you only deal with the primary instance name, so B doesn’t make sense. That leaves A.
upvoted 7 times
...
chelbsik
Highly Voted 1 year, 1 month ago
Selected Answer: A
Since primary instance is HA, it can failover between it's two intances
upvoted 6 times
...
887ad17
Most Recent 1 week, 3 days ago
Selected Answer: A
gcloud sql instances failover <PrimaryInstanceName>
upvoted 1 times
...
Pime13
3 months ago
Selected Answer: A
https://cloud.google.com/sdk/gcloud/reference/sql/instances/failover
upvoted 2 times
...
learnazureportal
4 months, 3 weeks ago
correct answer is B! When you initiate the failover on the replica instance, it will be promoted to the primary instance, simulating a high-availability failover event. option A is not the recommended!
upvoted 1 times
...
pk349
1 year, 1 month ago
A: Use gcloud sql instances failover ***** <PrimaryInstanceName>.
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago