Topic 1 Question 108
2 つ選択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?
Sharding
Read replicas
Binary logging
Automated backups
Semisynchronous replication
解説
Backups help you restore lost data to your Cloud SQL instance. Additionally, if an instance is having a problem, you can restore it to a previous state by using the backup to overwrite it. Enable automated backups for any instance that contains necessary data. Backups protect your data from loss or damage. Enabling automated backups, along with binary logging, is also required for some operations, such as clone and replica creation. Reference: https://cloud.google.com/sql/docs/mysql/backup-recovery/backups
ユーザの投票
コメント(17)
Ans) C and D Cloud SQL. If you use Cloud SQL, the fully managed Google Cloud MySQL database, you should enable automated backups and binary logging for your Cloud SQL instances. This allows you to perform a point-in-time recovery, which restores your database from a backup and recovers it to a fresh Cloud SQL instance
👍 27kopper20192021/07/01C. Binary logging D. Automated backups
👍 10victory1082021/07/10- 正解だと思う選択肢: CD
Data lose is being managed via datafiles/database backups. Once a day or once every time interval. Between backups the logs(redo/bin logs/archive logs) must be copied on a continuous manner. Only that way point in time recovery or full recovery without data loss might be successful. Else you will be able to backup-restore. AND not backup-restore-recovery.
👍 6Nirca2022/06/19
シャッフルモード