You need to ensure that the application calls a stored procedure that accepts a table-valued parameter
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server 2008 database. You need to ensure that the
application calls a stored procedure that accepts a table-valued parameter. You create a
SqlParameter object. What should you do next?
You need to recommend an approach for identifying features that no longer work properly as a result of code ch
You are working with a Windows Presentation Foundation (WPF) application that uses .NET
Framework 4. Your team is responsible for making significant changes to the application
functionality. You need to recommend an approach for identifying features that no longer
work properly as a result of code changes Which testing methodology should you
recommend?
You need to retrieve all of the items in the list that have a value of True in their Urgent column
You have a SharePoint list named Assets that contains 1,000,000 items. The list contains a
column named Urgent. Approximately 100 items have a value of True in their Urgent column. You
use the following line of code to retrieve the Assets list. SPList assetsList = currentUeb.Lists
[“assets”]; You need to retrieve all of the items in the list that have a value of True in their Urgent
column. You must retrieve the items in the minimum amount of time. What should you do?
Which administrative tool should you use to achieve this task?
HOTSPOT
Your network contains a server named Server1 that runs Windows Server 2008 R2. You enable IPSec
on Server1. You need to identify which client computers have active IPSec associations to Server1.
Which administrative tool should you use to achieve this task? To answer, select the appropriate
tool from the answer area.
Which code segment should you use?
You use Microsoft Visual Studio 2010 and Microsoft Entity Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server database. You use the ADO.NET LINQ to SQL
model to retrieve data from the database. The applications contains the Category and Product
entities as shown in the following exhibit:
You need to ensure that LINO to SQL executes only a single SQL statement against the database. You
also need to ensure that the query returns the list of categories and the list of products. Which code
segment should you use?
What are two possible ways to achieve this goal?
You are designing a SharePoint 2010 solution. The solution includes the rendering of a
highly interactive control that must allow the following functionality: ·Fading items in and out.
.Dragging items around the display. .Seamlessly updating information on the server without
affecting other items on the page. You need to design the interactive control according to
these requirements. What are two possible ways to achieve this goal? (Each correct answer
presents a complete solution. Choose two.)
Get workflow data as well as related workstepflow.
Class Workflow – Has Workstepflow inside. Get workflow data as well as related workstepflow.
What should you recommend?
You are designing a Windows Forms application. The application connects to a Microsoft
SQL Server 2008 database. You need to recommend an approach for retrieving and logging
all informational messages and error messages reported by the database. What should you
recommend?
You need to create a query that generates the new XML result
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application. A
file named books.xml contains the following XML.
<bib>
<book title=”Programming in Unix” year=”1992″>
<author>Author1</author>
<author>Author2</author>
<author> Author 3 </author>
</book>
</bib>
The application must generate an XML result that contains an XML element named BookTitle for
each book.
The text content of the element must contain the title of the book.
You need to create a query that generates the new XML result. What should you do?
What should you recommend?
An ASP.NET Web application is deployed on a single Web server. Web application state for
client requests is stored in a Microsoft SQL Server 2008 database. The Web application
must meet the following requirements: Tolerate a Web server failure. Scale gracefully to
accommodate a rapid load increase. You need to recommend an approach for
accommodating a load increase. What should you recommend?