You are implementing a single Cloud SQL MySQL second-generation database that contains business-critical transaction data. You want to ensure that the minimum amount of data is lost in case of catastrophic failure. Which two features should you implement? (Choose two.)
Choose an answer
Tap an option to check your answer.
Correct answer: Binary logging, Automated backups.
Why this is the answer
Binary logging (binlog) records all data modifications to the database, enabling point-in-time recovery. This is crucial for minimizing data loss by allowing you to restore the database to a specific transaction just before a failure. Automated backups provide regular snapshots of your database. Combining these with binary logging allows you to restore from the latest backup and then apply the binlog to recover transactions that occurred after the backup, ensuring minimal data loss. Sharding distributes data across multiple database instances, primarily for scalability, not disaster recovery. Read replicas improve read performance and can offer some disaster recovery capabilities by providing a separate copy, but they don't inherently minimize data loss in the same way as binary logging and backups. Semisynchronous replication is a type of replication that ensures a transaction is committed on at least one replica before being committed on the primary, improving data consistency but not directly minimizing data loss as effectively as a robust backup and logging strategy for a single instance.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed