You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application uses the ADO.NET Entity Framework to model entities. You deploy an application to a
production server.
The application uses the model and mapping files that are deployed as application resources.
You need to update the conceptual model for the application on the production server. What should you do?

• A. Copy the updated .edmx file to the production server.
• B. Copy the updated .ssdl file to the production server.
• C. Copy the updated .csdl file to the production server.
• D. Recompile the application and redeploy the modified assembly file.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server 2008 database. The database includes a table that
contains information about all the employees.
The database table has a field named EmployeeType that identifies whether an employee is a Contractor or
a Permanent employee.
You declare the Employee entity base type. You create a new Association entity named Contractor that
inherits the Employee base type.
You need to ensure that all Contractors are bound to the Contractor class. What should you do?

• A. Modify the .edmx file to include the following line of code: <NavigationProperty Name="Type" FromRole="EmployeeType" ToRole="Contractor" />
• B. Use the Entity Data Model Designer to set up an association between the Contractor class and EmployeeType.
• C. Use the Entity Data Model Designer to set up a referential constraint between the primary key of the Contractor class and EmployeeType.
• D. Modify the .edmx file to include the following line of code: <Condition ColumnName="EmployeeType" Value="Contractor" />

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows
Communication
Foundation (WCF) Data Services service. You deploy the data service to the following URL: http://
contoso.com/Northwind.svc.
You add the following code segment. (Line numbers are included for reference only.)
01 var uri = new Uri(@"http://contoso.com/Northwind.svc/");
02 var ctx = new NorthwindEntities(uri);
03 var categories = from c in ctx.Categories select c;
04 foreach (var category in categories) {
05 PrintCategory(category);
06 ...
07 foreach (var product in category.Products) {
08 ...
09 PrintProduct(product);
10 }
11 }
You need to ensure that the Product data for each Category object is lazy-loaded. What should you do?

• A. Add the following code segment at line 08:
  var strprdUri= string.format("Products?$filter=CategoryID eq {0}",
  category.CategoryID);
  var prodcutUri = new Uri(strPrd, UriKind.Relative);
  ctx.Execute<Product>(productUri);
• B. Add the following code segment at line 08:
  ctx.LoadProperty(product, "*");
• C. Add the following code segment at line 06:
  ctx.LoadProperty(category, "Products");
• D. Add the following code segment at line 06:
  var strPrdUri = string.Format("Categories({0})?$expand=Products",
  category.CategoryID);
  var productUri = new Uri(strPrdUri, UriKind.Relative);
  ctx.Execute<Product>(productUri);

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 over the network. The application uses data
from multiple related database tables.
You need to ensure that the application can be used if the connection is disconnected or unavailable.
Which object type should you use to store data from the database tables?

• A. DataReader
• B. Data Services
• C. DataSet
• D. DataAdapter