Practice Test 1 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
You maintain a web service used by over 12,000 different clients. The service uses MySQL as its main data storage hosted on Google Cloud SQL. Since the service is critical and should be highly available at all times, this includes the MySQL database, considerations should be met so the service does not face any outage due to network connectivity or database having temporary outage. The service was not developed by your company so code refactoring is not currently possible. How can you ensure high availability for the web service’s database?
A. Scale up Cloud SQL instance to high CPU machine type.
B. Enable high availability on Cloud SQL instance by creating a read replica.
C. Migrate the database to BigQuery and use it as the main data storage instead.
D. Enable high availability on Cloud SQL instance by creating a fail-over replica.
Answer: D.
Description:
The failover replica in Cloud SQL is configured with the same database flags, users (including root) and passwords, authorized applications and networks, and databases as the primary instance. If an High-availability-configured instance becomes unresponsive, Cloud SQL automatically switches to serving data from the failover replica. This is called a failover.
Answer A is incorrect: Scaling up Cloud SQL instance does not ensure high availability.
Answer B is incorrect: Read replicas offer a copy of master (primary) instance to read from. In case the master instance is down, read replica will not be updated.
Answer C is incorrect: Migrating database to a different solution is not applicable based on the scenario because the service cannot be refactored.
Source(s):
Cloud SQL – MySQL High Availability:
https://cloud.google.com/sql/docs/mysql/high-availability
Cloud SQL – MySQL Replication Options:
Comments are closed, but trackbacks and pingbacks are open.