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

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.

Answer:

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.

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

Previous QuestionNext Question
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.
You are creating an ASP.NET page for a travel service. The page contains a CheckBoxList
control that contains travel destinations. Customer can select favorite destinations to receive
weekly e-mail updates of travel packages.
The CheckBoxList control is bound to a database table of possible destinations. Each destination
is ranked according to its popularity. You modify the page to sort the destination list by rank, from
the most popular to the least popular. The list has three columns.
You want the most popular destination to be on the top row of the check box list at run time.
Which property setting should you use for the CheckBoxList control?
A. Set the RepeatDirection property to Vertical.
B. Set the RepeatDirection property to Horizontal.
C. Set the RepeatLayout property to Flow.
D. Set the RepeatLayout property to Table.