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

Suggested Answer: DE 🗳️

by range9005 at Dec. 19, 2022, 3:50 a.m.

Comments

Submit Cancel

dynamic_dba

Highly Voted 1 year, 10 months 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 5 months, 3 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

7 months ago

Selected Answer: DE

Agree with D, E

upvoted 2 times

...

hanayome

7 months, 1 week 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, 3 months ago

Vote for D, E.

upvoted 2 times

...

Nirca

1 year, 9 months ago

Selected Answer: DE

Only valid options.

upvoted 3 times

...

chelbsik

1 year, 11 months ago

Selected Answer: DE

Vote for DE, seems only reasonable options to me

upvoted 4 times

...

omermahgoub

1 year, 11 months 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

1 year, 11 months ago

Selected Answer: DE

D,E is the correct answer

upvoted 3 times

...

range9005

1 year, 11 months ago

Selected Answer: DE

Enable point-in-time recovery. Schedule automated backups.

upvoted 3 times

...

H_S

1 year, 12 months ago

Selected Answer: DE

D. Enable point-in-time recovery. E. Schedule automated backups

upvoted 1 times

...

omermahgoub

1 year, 12 months 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

1 year, 12 months 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

1 year, 12 months ago

Selected Answer: DE

https://cloud.google.com/sql/docs/mysql/high-availability#backups-and-restores

upvoted 2 times

...

Popa

1 year, 12 months ago

Answer is D and E. https://cloud.google.com/sql/docs/mysql/high-availability#backups-and-restores

upvoted 1 times

...

range9005

1 year, 12 months 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

...