Answer-first summary for fast verification
Answer: Activate binary logging.
The correct answer is **C** because binary logging is essential for point-in-time recovery, allowing you to restore an instance to a specific moment. This method always generates a new instance, as recovery to an existing one isn't possible. - **Options A & B** are incorrect as using a Read Replica or Cloud Spanner are not the most economical choices for this requirement. - **Option D** is also incorrect since hourly backups do not fulfill the point-in-time recovery need.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
For a new proof-of-concept application requiring a regional MySQL database with point-in-time recovery, what is the most cost-effective method to enable this feature?
A
Set up replication to a Cloud Spanner database.
B
Establish a read replica within the same region.
C
Activate binary logging.
D
Implement hourly backups.
No comments yet.