Answer-first summary for fast verification
Answer: Enable Binary logging and backups for the instance
The correct answer is **C** because enabling binary logging and backups is essential for performing Point In Time Recovery (PITR) in Cloud SQL. PITR allows you to recover an instance to a specific point in time by creating a new instance. It requires binary logging and backups to be enabled, with continuous binary logs since the last backup before the event you want to recover from. Options **A** and **D** are incorrect because neither switching to Cloud Spanner nor creating Read or Failover replicas aids in PITR. Option **B** is also incorrect as it does not contribute to the PITR process.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A company is utilizing Cloud SQL to host critical data and wishes to enable Point In Time Recovery (PITR) to recover the instance to a specific point in time. What is the correct configuration to achieve this?
A
Switch to a Spanner 3 node cluster
B
Create a Read replica for the instance
C
Enable Binary logging and backups for the instance
D
Create a Failover replica for the instance
No comments yet.