- A
Increase the maximum connections setting on the Cloud SQL instance and also increase the instance's tier to handle more concurrent connections.
Why wrong: Option A only temporarily resolves the symptom but does not scale efficiently; the database may still become a bottleneck.
- B
Migrate the database to Cloud Spanner to provide unlimited scalability and automatic sharding.
Why wrong: Option C is an expensive and complex migration that may not be necessary for this use case.
- C
Implement a connection pooling library in the application code to reuse database connections and reduce the number of new connections.
Why wrong: Option D is helpful but does not address the server-side connection limit; the proxy provides a more efficient solution.
- D
Deploy the Cloud SQL Proxy on each Compute Engine instance to manage database connections more efficiently, and configure a connection pool size that matches the maximum connections of the Cloud SQL instance.
Option B reduces the number of open connections and efficiently distributes them.
Quick Answer
The correct answer is to deploy the Cloud SQL Proxy on each Compute Engine instance and configure a connection pool size that matches the Cloud SQL instance’s maximum connections. This solution directly addresses the connection limit exceeded during a traffic spike by centralizing and reusing database connections through the proxy, which acts as a lightweight, secure intermediary that prevents the application from opening too many concurrent connections. The proxy’s connection pooling reduces the overhead of establishing new connections, ensuring that even as the managed instance group scales up, the total connections stay within Cloud SQL’s limit. On the Google Professional Cloud Architect exam, this scenario tests your understanding of database connection management under autoscaling—a common trap is to simply increase the Cloud SQL instance tier, which only postpones the bottleneck without solving the connection reuse problem. A key memory tip: think of the Cloud SQL Proxy as a “traffic cop” that limits how many cars (connections) enter the database at once, keeping the road clear during a flash sale.
Google PCA Ensure solution and operations reliability Practice Question
This PCA practice question tests your understanding of ensure solution and operations reliability. This is a configuration task: choose the command set that satisfies every stated requirement. Small differences — like 'secret' vs 'password' or 'transport input ssh' vs 'all' — change whether the answer is correct. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
Your company runs an e-commerce platform on Google Cloud. The application is deployed on Compute Engine instances in a managed instance group (MIG) with autoscaling based on CPU utilization. The database uses Cloud SQL for MySQL with a single instance. During a recent flash sale, traffic spiked and the application became slow, resulting in a poor user experience. After analyzing the incident, you discovered that the MIG scaled up but the Cloud SQL instance reached its maximum connections limit, causing some requests to fail. You need to recommend a solution to improve the reliability of the application for future traffic spikes. What should you do?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
Deploy the Cloud SQL Proxy on each Compute Engine instance to manage database connections more efficiently, and configure a connection pool size that matches the maximum connections of the Cloud SQL instance.
Option D is correct because deploying the Cloud SQL Proxy on each Compute Engine instance provides a secure, efficient way to manage database connections. The proxy can be configured with a connection pool size that matches the Cloud SQL instance's maximum connections, preventing the application from exhausting the database's connection limit. This approach also reduces the overhead of establishing new connections and improves connection reuse, directly addressing the bottleneck during traffic spikes.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Increase the maximum connections setting on the Cloud SQL instance and also increase the instance's tier to handle more concurrent connections.
Why it's wrong here
Option A only temporarily resolves the symptom but does not scale efficiently; the database may still become a bottleneck.
- ✗
Migrate the database to Cloud Spanner to provide unlimited scalability and automatic sharding.
Why it's wrong here
Option C is an expensive and complex migration that may not be necessary for this use case.
- ✗
Implement a connection pooling library in the application code to reuse database connections and reduce the number of new connections.
Why it's wrong here
Option D is helpful but does not address the server-side connection limit; the proxy provides a more efficient solution.
- ✓
Deploy the Cloud SQL Proxy on each Compute Engine instance to manage database connections more efficiently, and configure a connection pool size that matches the maximum connections of the Cloud SQL instance.
Why this is correct
Option B reduces the number of open connections and efficiently distributes them.
Related concept
Read the scenario before looking for a memorised answer.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates often assume increasing the database tier or max_connections is the simplest fix, but the PCA exam tests the understanding that connection pooling with a proxy is a more scalable and cost-effective reliability pattern, especially when combined with autoscaling compute instances.
Detailed technical explanation
How to think about this question
The Cloud SQL Proxy uses a local Unix socket or TCP connection to intercept database traffic, automatically handling TLS encryption and IAM authentication. By configuring the proxy's connection pool size to match the Cloud SQL instance's max_connections (default 100 for db-f1-micro, up to 4000 for high-memory tiers), you ensure that the application never attempts to open more connections than the database can handle. In practice, this prevents the 'too many connections' error and allows the MIG to scale without overwhelming the database.
KKey Concepts to Remember
- Read the scenario before looking for a memorised answer.
- Find the constraint that changes the correct option.
- Eliminate answers that are true in general but not in this case.
TExam Day Tips
- Watch for words such as best, first, most likely and least administrative effort.
- Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
How this comes up in practice
A media company stores terabytes of video archives that are accessed once a year for audit purposes. Moving these objects to a cold storage tier (Azure Archive, S3 Glacier, or Google Nearline) costs a fraction of hot storage. Questions like this test whether you understand storage tiers, access frequency tradeoffs, and retrieval latency requirements.
What to study next
Got this wrong? Here's your next step.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
- →
Ensure solution and operations reliability — study guide chapter
Learn the concepts, then practise the questions
- →
Ensure solution and operations reliability practice questions
Targeted practice on this topic area only
- →
All PCA questions
509 questions across all exam domains
- →
Google Professional Cloud Architect study guide
Full concept coverage aligned to exam objectives
- →
PCA practice test guide
How to use practice tests most effectively before exam day
Related practice questions
Related PCA practice-question pages
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
Design and plan a cloud solution architecture practice questions
Practise PCA questions linked to Design and plan a cloud solution architecture.
Manage and provision cloud infrastructure practice questions
Practise PCA questions linked to Manage and provision cloud infrastructure.
Design for security and compliance practice questions
Practise PCA questions linked to Design for security and compliance.
Analyze and optimize technical and business processes practice questions
Practise PCA questions linked to Analyze and optimize technical and business processes.
Manage implementation of cloud architecture practice questions
Practise PCA questions linked to Manage implementation of cloud architecture.
Ensure solution and operations reliability practice questions
Practise PCA questions linked to Ensure solution and operations reliability.
PCA fundamentals practice questions
Practise PCA questions linked to PCA fundamentals.
PCA scenario practice questions
Practise PCA questions linked to PCA scenario.
PCA troubleshooting practice questions
Practise PCA questions linked to PCA troubleshooting.
Practice this exam
Start a free PCA practice session
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Questions learners often ask
What does this PCA question test?
Ensure solution and operations reliability — This question tests Ensure solution and operations reliability — Read the scenario before looking for a memorised answer..
What is the correct answer to this question?
The correct answer is: Deploy the Cloud SQL Proxy on each Compute Engine instance to manage database connections more efficiently, and configure a connection pool size that matches the maximum connections of the Cloud SQL instance. — Option D is correct because deploying the Cloud SQL Proxy on each Compute Engine instance provides a secure, efficient way to manage database connections. The proxy can be configured with a connection pool size that matches the Cloud SQL instance's maximum connections, preventing the application from exhausting the database's connection limit. This approach also reduces the overhead of establishing new connections and improves connection reuse, directly addressing the bottleneck during traffic spikes.
What should I do if I get this PCA question wrong?
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
What is the key concept behind this question?
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jun 11, 2026
This PCA practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PCA exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.