Answer-first summary for fast verification
Answer: Binary logging, Automated backups
In order to minimize data loss in case of a catastrophic failure, you should implement 'Binary logging' and 'Automated backups'. Binary logging is a feature of MySQL that records all changes made to the database, which can be used to recover the database to a specific point in time. Automated backups create regular snapshots of your database, allowing for data restoration to the state at the time of the last backup. These features together ensure that you can recover almost all data with minimal loss. Sharding, read replicas, and semisynchronous replication primarily focus on performance, scaling, and availability, but do not directly address data loss prevention as effectively as binary logging and automated backups do.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your company is deploying a critical application that will use a Cloud SQL MySQL second-generation database to store transaction data. It is imperative to minimize data loss in the event of a catastrophic failure, such as a regional disaster or database corruption. To achieve this, which two features should you implement? (Choose two.)
A
Sharding
B
Read replicas
C
Binary logging
D
Automated backups
No comments yet.