PrepAway - Latest Free Exam Questions & Answers

Category: 70-516 (v.1)

Exam 70-516: TS: Accessing Data with Microsoft .NET Framework 4 (update August 18th, 2014)

You are required to provide code which returns a list of the orders and a list of the order_details.

2 comments

DRAG DROP
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server database PassGuideDB.
To obtain data from PassGuideDB ADO.NET LINQ to SQL model is used.
PassGuideApp includes Order and Order_details entities.
You are required to provide code which returns a list of the orders and a list of the
order_details.
This code must run one single SQL statement.
Which code can you use?

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.

2 comments

DRAG DROP
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp uses the ADO.NET EntityFramework.
PassGuideApp connects to the MS SQL Server database PassGuideDB.
PassGuideApp needs to handle concurrency conflicts.
PassGuideApp also needs to ensure that local changes are saved in PassGuideDB.

You need to use this dataset to access rows where the Name field is not null.

2 comments

DRAG DROP
Exhibit:
ee.SELECT EmployeeID, Name, Region, Country FROM dbo.Employees .
There is a MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server 2008 database PassGuideDB.
A SQL statement is used to retrieve dataset instance (see exhibit).
You need to use this dataset to access rows where the Name field is not null.
Which code should you use?

Which XPATH expression should be used?

2 comments

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?

Which URL should you use?

2 comments

DRAG DROP
Exhibit:
Country=England AND Salary > 20000
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
An ASF data service service is created.
This service use the URL http://PassGuide.com/PassGuide.svc.
The service return employee objects sorted by in ascending order by country and salary.
Only objects meeting the criteria displayed in the exhibit should be retrieved.
Which URL should you use?

You need to an HTTP request to update the Country property of an Employees record which has a value of as 1000

4 comments

DRAG DROP
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
An WCF data service service is created.
This service use the URL http://PassGuide.com/PassGuide.svc.
You need to an HTTP request to update the Country property of an Employees record
which has a value of as 1000. The other properties should not be changed.


Page 3 of 812345...Last »