Online Access Free 70-516 Exam Questions

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();

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows Communication Foundation (WCF) Data Services service. The solution contains the projects shown in the following table.

The WCF data service exposes an Entity Framework model. You need to Access the service by using a
WCF Data Services client.
What should you do in the Application.Client Project?

• A.Add a referance to the Application.Model Project.
• B.Add a web reference that uses the URL of the WCF data service.
• C.Add a service reference that uses the URL of the WCF data service.
• D.Add a referance to the Application.Service Project.

You use Microsoft .NET Framework 4.0 to develop an application. You use the XmlReader class to load
XML from a location that you do not control.
You need to ensure that loading the XML will not load external resources that are referenced in the XML.
Which code segment should you use?

• A.XmlReaderSettings settings = new XmlReaderSettings(); settings.ConformanceLevel = ConformanceLevel.Auto; XmlReader reader = XmlReader.Create("data.xml", settings);
• B.XmlReaderSettings settings = new XmlReaderSettings(); settings.XmlResolver = null; XmlReader reader = XmlReader.Create("data.xml", settings);
• C.XmlReaderSettings settings = new XmlReaderSettings(); settings.CheckCharacters = true; XmlReader reader = XmlReader.Create("data.xml", settings);
• D.XmlReaderSettings settings = new XmlReaderSettings(); settings.ValidationType = ValidationType.None; XmlReader reader = XmlReader.Create("data.xml", settings);

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. The application contains two
SqlCommand objects named cmd1 and cmd2.
You need to measure the time required to execute each command. Which code segment should you use?

• A.Stopwatch w1 = new Stopwatch(); w1.Start(); cmd1.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds); w1.Reset(); cmd2.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds);
• B.Stopwatch w1 = new Stopwatch(); w1.Start(); cmd1.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds); w1.Start(); cmd2.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds);
• C.Stopwatch w1 = Stopwatch.StartNew(); cmd1.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds); w1 = Stopwatch.StartNew(); cmd2.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds);
• D.Stopwatch w1 = Stopwatch.StartNew(); cmd1.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds); w1.Start(); cmd2.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds);

You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to enhance and existing application use
Entity Framework.
The classes that represent the entites in the model are Plain old CLR Object (POCO) Classes.
You need to connect the existing POCO classes to an entity framework context. What should you do?

• A.1. Generate a MetadataWorkspace and create an ObjectContext for the model.
  2.Create an ObjectSet fort he POCO classes.
  3.Disable Proxy object creation on the ContextOptions of the ObjectContext.
• B.1. Generate a MetadataWorkspace and create an ObjectContext for the model.
  2.Disable Proxy object creation on the ContextOptions of the ObjectContext.
  3.Enable lazy loading on the ContextOptions of the ObjectContext.
• C.1. Generate an Entity Data Model for the POCO classes.
  2.Create an ObjectSet for the POCO classes.
  3.Set Code Generation Strategy on the Entity Data Model to none.
  4.Create an ObjectContext for the model.
• D.1. Generate an Entity Data Model fort he POCO classes.
  2.Create an ObjectSet fort he POCO classes.
  3.Disable Proxy object creation on the ContextOptions of the ObjectContext.
  4.Enable lazy loading on the ContextOptions of the ObjectContext.