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

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses the EntityFramework.
The application has an entity named Person. A Person instance named person1 and an ObjectContext
instance named model exist.
You need to delete the person1 instance. Which code segment should you use?

• A. model.DeleteObject(person1); model.SaveChanges();
• B. model.ExecuteStoreCommand("Delete", new []{new ObjectParameter("Person", person1)}; model.SaveChanges();
• C. model.Detach(person1); model.SaveChanges();
• D. model.ExecuteStoreCommand("Detach", new []{new ObjectParameter("Person", person1)}; model.SaveChanges();

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application that uses
the Entity Framework.
The application has the entity model shown in the following diagram.

The application must create a projection of the unique set of names and year-to-date sales for territories
where at least one sales person had sales last year of more than $100,000.
The projection must consist of properties named Sales and Name. You need to write a query that will
generate the required projection.
Which code segment should you use?

• A. (from person in model.SalesPersons where (person.SalesLastYear > 100000) select new {
  Name = person.SalesTerritory.Name,
  Sales = person.SalesTerritory.SalesYTD
  }
  ).Distinct();
• B. (from person in model.SalesPersons where (person.SalesLastYear > 100000) select new {
  Name = person.SalesTerritory.Name,
  Sales = person.SalesTerritory.SalesYTD
  }
  );
• C. model.SalesTerritories.Where( t => t.SalesPersons.Any( p => p.SalesLastYear > 100000)) .Select( t=> new { t.Name, t.SalesYTD})
  .Distinct();
• D. model.SalesTerritories.Where( t=> t.SalesPersons.Any( p => p.SalesLastYear > 100000)) .Select( t=> new { t.Name, Sales = t.SalesYTD});

You use Microsoft Visual Studio 2010, Microsoft Sync Framework, and Microsoft .NET Framework 4.0 to
create an application.
You have a ServerSyncProvider connected to a Microsoft SQL Server database. The database is hosted on
a Web server.
Users will use the Internet to access the Customer database through the ServerSyncProvider.
You write the following code segment. (Line numbers are included for reference only.)
01 SyncTable customerSyncTable = new SyncTable("Customer");
02 customerSyncTable.CreationOption =
TableCreationOption.UploadExistingOrCreateNewTable;
03 ...
04 customerSyncTable.SyncGroup = customerSyncGroup;
05 this.Configuration.SyncTables.Add(customerSyncTable);
You need to ensure that the application meets the following requirements:
-Users can modify data locally and receive changes from the server.
-Only changed rows are transferred during synchronization. Which code segment should you insert at line 03?

• A. customerSyncTable.SyncDirection = SyncDirection.Bidirectional;
• B. customerSyncTable.SyncDirection = SyncDirection.UploadOnly;
• C. customerSyncTable.SyncDirection = SyncDirection.DownloadOnly;
• D. customerSyncTable.SyncDirection = SyncDirection.Snapshot;

You are developing a WCF data service that will expose an existing Entity Data Model (EDM). You have the following requirements:
-Users must be able to read all entities that are exposed in the EDM.
-Users must be able to update or replace the SalesOrderHeader entities.
-Users must be prevented from inserting or deleting the SalesOrderHeader entities
You need to ensure that the data service meets the requirements. Which code segment should you use in the Initialize method?

• A. config.SetEntitySetAccessRule("*", EntitySetRights.AllRead); config.SetEntitySetAccessRule("SalesOrderHeader", EntitySetRights.All);
• B. config.SetEntitySetAccessRule("*", EntitySetRights.AllRead); config.SetEntitySetAccessRule("SalesOrderHeader", EntitySetRights.WriteAppend |
  EntitySetRights.WriteDelete);
• C. config.SetEntitySetAccessRule("*", EntitySetRights.AllRead); config.SetEntitySetAccessRule("SalesOrderHeader", EntitySetRights.AllWrite);
• D. config.SetEntitySetAccessRule("*", EntitySetRights.AllRead); config.SetEntitySetAccessRule("SalesOrderHeader", EntitySetRights.WriteMerge | EntitySetRights.WriteReplace);

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.
You need to create a Plain Old CLR Object (POCO) class that can be used with the
ObjectContext.CreateObject method to create a proxy.
What should you do?

• A. Create a custom data class that is sealed.
• B. Create a custom data class in which all properties and methods are virtual.
• C. Create a custom data class that is abstract.
• D. Create a custom data class that has a Protected constructor that does not have parameters.