Microsoft 070-516 : TS: Accessing Data with Microsoft .NET Framework 4

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database.
You need to ensure that the application connects to the database server by using SQL Server
authentication.
Which connection string should you use?

• A. SERVER=MyServer; DATABASE=AdventureWorks; Integrated Security=false;
• B. SERVER=MyServer; DATABASE=AdventureWorks; Integrated Security=SSPI; UID=sa; PWD=secret;
• C. SERVER=MyServer; DATABASE=AdventureWorks; UID=sa; PWD=secret;
• D. SERVER=MyServer; DATABASE=AdventureWorks; Trusted Connection=true;

Explanation: Only visible for DumpsTests members. You can sign-up / login (it's free).

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You use Plain Old CLR objects (POCO) to model your entities.
The application communicates with a Windows Communication Foundation (WCF) Data Services service.
You need to ensure that entities can be sent to the service as XML. What should you do?

• A. Apply the [DataContract(IsReference = false)] attribute to the entities.
• B. Apply the [DataContract(IsReference = true)] attribute to the entities.
• C. Apply the [Serializable] attribute to the entities.
• D. Apply the virtual keyword to the entity properties.

Explanation: Only visible for DumpsTests members. You can sign-up / login (it's free).

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. The application uses DataContexts to query
the database.
The application meets the following requirements:
-Stores customer data offline.
-Allows users to update customer records while they are disconnected from the server.
-Enables offline changes to be submitted back to the SQL Server by using the DataContext object.
You need to ensure that the application can detect all conflicts that occur between the offline customer information submitted to the SQL Server and the server version. You also need to ensure that you can roll back local changes. What should you do?

• A. Add a try/catch statement around calls to the SubmitChanges method of the DataContext object and catch ChangeConflictExceptions.
• B. Add a try/catch statement around calls to the SubmitChanges method of the DataContext object and catch SqlExceptions.
• C. Call the SubmitChanges method of the DataContext object. Pass System.Data.Linq.ConflictMode.ContinueOnConflict to the method.
• D. Override the Update operation of the DataContext object. Call the ExecuteDynamicUpdate method to generate the update SQL.

Explanation: Only visible for DumpsTests members. You can sign-up / login (it's free).

You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to enhance and existing application use
Entity Framework.
The classes that represent the entites in the model are Plain old CLR Object (POCO) Classes.
You need to connect the existing POCO classes to an entity framework context. What should you do?

• A. 1. Generate a MetadataWorkspace and create an ObjectContext for the model.
  2.Create an ObjectSet fort he POCO classes.
  3.Disable Proxy object creation on the ContextOptions of the ObjectContext.
• B. 1. Generate an Entity Data Model for the POCO classes.
  2.Create an ObjectSet for the POCO classes.
  3.Set Code Generation Strategy on the Entity Data Model to none.
  4.Create an ObjectContext for the model.
• C. 1. Generate a MetadataWorkspace and create an ObjectContext for the model.
  2.Disable Proxy object creation on the ContextOptions of the ObjectContext.
  3.Enable lazy loading on the ContextOptions of the ObjectContext.
• D. 1. Generate an Entity Data Model fort he POCO classes.
  2.Create an ObjectSet fort he POCO classes.
  3.Disable Proxy object creation on the ContextOptions of the ObjectContext.
  4.Enable lazy loading on the ContextOptions of the ObjectContext.

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. The application uses the ADO.NET Entity
Framework to model entities.
The database includes objects based on the exhibit.
The application includes the following code segment. (Line numbers are included for reference only.)
01 using (AdventureWorksEntities context = new AdventureWorksEntities()){
02 ...
03 foreach (SalesOrderHeader order in customer.SalesOrderHeader){
04 Console.WriteLine(String.Format("Order: {0} ",
order.SalesOrderNumber));
05 foreach (SalesOrderDetail item in order.SalesOrderDetail){
06 Console.WriteLine(String.Format("Quantity: {0} ", item.Quantity));
07 Console.WriteLine(String.Format("Product: {0} ",
item.Product.Name));
08 }
09 }
10 }
You want to list all the orders for a specified customer. You need to ensure that the list contains the following fields:
-Order number
-Quantity of products
-Product name
Which code segment should you insert at line 02?

• A. Contact customer = context.Contact.Where("it.ContactID = @customerId", new ObjectParameter ("@customerId", customerId)).First();
• B. context.ContextOptions.LazyLoadingEnabled = true;
  Contact customer = (from contact in context.Contact
  include("SalesOrderHeader.SalesOrderDetail")
  select conatct).FirstOrDefault();
• C. Contact customer = (from contact in context.Contact
  include("SalesOrderHeader") select conatct).FirstOrDefault();
• D. Contact customer = context.Contact.Where("it.ContactID = @customerId", new ObjectParameter ("customerId", customerId)).First();