AZ-204 Develop Azure compute solutions Practice Question
A web app experiences intermittent high latency. You discover that the Azure SQL database is experiencing a high number of connection timeouts. The application uses Entity Framework Core with the default connection pooling settings. You need to improve database connection reliability without changing the application code. What should you do?
⚠ Common exam trap
A common mix-up: candidates assume increasing the maximum pool size solves all connection issues, but the real problem is the delay in creating new connections from an empty pool, which is addressed by setting a minimum pool size.
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
✓
Set the Minimum Pool Size to 10 in the connection string.
Setting the Minimum Pool Size to 10 pre-creates a baseline of open connections in the pool, reducing the frequency of new connection creations during traffic spikes. This mitigates intermittent connection timeouts caused by the default pool starting empty and struggling to keep up with demand under high latency. Since the application uses Entity Framework Core with default pooling, this change is applied via the connection string without modifying code.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Set the Minimum Pool Size to 10 in the connection string.
Why this is correct
Intermittent high latency often indicates significant overhead associated with establishing new database connections. Setting the 'Min Pool Size' to a value like 10 ensures that at least ten connections are always kept open and ready in the connection pool, even when returned by the application. This significantly reduces the time required to acquire a connection during demand spikes, as new physical connections do not need to be created, directly mitigating latency caused by connection establishment.
- ✗
Increase the maximum pool size in the connection string.
Why it's wrong here
Increasing the 'Max Pool Size' allows the connection pool to grow to accommodate a greater number of concurrent active connections. While this can prevent connection starvation and 'connection busy' errors under extremely heavy load, it does not address the root cause of intermittent high latency if the issue stems from the initial creation of connections when the pool is empty or has too few available. A larger maximum alone won't prevent delays if the application frequently needs to establish new physical connections because the minimum is too low.
- ✗
Set the Connection Lifetime to 300 seconds.
Why it's wrong here
The 'Connection Lifetime' parameter specifies the maximum duration (in seconds) a connection can remain in the pool before being automatically disposed, regardless of its activity. While a valid connection string property for ADO.NET providers, its primary purpose is to ensure connections are periodically refreshed, which can be useful for load balancing or handling transient network issues. It does not directly resolve intermittent high latency caused by the initial overhead of establishing connections, as it focuses on connection aging rather than immediate availability.
- ✗
Enable Multipool in the connection string.
Why it's wrong here
The term 'Multipool' is not a recognized or valid connection string parameter for standard ADO.NET or Entity Framework Core database providers, such as those used for SQL Server, Azure SQL Database, or other common relational databases. Including an invalid parameter in a connection string will typically result in a configuration error or simply be ignored by the provider, offering no functional benefit to address or mitigate intermittent high latency issues. This option represents a non-existent configuration setting.
Go deeper
Related to this question
About these practice questions
One of 881 original AZ-204 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This AZ-204 practice question is part of Courseiva's free Microsoft 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 AZ-204 exam.