Answer-first summary for fast verification
Answer: 1. Enable automatic storage increase for the instance. 2. Create a Stackdriver alert when CPU usage exceeds 75%, and change the instance type to reduce CPU usage. 3. Create a Stackdriver alert for replication lag, and shard the database to reduce replication time.
Option A is the correct answer because it addresses all three requirements effectively. It enables automatic storage increase for the instance to ensure you don't run out of storage. It creates a Stackdriver alert when CPU usage exceeds 75% and suggests changing the instance type to reduce CPU usage, which helps in maintaining CPU utilization. Lastly, it creates a Stackdriver alert for replication lag and sharding the database to reduce replication time, which addresses the need to keep replication lag below 60 seconds. Other options either do not fully meet all the requirements or include unnecessary steps like specifying a 32-core machine type without context, which may not be optimal or necessary.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You are using Google Cloud SQL as the database backend for a large Customer Relationship Management (CRM) deployment. As your user base grows, you need to ensure scalability and availability. Specifically, you want to achieve three main goals: 1) Avoid running out of storage, 2) Maintain CPU usage below 75%, and 3) Ensure replication lag remains under 60 seconds. Considering these requirements, what are the correct steps to meet your objectives?
A
B
C
D