Exam Professional Cloud Database Engineer topic 1 question 61 discussion

Actual exam question from Google's Professional Cloud Database Engineer

Question #: 61
Topic #: 1

[All Professional Cloud Database Engineer Questions]

You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?

A. Create a clone database from a read replica database, and restore the clone in the same region.
B. Create a clone database from a read replica database, and restore the clone into a different zone.
C. Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.
D. Use the Cloud SQL database import feature. Import last week's dump file from Cloud Storage.

Show Suggested Answer

Suggested Answer: C 🗳️

by pk349 at Dec. 25, 2022, 12:09 a.m.

Comments

Submit Cancel

chelbsik

Highly Voted 11 months, 4 weeks ago

Selected Answer: C

I'll go for C

upvoted 6 times

...

dynamic_dba

Highly Voted 9 months, 1 week ago

C. An HA configuration means a primary instance and a failover replica instance. There is no read replica unless you specifically create one. Hence, A and B are wrong. D is wrong since the question doesn’t mention logical backups, whereas an HA configuration would have automatic (physical) backups enabled. A PIT restore is the only answer here.

upvoted 5 times

...

Ral17

Most Recent 5 months, 3 weeks ago

Selected Answer: C

PITR is the best option here.

upvoted 1 times

...

Nirca

9 months, 2 weeks ago

Selected Answer: C

Logical corruption like deleted records will be pushed to the read replica. Using import/export from last week is slow for large scale databases and will restore database from last week. So C - restoring using point in time option - is ok.

upvoted 1 times

...

zanhsieh

10 months ago

Selected Answer: D

D. PITR always restore to a **NEW** db instance, but the question does not ask to change the application configuration.

upvoted 1 times

zanhsieh

2 months, 2 weeks ago

https://cloud.google.com/sql/docs/postgres/backup-recovery/restore#tips-pitr

upvoted 1 times

...

pk349

12 months ago

C: Use the Cloud SQL point-in-time recovery *** (PITR) feature. Restore the copy from two hours ago to a new database instance. Point-in-time recovery allows you to recover an instance to a specific point in time. For example, if an operator 'fat finger' error causes a loss of data you can recover a database to the state it was just before the error occurred.

upvoted 1 times

...