Online Access Free 070-519 Practice Test

You are designing an ASP.NET Web application that displays daily sales information.
The sales information is stored in a large Microsoft SQL Server database.
The database information is updated each night.
During the day, people use the Web application to display a set of standard sales reports based on the latest database information.
The SQL queries that are required to retrieve and display the database information can take from 20 to 30 seconds to execute.
You need to design the application to ensure that pages usually load in no more than 5 seconds.
Which two approaches could you recommend? (Each correct answer presents a complete solution. Choose two.)

• A.Use a service that proxies the database queries and caches the results
• B.Use a control that retrieves and displays the database information
• C.Use AJAX to retrieve the database information
• D.Use SQL Server replication

You are designing a plan to scale an ASP.NET Web application to support up to 20,000 concurrent users.
Application usage statistics indicate that many queries against the database retrieve data that does not change frequently.
You need to reduce database round trips for static data.
Which approach should you recommend?

• A.Use multiple active result sets.
• B.Use SQL Server replication.
• C.Use the application cache.
• D.Use session state.

An ASP.NET Web application contains a class named Money. The Money class has properties named Value and Currency.
The Locals window of the Microsoft Visual Studio 2010 IDE currently displays the Value and Currency properties only when the Money object is expanded.
You have the following requirements:
Display the Value and Currency property values in the Locals window.
Display the property values without requiring the developer to expand the Money object.
You need to recommend an approach for modifying the Money class to meet the requirements.
What should you do?

• A.In the constructor, create a new instance of the LocalsItemDescription class for each of the Value and Currency properties.
• B.Apply the DebuggerDisplay attribute to the class.
• C.In the Value and Currency property setters, call the Debug.WriteLine() method.
• D.Modify the class to inherit from the LocalVariableInfo class. Override the IsPinned property to return true.

You are designing an ASP.NET Web application that will be deployed both to a server that
runs IIS 6 and to a server that runs IIS 7.0.
The Web application must meet the following requirements:
You need to recommend an approach for handling errors.
What should you recommend?

• A.Create an error handler for the HttpApplication.LogRequest event.
• B.In the customErrors element of the Web.config file, set the mode attribute to On.
• C.In the customErrors element of the Web.config file, set the defaultRedirect attribute to errors.htm.
• D.Create an error handler for the Application_Error event.

You are designing the deployment strategy for an ASP.NET Web application.
You need to recommend an approach for displaying a maintenance notice to users while deploying a new version of the Web application.
What should you recommend?

• A.Place a file named app_offline.aspx in the root of the Web application folder.
• B.In the Web.config file, under the system.web/httpRuntime element, set the enable attribute to false.
• C.In the Web.config file, under the system.web/httpModules element, add a clear element.
• D.Place a file named app_offiine.htm in the root of the Web application folder.