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

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

Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)

  • A. Set up manual backups.
  • B. Create a PostgreSQL database on-premises as the HA option.
  • C. Configure single zone availability for automated backups.
  • D. Enable point-in-time recovery.
  • E. Schedule automated backups.
Show Suggested Answer Hide Answer
Suggested Answer: DE 🗳️
by range9005 at Dec. 19, 2022, 3:50 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 ago
D,E. A is wrong because why bother configuring manual backups when Cloud SQL will automate that for you. B seems attractive, but why bother replicating back to on-prem when you can configure a Cloud SQL for HA. C is wrong because a single zone failure would not give you HA. That leaves D & E.
upvoted 7 times
...
Zakky_09
Most Recent 7 months, 2 weeks ago
Selected Answer: DE
To ensure high availability (HA) for your Cloud SQL instance and adhere to Google-recommended practices, you need to prioritize reliable backups and recovery mechanisms. D. Enable point-in-time recovery: This allows you to recover your database to a specific point in time in case of accidental data deletion or corruption. It ensures minimal data loss and quick recovery. E. Schedule automated backups: Automated backups ensure regular snapshots of your database are taken without manual intervention, providing a reliable recovery point in case of failures.
upvoted 1 times
...
dija123
8 months, 3 weeks ago
Selected Answer: DE
Agree with D, E
upvoted 2 times
...
hanayome
9 months ago
Selected Answer: DE
D and E because point in time recovery and schedule backup are HA efforts and CloudSQL already have these features
upvoted 2 times
...
goodsport
1 year, 4 months ago
Vote for D, E.
upvoted 2 times
...
Nirca
1 year, 11 months ago
Selected Answer: DE
Only valid options.
upvoted 3 times
...
chelbsik
2 years, 1 month ago
Selected Answer: DE
Vote for DE, seems only reasonable options to me
upvoted 4 times
...
omermahgoub
2 years, 1 month ago
To prepare your Cloud SQL instance for high availability, you should do the following: D. Enable point-in-time recovery - This feature allows you to restore your database to a specific point in time. It helps protect against data loss and can be used in the event of data corruption or accidental data deletion. E. Schedule automated backups - Automated backups allow you to take regular backups of your database without manual intervention. You can use these backups to restore your database in the event of data loss or corruption. Note that options A and C are not recommended practices for high availability. Option B is not related to Cloud SQL.
upvoted 3 times
...
GCP72
2 years, 1 month ago
Selected Answer: DE
D,E is the correct answer
upvoted 3 times
...
range9005
2 years, 1 month ago
Selected Answer: DE
Enable point-in-time recovery. Schedule automated backups.
upvoted 3 times
...
H_S
2 years, 1 month ago
Selected Answer: DE
D. Enable point-in-time recovery. E. Schedule automated backups
upvoted 1 times
...
omermahgoub
2 years, 1 month ago
D. Enable point-in-time recovery. E. Schedule automated backups. To prepare your Cloud SQL instance for high availability, Google recommends enabling point-in-time recovery and scheduling automated backups. Point-in-time recovery allows you to restore your database to a specific point in time, helping you to recover from data loss or corruption. Scheduling automated backups ensures that you have a recent copy of your database available for recovery in case of an outage or other issue.
upvoted 2 times
omermahgoub
2 years, 1 month ago
Option A, setting up manual backups, would not be a recommended practice because manual backups are prone to errors and can be time-consuming to create and maintain. Automated backups are a more reliable and efficient way to ensure that you have a recent copy of your database available for recovery. Option B, creating a PostgreSQL database on-premises as the HA option, would not be a recommended practice because it would not take advantage of the high availability features provided by Cloud SQL. Option C, configuring single zone availability for automated backups, would not be a recommended practice because it would not provide sufficient protection against outages or other issues. To ensure high availability, it is recommended to use a multi-zone configuration for your Cloud SQL instance.
upvoted 1 times
...
...
Popa
2 years, 1 month ago
Selected Answer: DE
https://cloud.google.com/sql/docs/mysql/high-availability#backups-and-restores
upvoted 2 times
...
Popa
2 years, 1 month ago
Answer is D and E. https://cloud.google.com/sql/docs/mysql/high-availability#backups-and-restores
upvoted 1 times
...
range9005
2 years, 1 month ago
Selected Answer: DE
Automated backups and point-in-time recovery must be enabled for high availability (point-in-time recovery uses binary logs). For more information check here -> https://cloud.google.com/sql/docs/mysql/high-availability#backups-and-restores
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