Microsoft 070-516 Exam Questions : 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 add the following stored procedure to the database.
CREATE PROCEDURE dbo.GetClassAndStudents AS BEGIN
SELECT * FROM dbo.Class
SELECT * FROM dbo.Student
END
You create a SqIConnection named conn that connects to the database.
You need to fill a DataSet from the result that is returned by the stored procedure.
The first result set must be added to a DataTable named Class, and the second result set must be added to
a DataTable named Student.
Which code segment should you use?

• A. DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ad.TableMappings.Add("Table", "Class"); ad.TableMappings.Add("Table1", "Student") ; ad.Fill(ds) ;
• B. DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ad.Fill(ds);
• C. DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ad.MissingMappingAction = MissingMappingAction.Ignore; ad.Fill(ds, "Class"); ad.Fill(ds, "Student");
• D. DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ds.Tables.Add("Class"); ds.Tables.Add("Student"); ad.Fill(ds);

You are adding a process to the application. The process performs the following actions:
1.Opens a ContosoEntities context object named context1.
2.Loads a Part object into a variable named part1.
3.Calls the Dispose() method on context1.
4.Updates the data in part1.
5.Updates the database by using a new ContosoEntities context object named context2.
You need to update the database with the changed data from part1. What should you do?

• A. Add the following code segment before calling SaveChanges() on context2:
  context2.Attach(part1);
  context2.ApplyCurrentValues("Parts", part1);
• B. Add the following code segment before calling SaveChanges() on context2:
  context2.ApplyCurrentValues("Parts", part1);
• C. Add the following code segment before calling SaveChanges() on context2:
  context2.ApplyOriginalValues("Parts", part1);
• D. Add the following code segment before calling SaveChanges() on context2:
  context2.Attach(part1);
  context2.ObjectStateManager.ChangeObjectState(part1,
  System.Data.EntitySate.Modified);

You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to develop an application that uses the
Entity Framewok.
You need to execute custom logic when an entity is attached to the ObjectContext. What should you do?

• A. Create an event handler to handle the ObjectStateManagerChanged event.
• B. Create a partial method named OnAttached in the partial class for the entity.
• C. Create an event handler to handle the ObjectMaterialized event.
• D. Create a partial method named OnStateChanged in the partial class for the entity.

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. ds.Tables[0].Rows.Remove(categoryRow);
• B. categoryRow.Delete();
• C. ds.Tables[0].Rows[categoryRow.GetHashCode()].Delete();
• D. ds.Tables[0].Rows.RemoveAt(0);

The application must provide a component part list for any product. The component part list must give the
quantity of
each distinct part that is required to manufacture that product.
You need to create a LINQ expression that delivers a a result of type IEnumerable<Tuple<int,Part>> to
meet the requirements.
Which expression should you use?

• A. IEnumerable<Tuple<int, Part>> result = part.Descendants .GroupBy(p => p) .Select(g => Tuple.Create(g.Count(), g.Key));
• B. IEnumerable<Tuple<int, Part>> result = part.Children .GroupBy(p => p) .Select(g => Tuple.Create(g.Count(), g.Key));
• C. IEnumerable<Tuple<int, Part>> result = part.Descendants .Distinct() .GroupBy(p => p) .Select(g => Tuple.Create(g.Count(), g.Key));
• D. IEnumerable<Tuple<int, Part>> result = part.Children .Distinct() .GroupBy(p => p) .Select(g => Tuple.Create(g.Count(), g.Key));
• E. IEnumerable<Tuple<int, Part>> result = part.Descendants .ToDictionary(c => c) .Select(d => Tuple.Create(d.Value.Children.Count(), d.Key));