Practice Test 3 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
A company wants to migrate its on-premise MySQL relational database to the cloud. The company is looking for a cost-effective solution that grants the same capabilities as their on-premise database. The company mentions that the performance is not an issue and latency is acceptable. However, their main demand is high availability with minimum costs. What would you do in this situation?
A. Use BigTable with 10-node cluster.
B. Use Cloud Spanner multi-regional instance with multiple nodes.
C. Use Cloud SQL with read replicas.
D. Use Cloud SQL with fail-over replicas.
Correct Answer: D
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.
Option A is incorrect: BigTable is a NoSQL table.
Option B is incorrect: Cloud Spanner can be an expensive approach while the scenario is seeking a cost-efficient alternative for their on-premise database.
Option C is incorrect: A read replica is a copy of the master that reflects changes to the master instance in almost real time. The main purpose of reading replicas is for additional read capacity for analytics. Read replicas are NOT for failure recovery in case the primary database is out of service.
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.