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

The application populates a DataSet object by using a SqlDataAdapter object.
You use the DataSet object to update the Categories database table in the database. You write the
following code segment.
(Line numbers are included for reference only.)
01 SqlDataAdapter dataAdpater = new SqlDataAdapter("SELECT CategoryID,
CategoryName FROM Categories", connection);
02 SqlCommandBuilder builder = new SqlCommandBuilder(dataAdpater);
03 DataSet ds = new DataSet();
04 dataAdpater.Fill(ds);
05 foreach (DataRow categoryRow in ds.Tables[0].Rows)
06 {
07 if (string.Compare(categoryRow["CategoryName"].ToString(), searchValue,
true) == 0)
08 {
09 ...
10 }
11 }
12 dataAdpater.Update(ds);
You need to remove all the records from the Categories database table that match the value of the
searchValue variable.
Which line of code should you insert at line 09?

• A. categoryRow.Delete();
• B. ds.Tables[0].Rows.RemoveAt(0);
• C. ds.Tables[0].Rows[categoryRow.GetHashCode()].Delete();
• D. ds.Tables[0].Rows.Remove(categoryRow);

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. The model includes the entity
shown in the following exhibit:

You need to add a function that returns the number of years since a person was hired.
You also need to ensure that the function can be used within LINQ to Entities queries. What should you do?

• A. //Add the following conceptual model function returns the number of years since an instructor was hired
  <Function Name="YearsSince" ReturnType="Edm.Int32">
  <Parameter Name="date" Type="Edm.DateTime" />
  <DefiningExpression>
  Year(CurrentDateTime()) -Year(date)
  </DefiningExpression>
  </Function>
  // add the following method to your application and use an EdmFunctionAttribute to map it to the
  conceptual model function:
  [EdmFunction("SchoolModel", "YearsSince")] public static int YearsSince(DateTime date){ throw new NotSupportedException("Direct calls are not supported."); }
• B. //Add the following conceptual model function returns the number of years since an instructor was hired
  <Function Name="YearsSince" ReturnType="Edm.Int32">
  <Parameter Name="date" Type="Edm.DateTime" />
  <DefiningExpression>
  Year(CurrentDateTime()) -Year(date)
  </DefiningExpression>
  </Function>
  // add the following method to your application and use an EdmFunctionAttribute to map it to the
  conceptual model function:
  [EdmFunction("SchoolModel", "YearsSince")]
  public static int YearsSince(DateTime date){
  return CurrentDateTime() -Year(date);
  }
• C. //Add the following conceptual model function returns the number of years since an instructor was hired
  <Function Name="YearsSince" ReturnType="Edm.Int32">
  <Parameter Name="date" Type="Edm.DateTime" />
  <DefiningExpression>
  YearsSince(DateTime date)
  </DefiningExpression>
  </Function>
  // add the following method to your application and use an EdmFunctionAttribute to map it to the
  conceptual model function:
  [EdmFunction("SchoolModel", "YearsSince")]
  public static int YearsSince(DateTime date){
  return CurrentDateTime() -Year(date);
  }
• D. Use the Entity Data Model Designer to create a complex property named YearsSinceNow that can be accessed throuqh the LINQ to Entites query at a Later time

You are a tasked with performing a code review. The business rule is the following:
-If INSERTs into the first table succeed, then INSERT into the second table.
-However, if the INSERTs into the second table fail, roll back the inserts in the second table but do not roll back the inserts in the first table.
-Although this can also be done by way of regular transactions, It needs to be performed using
TransactionScope objects.
Whis code would fit this business rule?

• A. try
  {
  using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption)
  {
  ....
  try
  {
  .....
  using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption))
  { .... }
  }
  }
  }
• B. try
  { using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
  ...
  }
  using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption.RequiresNew)) { .... } }
• C. try
  { using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
  ....
  try
  {
  .....
  using (TransactionScope scope2 = new TransactionScope
  (TransactionScopeOption.RequiresNew))
  { .... }
  }
  }
  }
• D. try
  { using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
  ...
  using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption.RequiresNew))
  { .... }
  ......
  }
  }

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 SKIP @skip VALUE product FROM AdventureWorksEntities.Products AS product ORDER BY product.ListPrice LIMIT @limit
• B. SELECT SKIP @skip TOP Stop VALUE product FROM AdventureWorksEntities.Products AS product ORDER BY product.ListPrice
• C. SELECT TOP Stop VALUE product FROM AdventureWorksEntities.Products AS product ORDER BY product.ListPrice SKIP @skip
• D. SELECT VALUE product FROM AdventureWorksEntities.Products AS product ORDER BY product.ListPrice SKIP @skip LIMIT @limit

You use Microsoft .NET Framework 4.0 to develop an application that uses the Entity Framework.
The application defines the following Entity SQL (ESQL) query, which must be executed against the mode.
string prodQuery = "select value p from Products as p where
p.ProductCategory.Name = @p0";
You need to execute the query. Which code segment should you use?

• A. var prods = ctx.CreateQuery<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();
• B. var prods = ctx.ExecuteStoreQuery<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();
• C. var prods = ctx.ExecuteStoreCommand(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();
• D. var prods = ctx.ExecuteFunction<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();