MCSD.NET - 70-315 Exam Interview Preparation Guide
MCSD.NET - 70-315 Exam guideline for job interview preparation. Explore list of MCSD.NET - 70-315 Exam frequently asked questions(FAQs) asked in number of MCSD.NET - 70-315 Exam interviews. Post your comments as your suggestions, questions and answers on any MCSD.NET - 70-315 Exam Interview Question or answer. Ask MCSD.NET - 70-315 Exam Question, your question will be answered by our fellow friends.16 MCSD.NET - 70-315 Exam Questions and Answers:
1 :: 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.
B. Add the following directive to the page:
OutputCache VaryByParam=?city?
OutputCache VaryByParam=?city?
2 :: Suppose You are creating an ASP.NET page for XYZ. You create a DataGrid control that displays past
purchases made by the user. The DataGrid control is populated from an existing database when
the page is created.
The page contains TextBox controls that allow users to update their personal information, such as
address and telephone number.
You need to ensure that the page is refreshed as quickly as possible when users update their
contact information.
What should you do?
A. Set the Enable property of the DataGrid control to false.
B. Set the EnableViewState property of the DataGrid to false.
C. Write code in the Page.Load event handler that populates the DataGrid control only when the
IsPostBack property of the page is false.
D. Write in the Page.Load event handler that populates the DataGrid control only when the
IsPostBack property of the page is true.
D. Write in the Page.Load event handler that populates the DataGrid control only when the
IsPostBack property of the page is true.
IsPostBack property of the page is true.
5 :: You create an ASP.NET application that produces sales reports for the XYZ corporation.
The sales data is stored in a Microsoft SQL Server database that is used for transaction
processing. The application consists of complex Transact-SQL statements.
Many users report that the report generation is taking longer to run each day. You need to
improve response times.
What are two possible ways to achieve this goal? (Each correct answer presents a complete
solution. Choose two)
A. Use an OleDbDataAdapter indexes exist on the SQL Server tables.
B. Ensure that appropriate indexes exist in the SQL Server tables.
C. Rewrite your SQL statements to use aliases for all table names.
D. Rewrite your direct SQL statements as stored procedures and call the stored procedures from
your application.
E. Configure queries to run in the security context of the user who is running the query.
B. Ensure that appropriate indexes exist in the SQL Server tables.
D. Rewrite your direct SQL statements as stored procedures and call the stored procedures from
your application.
D. Rewrite your direct SQL statements as stored procedures and call the stored procedures from
your application.
6 :: You are creating a Web site for XYZ. You receive product lists in the form of XML documents.
You are creating a procedure to extract information from these XML documents according to
criteria that your users will select.
When a user makes a request, you want the results of these requests to be returned as quickly
as possible. What should you do?
A. Create an XmlDataDocument object and load it with the XML data.
Use the DataSet property of the object to create a DataSet object.
Use a SQL SELECT statement to extract the requested data.
B. Create an XmlDataDocument object and load it with the XML data.
Use the SelectNodes method of the object to extract the requested data.
C. Create an XPathDocument object and load it with the XML data.
Call the CreateNavigator method to create an XPathNavigator object.
Call the Select method of the XPathNavigator object to run an XPath query that extracts the
requested data.
D. Create an XmlReader object.
Use the Read method of the object to stream through the XML data and to apply an Xpath
expression to extract the requested data.
C. Create an XPathDocument object and load it with the XML data.
Call the CreateNavigator method to create an XPathNavigator object.
Call the Select method of the XPathNavigator object to run an XPath query that extracts the
requested data.
Call the CreateNavigator method to create an XPathNavigator object.
Call the Select method of the XPathNavigator object to run an XPath query that extracts the
requested data.
9 :: Suppose You are planning the deployment of an ASP.NET application named XYZApp. XYZApp uses a
Visual Studio .NET component named DataAccess that will be shared with other applications on
your Web server.
You are using Visual Studio .NET to create a Windows Installer package. You need to deploy
DataAccess and the ASP.NET application so that they can be uninstalled later if necessary.
What should you do?
A. Create a setup project for DataAccess.
Add the ASP.NET application in a custom action.
B. Create a setup project for the ASP.NET application.
Create another setup project for DataAccess.
C. Create a Web setup project for the ASP.NET application.
Add a project output for DataAccess.
D. Create a Web setup project for the ASP.NET application.
Add a merge module for DataAccess.
D. Create a Web setup project for the ASP.NET application.
Add a merge module for DataAccess.
Add a merge module for DataAccess.
10 :: Suppose You are creating an ASP.NET application for XYZ. Your application will call an XML Web service
run by Wide World Importers. The XML Web service will return an ADO.NET DataSet object
containing a list of companies that purchase wine.
You need to make the XML Web service available to your application.
What should you do?
A. On the .NET tab of the Reference dialog box, select System.Web.Services.dll.
B. In the Web References dialog box, type the address of the XML Web service.
C. Add a using statement to your Global.asax.cs file, and specify the address of the XML Web
service.
D. Write an event handler in the Global.asax.cs file to import the .wsdl and .disco files associated
with the XML Web service.
B. In the Web References dialog box, type the address of the XML Web service.