MCSD.NET - 70-315 Exam Interview Question:

Suppose You are creating an ASP.NET page for selling movie tickets. Users select a region, and then they
select from a list of cities in that region. The site displays the names and locations of movie
theaters in the city selected by the user.
Your company, XYZ Brothers, maintains a list of theaters in a database table that includes the
city, name, and street address of each theater. You want to minimize the time required to retrieve
and display the list of theater names after a user selects the region and city.
What should you do?
A. Modify the connection string to add the packet size property and set its values to 8192.
B. Add the following directive to the page:
OutputCache VaryByParam=?city?
C. Add the following directive to the page:
OutputCache VaryByControl=?region;city?
D. Modify the connection string to keep your database?s connection pool as small as possible.

Submitted by: Administrator

B. Add the following directive to the page:
OutputCache VaryByParam=?city?
Submitted by: Administrator