Practice Test 2 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
You have a PostgreSQL database instance on Cloud SQL. The database is used in production by the different micro-services writing and reading to it based on each micro-service’s needs. Data analysts connect to the instance to run their analysis and reporting SQL queries which adds more load to the database with intensive I/O operations on it. You want to find a solution which can avoid intensive I/O operations on production database and allow data analysts to run their queries without interruptions may lead to late reports to management. What should you do?
A. Scale up Cloud SQL instance from standard to high CPU machine type.
B. Use Cloud SQL read replicas to replicate production instance. Share endpoint with data analysts to replace with existing endpoint in their SQL clients to use the replica.
C. Create a snapshot from production instance. Create a new Cloud SQL instance from the snapshot. Use Cloud Scheduler cron job to create a snapshot and a new instance daily.
D. Import data from Cloud SQL instance to BigQuery. Create necessary users on BigQuery dataset created for data analysts to run their SQL queries on.
Answer: B.
Description:
Cloud SQL provides the ability to replicate a master instance to one or more read replicas. A read replica is a copy of the master that reflects changes to the master instance in almost real time. You create a replica to offload read requests or analytics traffic from the master. You can create multiple read replicas for a single master instance. By default, the replica is created with the same number of CPUs and the same amount of memory as the master instance. You can increase these values for the replica, but you cannot decrease them.
Answer A is incorrect: Scaling up instance by CPU will not solve the core issue which is analysts using production instance for intensive reads.
Answer C & D are incorrect: While both approaches are viable, they require maintenance and implementation to be done by engineers. Google Cloud provides a fully-managed service called read replica can handle replicating production instance in near real-time manner.
Source(s):
Cloud SQL Instance Settings:
https://cloud.google.com/sql/docs/mysql/instance-settings
Cloud SQL PostgreSQL – Creating Read Replicas:
https://cloud.google.com/sql/docs/postgres/replication/create-replica
Comments are closed, but trackbacks and pingbacks are open.