Get real 70-516 exam questions for better preparation

Microsoft 70-516 Exam Overview:

Microsoft 70-516 Exam Syllabus Topics:

Microsoft TS: Accessing Data with Microsoft .NET Framework 4 Sample Questions:

1. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an ASP.NET Web application that uses the Entity Framework.
The build configuration is set to Release. The application must be published by using Microsoft Visual Studio 2010, with the following requirements:
-The database schema must be created on the destination database server.
-The Entity Framework connection string must be updated so that it refers to the destination database server.
You need to configure the application to meet the requirements. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

A) Generate the DDL from the Entity Framework Designer and include it in the project. Set the action for the DDL to ApplicationDefinition.
B) Use the web.config transform file to modify the connection string for the release configuration.
C) Include the source database entry in the Package/Publish SQL tab and update the connection string for the destination database.
D) Set Items to deploy in the Package/Publish Web tab to All files in this Project Folder for the release configuration.

2. You use Microsoft .NET Framework 4.0 to develop an application that exposes a WCF Data Services
endpoint.
The endpoint uses an authentication scheme that requires an HTTP request that has the following header
format.
GET /OData.svc/Products(1)
Authorization: WRAP access_token "123456789"
You add the following method to your DataService implementation.
01 protected override void OnStartProcessingRequest(ProcessRequestArgs args)
02 {
03 ....
04 }
You need to ensure that the method retrieves the authentication token. Which line of code should you use?

A) string token = args.OperationContext.RequestHeaders["WRAP access_token"];
B) string token = args.OperationContext.RequestHeaders["Authorization"];
C) string token = args.OperationContext.ResponseHeaders["WRAP access_token"];
D) string token = args.OperationContext.ResponseHeaders["Authorization"];

3. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application.
You use the ADO.NET Entity Framework Designer to model entities. The model contains an entity type
named Product.
You need to ensure that a stored procedure will be invoked when the ObjectContext.SaveChanges method
is executed after an attached Product has changed.
What should you do in the ADO.NET Entity Framework Designer?

A) Add a function import for the Product entity type.
B) Add a stored procedure mapping for the Product entity type.
C) Add a new entity that has a base class of Product that is mapped to the stored procedure.
D) Add a complex type named Product that is mapped to the stored procedure.

4. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server database. You use Entity SQL to retrieve data from the
database.
You need to find out whether a collection is empty. Which entity set operator should you use?

A) EXISTS
B) ANYELEMENT
C) EXCEPT
D) IN

5. How do you call a model-defined function as static method on a custom class?

A) Add a class to your application with a static method that does the following: Apply an EdmFunctionAttribute to the method and ensure it accepts ICollection argument and returns the results of the Execute method that is returned by the Provider property.
B) Add a class to your application with a static method that does the following: Apply an EdmFunctionAttribute to the method and ensure it accepts IEntityWithRelationships argument and returns the results of the Execute method that is returned by the Provider property.
C) Add a class to your application with a static method that does the following: Apply an EdmFunctionAttribute to the method and ensure it accepts and returns the results of the Execute method that is returned by the Provider property.
D) Add a class to your application with a static method that does the following: Apply an EdmFunctionAttribute to the method and ensure it accepts an IQueryable argument and returns the results of the Execute method that is returned by the Provider property.

Solutions: