MCSD.NET - 70-315 Exam Interview Preparation Guide
Download PDF

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?

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.

3 :: You ASP.NET application manages order entry data by using a DataSet object named
EXorderEntry. The EXorderEntry object includes two DataTable objects named orderNames and
OrderDetails. A ForeignKeyConstraint object named orderDetailsKey is defined between the two
DataTable objects.
You attempt to delete a row in orderNames while there are related rows in OrderDetails, and an
exception is generated.
What is the most likely cause of the problem?
A. The current value of OrderDetails.KeyDeleteRule is Rule.Cascade.
B. The current value of OrderDetails.KeyDeleteRule is Rule.SetNull.
C. The current value of OrderDetails.KeyDeleteRule is Rule.SetDefault.
D. The current value of OrderDetails.KeyDeleteRule is Rule.None.

D. The current value of OrderDetails.KeyDeleteRule is Rule.None.

4 :: You create an ASP.NET page that uses images to identify areas where a user can click to initiate
actions. The users of the application use Internet Explorer.
You want to provide a pop-up window when the user moves the mouse pointer over an image.
You want the pop-up window to display text that identifies the action that will be taken if the user
clicks the image.
What should you do?
A. For each image, set the AlternateText property to specify the text you want to display, and set
the ToolTip property to True.
B. For each image, set the ToolTip property to specify the text you want to display.
C. In the onmouseover event handler for each image, add code that calls the RaiseBubbleEvent()
method of the System.Web.UI.WebControls.Image class.
D. In the onmouseover event handler for each image, add code that calls the ToString() method
of the System.Web.UI.WebControls.Image class.

B. For each image, set the ToolTip property to specify the text you want to display.

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.

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.