Online Access Free 070-516 Exam Questions

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows
Communication Foundation (WCF) Data Services service.
You discover that when an application submits a PUT or DELETE request to the Data Services service, it
receives an error.
You need to ensure that the application can access the service. Which header and request type should you
use in the application?

• A.an X-HTTP-Method header as part of a POST request
• B.an X-HTTP-Method header as part of a GET request
• C.an HTTP ContentType header as part of a GET request
• D.an HTTP ContentType header as part of a POST request

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 the ADO.NET LINQ to Entity model
to retrieve data from the database.
You need to call a function that is defined in the conceptual model from within the LINQ to Entities queries.
You create a common language runtime (CLR) method that maps to the function. What should you do
next?

• A.Declare the method as static.
• B.Apply the EdmFunctionAttribute attribute to the method.
• C.Declare the method as abstract.
• D.Apply the EdmComplexTypeAttribute attribute to the method.

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database.
You add the following stored procedure to the database.
CREATE PROCEDURE dbo.GetClassAndStudents AS BEGIN
SELECT * FROM dbo.Class
SELECT * FROM dbo.Student
END
You create a SqIConnection named conn that connects to the database.
You need to fill a DataSet from the result that is returned by the stored procedure.
The first result set must be added to a DataTable named Class, and the second result set must be added to
a DataTable named Student.
Which code segment should you use?

• A.DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ad.TableMappings.Add("Table", "Class"); ad.TableMappings.Add("Table1", "Student") ; ad.Fill(ds) ;
• B.DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ds.Tables.Add("Class"); ds.Tables.Add("Student"); ad.Fill(ds);
• C.DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ad.MissingMappingAction = MissingMappingAction.Ignore; ad.Fill(ds, "Class"); ad.Fill(ds, "Student");
• D.DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ad.Fill(ds);

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses the Entity Framework.
You create an Entity Data Model (EDM) named Model. You need to ensure that the Storage Schema
Definition Language (SSDL)
of the EDM can be modified without rebuilding the application. What should you do?

• A.Set the Metadata Artifact Processing property to Copy to Output Directory and use the following connection string: metadata=.\Model.csdl| .\Model.ssdl| .\Model.msl; provider=System.Data.SqlClient; provider connection string ="& "
• B.Set the Metadata Artifact Processing property to Embed in Output Assembly and use the following connection string: metadata=res://*/Model.csdl| res://*/Model.ssdl| res://*/Model.msl; provider=System.Data.SqlClient; provider connection string="& "
• C.Set the Metadata Artifact Processing property to Embed in Output Assembly and use the following connection string: metadata=.\Model.csdl| .\Model.ssdl| .\Model.msl; provider=System.Data.SqlClient; provider connection string="& "
• D.Set the Metadata Artifact Processing property to Copy to Output Directory and use the following connection string: metadata=res://*/Model.csdl| res://*/Model.ssdl| res://*/Model.msl; provider=System.Data.SqlClient; provider connection string ="& "

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