Topic 1 Question 61
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?
Create a clone database from a read replica database, and restore the clone in the same region.
Create a clone database from a read replica database, and restore the clone into a different zone.
Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.
Use the Cloud SQL database import feature. Import last week's dump file from Cloud Storage.
ユーザの投票
コメント(5)
- 正解だと思う選択肢: C
I'll go for C
👍 5chelbsik2022/12/25 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.
👍 2dynamic_dba2023/03/13C: 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.
👍 1pk3492022/12/24
シャッフルモード