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 need to specify the connection string, stored in app.config, for PassGuideApp

DRAG DROP
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server 2008 database PassGuide.
Windows Authentication is used.
To obtain data from PassGuideDB the ADO .NET Entity Framework is used.
In the file PassGuide.Data.dll the three files (model.csdl, model.ssdl, and model.msi)
embedded as resources using EDM. You need to specify the connection string, stored in
app.config, for PassGuideApp.

You want to set up the connection between PassGuideApp and PassGuideDB.

DRAG DROP
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server Express 2008 database PassGuideDB.
The primary database file of PassGuideDB is PassGuideDB.mdf.
PassGuideDB.mdf is stored in the App_data folder.
You want to set up the connection between PassGuideApp and PassGuideDB.
What do you need to do?

How can you ensure that the orders are stored on the locate data store?

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server 2008 database PassGuideDB on server
PassGuideSrv.
PassGuideApp uses a Microsoft ADO.NET Entity Framework.
PassGuideApp manages an order database.
PassGuideApp obtains order data through a web service call from an order-tracking
system on PassGuideDB.
How can you ensure that the orders are stored on the locate data store? Select two.

How can you remedy this problem?

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
There is WCF Data Service service.
PassGuideApp uses this service to connect to a MS SQL Server 2008 database
PassGuideDB.
This service is hosted on a IIS 6.0 server.
However, when PassGuideApp issues DELETE and PUT request to the service an error
message is produced.
How can you remedy this problem? Select two.

How can this be achieved?

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server 2008 database PassGuideDB.
LINQ to SQL is used to define classes.
There are two objects named Product and Products_details.
There is a one-to-many relation from Product to Product_details on the ProductID field.
The Products_details table include the fields Weight and NumberOf
The total weight of each Product need to be calculated.
How can this be achieved?

How can this be achieved?

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server 2008 database PassGuideDB.
LINQ to SQL is used to define classes.
There are two objects named Product and Products_details.
There is a one-to-many relation from Product to Product_details on the ProductID field.
The Products_details table include the fields Weight and NumberOf
The total weight of each Product need to be calculated.
How can this be achieved?

How can this be achieved while keeping the used resources as small as possible?

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to the MS SQL Server database PassGuideDB.
PassGuideApp need all the data from PassGuideDB that are requested.
PassGuideApp does not change the data.
How can this be achieved while keeping the used resources as small as possible? Select
three.
Note: The ADO.NET LINQ to SQL model is used to retrieve the data.

How can change-tracking for these entities be used to update PassGuideDB?

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp uses the ADO.NET Entity Framework.
PassGuideApp connects to the MS SQL Server database PassGuideDB.
ADO.NET selftracking entities is used for the tracking. How can change-tracking for these
entities be used to update PassGuideDB? Select two.


Page 6 of 8« First...45678