How many connection pools are created?

You develop an ADO.NET application that uses a Microsoft SQL Server database and a SqlClient data provider. Your application includes the following four code segments, which are each called once:

SqlConnection myConnection1 = new SqlConnection();
myConnection1.ConnectionString = “Data Source=ProdServer;” + “Initial Catalog=Billing;Integrated Security=true”;
myConnection1.Open();

SqlConnection myConnection2 = new SqlConnection();

myConnection2.ConnectionString = “Data Source=ProdServer;” + “Initial Catalog=Billing;Integrated Security=true”;
myConnection2.Open();

SqlConnection myConnection3 = new SqlConnection();
myConnection3.ConnectionString =
“Data Source=SearchServer;”
+ “Initial Catalog=Search;Integrated Security=true”;
myConnection3.Open();

SqlConnection myConnection4 = new SqlConnection();
myConnection4.ConnectionString = “Data Source=ProdServer;” + “Initial Catalog=OrderEntry;Integrated Security=true”;
myConnection4.Open();

You verify that your application is the only application that is using SQL Server. Your application runs all code segments by using the same identity.

You run the application. Connection pooling is enabled, and the entire application runs within the
connection timeout parameter.

How many connection pools are created?

A.
one

B.
two

C.
three

D.
four