PrepAway - Latest Free Exam Questions & Answers

Tag: Exam 70-516 (update August 18th, 2014)

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

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.

you need to take? Select two.

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 is used.
There is a function PassGuidef.

PassGuidef is defined with the ADO.NET LINQ entities conceptual model.
PassGuidef needs to be called.
What action do you need to take? Select two.

which, if any, procedures should this mapping be applied?

Signature exhibit:
”CREATE procedure [dbo].[Job_Insert](@employeeId ,int, @quality int)
”CREATE procedure [dbo].[Job_Update](@id int. @quality int, @originalTimestamptimestamp)
”CREATE procedure [dbo].[Job_Delete](@id int)
”CREATE procedure [dbo].[Employee_Insert](@name varchar(20).@salary float)
”CREATE procedure [dbo].[Employee_Update](@id int, @ id int, @name varchar(20),@salary
float)
”CREATE procedure [dbo].[Employee_Delete](@id int)
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
There is an MS ADO.NET EDM (Entity Data Model) for the Employee and Order tables.

There is 1 to many relation between the ID column in the Employee Table and the
EmployeeID column in the Job table. The Employee and Jobs entities might need to be
mapped to the stored procedures, being displayed in the signature exhibit.
To which, if any, procedures should this mapping be applied? Select all that applies.


Page 4 of 6« First...23456