Which three actions should you perform?

You are developing an application that connects to a Microsoft SQL Server database using the SqlConnection object. Your connection objects are being pooled. As the pool fills up, connection requests are queued. Some connection requests are rejected. You need to ensure that the application releases connections back to the pool as soon as possible. Also, you need to decrease the likelihood that connection requests will be rejected. Which three actions should you perform?
(Each correct answer presents part of the solution. Choose three.)

You are developing an application that connects to a Microsoft SQL Server database using the SqlConnection object. Your connection objects are being pooled. As the pool fills up, connection requests are queued. Some connection requests are rejected. You need to ensure that the application releases connections back to the pool as soon as possible. Also, you need to decrease the likelihood that connection requests will be rejected. Which three actions should you perform?
(Each correct answer presents part of the solution. Choose three.)

A.
Ensure that the Close method is called on each connection object after it has finished executing.

B.
Ensure that each connection object is left open after it has finished executing.

C.
Increase the Max Pool Size value inside the connection string.

D.
Increase the Min Pool Size value inside the connection string.

E.
Increase the Connection Lifetime value inside the connection string.

F.
Increase the value of the ConnectionTimeout property of the SqlConnection object.



Leave a Reply 0

Your email address will not be published. Required fields are marked *