DRAG DROP
Exhibit:

<ApplicationMenu>
<MenuItem name’Code’>
<MenuItem name=’Region’>
<MenuItem name’Web Site’>
<MenuItem name=’Flamenco’>
<MenuItem name=”Employees”>
<MenuItem name’PassGuide Office”>
</MenuItem>
</MenuItem>
</ApplicationMenu’>
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp includes some XML code being displayed in the exhibit.
PassGuideApp uses the Xml Document class to query the XML.
PassGuideApp must return all descendant elements of the specific Menuitem elment that
has a name attribute Flamenco.
Which XPATH expression should be used?

DRAG DROP
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server 2008 database PassGuideDB.
PassGuideApp is calling a stored procedure that is using a spatial value parameter.
What steps do you need to take to make this work?

DRAG DROP
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server 2008 database PassGuideDB.
PassGuideApp is calling a stored procedure that has a table-valued parameter.
What steps do you need to take to make this work?

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server 2008 database PassGuideDB.
PassGuideApp uses Data Contexts to access data from the database.
The Data Contexts allows PassGuideApp online changes to be submitted back to the SQL
Server.
PassGuideApp stores Employee data offline.
PassGuideApp enables end users to edit employee records while they are not connected to
PassGuideDB.
PassGuideApp must be able to detect conflicts between the offline and online data.
PassGuideApp must allow rollback of offline updates.
What action should be taken? Select all that apply.

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server 2008 database PassGuideDB.
PassGuideApp uses EDM to model entities. These entities includes Employees to
PassGuideDB.
You must add a new Employees entity, but you do not want to set all properties of the
entity.
What should you do? Select three.

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to several SQL Server databases.
Within PassGuideApp there is a function PG_fn.
PG_fn changes a product record, that are stored in severalSQL Server databases, within a
single transaction.
How can ensure that the transactions can be recovered? Select two.

DRAG DROP
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp uses this service to connect to a MS SQL Server 2008 database
PassGuideDB.
To access data from PassGuideDB ADO.NET Entity Framework is used.
PassGuideApp manages Product and Product_details records.
A new Product_details record, for an existing product, is added. How can you associate the
new Product_details record to the correct Product details.

DRAG DROP
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server 2008 database PassGuideDB.
PassGuideApp uses EDU to model entities. These entities includes Product and
Product_details.
PassGuideApp is a multi-tier application.

You are going to do a search on the Product table. To make the search faster you deattach
Product_details.
The search is performed.
How can you at this point ensure that any changed made on the Product_details (by end
users for example) are saved in PassGuideDB as well.

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to several SQL Server databases.
Within PassGuideApp there is a function PG_fn.
PG_fn changes a product record, that are stored in severalSQL Server databases, within a
single transaction.
Assume there is a resource failure.
How can you ensure that the unresolved transactions can be managed? Select two.

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a SQL Server database over the local network.
PassGuideApp uses data from different related database tables.
Assume there the connection is unavailable or disconnected.
PassGuideApp must still work in this circumstance.
How can you achieve this? Select two.