Answer-first summary for fast verification
Answer: Enable binary logging and backups for the instance
The correct answer is **B** because enabling binary logging and backups is essential for performing Point In Time Recovery (PITR) in Cloud SQL. This setup allows the recovery of an instance to a specific point in time by creating a new instance with the data up to that moment. It's important to have continuous binary logs since the last backup before the event you wish to recover from. Options A and D are incorrect as Read and Failover replicas do not support PITR. Option C is also incorrect as switching to Cloud Spanner is not necessary for enabling PITR in Cloud SQL.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A company relies on Cloud SQL for hosting critical data and wishes to implement Point In Time Recovery (PITR) to restore the instance to a specific moment. What is the correct configuration to achieve this?
A
Switch to a Spanner 3 node cluster
B
Enable binary logging and backups for the instance
C
Create a Read replica for the instance
D
Create a Failover replica for the instance