MCSD.NET - 70-315 Exam Question:
Download Questions PDF

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.

MCSD.NET - 70-315 Exam Interview Question

Answer:

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.

Download MCSD.NET - 70-315 Exam Interview Questions And Answers PDF

Previous Question

Next Question

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.

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.