Question-48: Cloud SQL Second Generation use MySQL's semi-synchronous replication, RDS for MySQL utilises block-level synchronous replication, and Aurora utilises a replication solution that is entirely proprietary. A Sysbench OLTP workload was produced from a MySQL client located in the same zone as the main database instance. This was done in order to assess throughput. You are in the process of establishing a single Cloud SQL MySQL database of the second generation that includes data that is vital to the operation of your organisation. You want to make sure that you only lose the bare minimum of data in the event that anything terrible happens. Which two features should you make available to users? (Choose two.)
A. Sharding
B. Read replicas
C. Binary logging
D. Automated backups
E. Semisynchronous replication

Get All 340 Questions and Answer for Google Professional Cloud Architect