Online Access Free 70-516 Practice Test

You need to ensure that an exception is thrown when color names are set to less than two characters. What should you do?

• A.Add the following code segment to the ContosoEntities partial class in Model\ContosoEntities.cs:
  public override in SaveChanges(System.Data.Objects.SaveOptions options)
  {
  var changes = this.ObjectStateManager.GetObjectSateEntries
  (System.Data.EntityState.Added);
  foreach (var change in changes)
  {
  if (change.Entity is Color) if (((Color)change.Entity.Name.Length < 2) throw new ArgumentException ("Name too short");
  }
  return base.SaveChanges(options);
  }
• B.Add the following attribute to the Name property of the Color class in the entity designer file:
  [StringLength(256, MinimumLength = 2)]
• C.Add the following method to the Color partial class in Model\Color.cs:
  protected overrride void OnPropertyChanged(string property)
  {
  if (property == "Name" && this.Name.Length < 2)
  throw new ArgumentOutOfRangeException("Name must be at least two
  characters");
  }
• D.Add the following method to the Color partial class in Model\Color.cs:
  protected overrride void OnPropertyChanging(string property)
  {
  if (property == "Name" && this.Name.Length < 2)
  throw new ArgumentOutOfRangeException("Name must be at least two
  characters");
  }

You use Microsoft .NET Framework 4.0 to develop an application that uses Entity Framework. The application includes the following Entity SQL (ESQL) query.
SELECT VALUE product FROM AdventureWorksEntities.Products AS product ORDER BY product.ListPrice
You need to modify the query to support paging of the query results. Which query should you use?

• A.SELECT TOP Stop VALUE product FROM AdventureWorksEntities.Products AS product ORDER BY product.ListPrice SKIP @skip
• B.SELECT VALUE product FROM AdventureWorksEntities.Products AS product ORDER BY product.ListPrice SKIP @skip LIMIT @limit
• C.SELECT SKIP @skip VALUE product FROM AdventureWorksEntities.Products AS product ORDER BY product.ListPrice LIMIT @limit
• D.SELECT SKIP @skip TOP Stop VALUE product FROM AdventureWorksEntities.Products AS product ORDER BY product.ListPrice

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.
You create classes by using LINQ to SQL based on the records shown in the exhibit:

You need to create a LINQ query to retrieve a list of objects that contains the OrderID and CustomerID
properties.
You need to retrieve the total price amount of each Order record. What are two possible ways to achieve
this goal?
(Each correct answer presents a complete solution. Choose two.)

• A.dataContext.Orders.GroupJoin(dataContext.Order_Detail, o => o.OrderID, d => d.OrderID,
  (ord, dts) => new {
  OrderID = ord.OrderID,
  CustomerID = ord.CustomerID,
  TotalAmount = dts.Sum(od => od.UnitPrice *
  od.Quantity)
  })
• B.from order in dataContext.Orders group order by order.OrderID into g join details in dataContext.Order_Detail on g.Key equals details.OrderID
  select new
  {
  OrderID = details.OrderID,
  CustomerID = details.Order.CustomerID,
  TotalAmount = details.UnitPrice * details.Quantity
  }
• C.dataContext.Order_Detail.GroupJoin(dataContext.Orders, d => d.OrderID, o => o.OrderID,
  (dts, ord) => new {
  OrderID = dts.OrderID,
  CustomerID = dts.Order.CustomerID,
  TotalAmount = dts.UnitPrice * dts.Quantity
  })
• D.from details in dataContext.Order_Detail group details by details.OrderID into g join order in dataContext.Orders on g.Key equals order.OrderID select new {
  OrderID = order.OrderID,
  CustomerID = order.CustomerID,
  TotalAmount = g.Sum(od => od.UnitPrice * od.Quantity)
  }

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application. You use the Entity Framework Designer to create an Entity Data Model using model-first development.
The database has the following requirements:
-each table must have a datetime column named time_modified
-each table requires a trigger that updates the value of the time_modified column when a row is inserted or updated
You need to ensure that the database script that is created by using the Generate Database From Model
option meets the requirements.
What should you do?

• A.Create a new Windows Workflow Foundation workflow, and set Database Generation Workflow to the name of the new workflow.
• B.Add a new entity named time_modified to the model, and modify each existing entity so that it inherits from the new entity.
• C.Create a new T4 template, and set the DDL Generation template to the name of the new template.
• D.Add a DateTime property named time_modified to each entity in the model and set the property's StoreGeneratedPattern to Computed.

You use Microsoft .NET Framework 4.0 and the Entity Framework to develop an application.
You create an Entity Data Model that has an entity named Customer. You set the optimistic concurrency
option for Customer.
You load and modify an instance of Customer named loadedCustomer, which is attached to an
ObjectContext named context.
You need to ensure that if a concurrency conflict occurs during a save, the application will load up-to-date
values from
the database while preserving local changes. Which code segment should you use?

• A.try {
  context.SaveChanges();
  }
  catch(OptimisticConcurrencyException ex)
  {
  context.Refresh(RefreshMode.ClientWins, loadedCustomer);
  }
• B.try {
  context.SaveChanges();
  }
  catch(OptimisticConcurrencyException ex)
  {
  context.Refresh(RefreshMode.StoreWins, loadedCustomer);
  }
• C.try {
  context.SaveChanges();
  }
  catch(EntitySqlException ex)
  {
  context.Refresh(RefreshMode.ClientWins, loadedCustomer);
  }
• D.try {
  context.SaveChanges();
  }
  catch(EntitySqlException ex)
  {
  context.Refresh(RefreshMode.StoreWins, loadedCustomer);
  }