Online Access Free 070-516 Exam Questions

You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to develop an application.
You use entity Framework Designer to create an Entity Data Model from an existing database by using the
Generate From Database wizard.
The model contains an entity type named Product. The Product type requires an additional property that is
not mapped to database colomn.
You need to add the property to product. What should you do?

• A.Add the property in a partial class named Product in a new source file.
• B.Create a comlex type with the name of the property in the Entity Framework Designer.
• C.Add the property in the generated class file, and select Run Custom Tool from the solution menu.
• D.Create a function import with the name of property in the Entity Framework Designer.

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. You use Entity SQL of the ADO.NET Entity
Framework to retrieve data from the database.
You need to define a custom function in the conceptual model. You also need to ensure that the function
calculates a value based on properties of the object.
Which two XML element types should you use? (Each correct answer presents part of the solution. Choose
two.)

• A.DefiningExpression
• B.Dependent
• C.FunctionImport
• D.Association
• E.Function

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You use the ADO.NET Entity Framework to model your entities.
You use Plain Old CLR Objects (POCO) entities along with snapshot-based change tracking. The code
accesses the POCO entities directly.
You need to ensure that the state manager synchronizes when changes are made to the object graph.
Which ObjectContext method should you call?

• A.SaveChanges
• B.ApplyPropertyChanges
• C.DetectChanges
• D.Refresh

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); ds.Tables.Add("Class"); ds.Tables.Add("Student"); ad.Fill(ds);
• D.DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ad.MissingMappingAction = MissingMappingAction.Ignore; ad.Fill(ds, "Class"); ad.Fill(ds, "Student");

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 add the following store procedure
to the database.
CREATE PROCEDURE GetSalesPeople AS BEGIN
SELECT FirstName, LastName, Suffix, Email, Phone FROM SalesPeople END
You write the following code segment. (Line numbers are included for reference only.)
01 SqlConnection connection = new SqlConnection("...");
02 SqlCommand command = new SqlCommand("GetSalesPeople", connection);
03 command.CommandType = CommandType.StoredProcedure;
04 ...
You need to retreive all of the results from the stored procedure. Which code segment should you insert at line 04?

• A.var res = command.ExecuteXmlReader();
• B.var res = command.ExecuteNonQuery();
• C.var res = command.ExecuteScalar();
• D.var res = command.ExecuteReader();