Get real 70-516 exam questions for better preparation

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 function import with the name of 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 comlex type with the name of the property in the Entity Framework Designer.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows
Communication
Foundation (WCF) Data Services service. You deploy the data service to the following URL: http://
contoso.com/Northwind.svc.
You add the following code segment. (Line numbers are included for reference only.)
01 var uri = new Uri(@"http://contoso.com/Northwind.svc/");
02 var ctx = new NorthwindEntities(uri);
03 var categories = from c in ctx.Categories select c;
04 foreach (var category in categories) {
05 PrintCategory(category);
06 ...
07 foreach (var product in category.Products) {
08 ...
09 PrintProduct(product);
10 }
11 }
You need to ensure that the Product data for each Category object is lazy-loaded. What should you do?

• A. Add the following code segment at line 08:
  ctx.LoadProperty(product, "*");
• B. Add the following code segment at line 06:
  ctx.LoadProperty(category, "Products");
• C. Add the following code segment at line 06:
  var strPrdUri = string.Format("Categories({0})?$expand=Products",
  category.CategoryID);
  var productUri = new Uri(strPrdUri, UriKind.Relative);
  ctx.Execute<Product>(productUri);
• D. Add the following code segment at line 08:
  var strprdUri= string.format("Products?$filter=CategoryID eq {0}",
  category.CategoryID);
  var prodcutUri = new Uri(strPrd, UriKind.Relative);
  ctx.Execute<Product>(productUri);

Explanation: Only visible for itPass4sure members. You can sign-up / login (it's free).

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application contains following XML document.
<feed> <title>Products</title> <entry>
<title>Entry title 1</title>
<author>Author 1</author>
<content>
<properties>
<description>some description</description>
<notes>some notes</notes>
<comments>some comments</comments>
</properties>
</content>
</entry>
...
</feed>
You plan to add localization features to the application. You add the following code segment. (Line numbers are included for reference only.)
01 public IEnumerable <XNode> GetTextNodesForLocalization(XDocument doc) 02 {
03 ...
04 return from n in nodes
05 where n.NodeType = XmlNodeType.Text
06 select n;
07 }
You need to ensure that the GetTextNodeForLocalization method returns all the XML text nodes of the XML
document.
Which code segment should you inser at line 03?

• A. IEnumerable <XNode> nodes = doc.DescendantNodes();
• B. IEnumerable <XNode> nodes = doc.Nodes();
• C. IEnumerable <XNode> nodes = doc.Descendants();
• D. IEnumerable <XNode> nodes = doc.NodesAfterSelf();

Explanation: Only visible for itPass4sure members. You can sign-up / login (it's free).

You use Microsoft .NET Framework 4.0 to develop an application.
You write the following code to update data in a Microsoft SQL Server 2008 database.
(Line numbers are included for reference only.)
01 private void ExecuteUpdate(SqlCommand cmd, string connString, string
updateStmt)
02 {
03 ...
04 }
You need to ensure that the update statement executes and that the application avoids connection leaks. Which code segment should you insert at line 03?

• A. SqlConnection conn = new SqlConnection(connString); conn.Open(); cmd.Connection = conn; cmd.CommandText = updateStmt; cmd.ExecuteNonQuery(); cmd.Connection.Close() ;
• B. using (SqlConnection conn = new SqlConnection(connString))
  {
  conn.Open() ;
  cmd.Connection = conn;
  cmd.CommandText = updateStmt;
  cmd.ExecuteNonQuery() ;
  }
• C. SqlConnection conn = new SqlConnection(connString); conn.Open(); cmd.Connection = conn; cmd.CommandText = updateStmt; cmd.ExecuteNonQuery();
• D. using (SqlConnection conn = new SqlConnection(connString))
  {
  cmd.Connection = conn;
  cmd.CommandText = updateStmt;
  cmd.ExecuteNonQuery();
  cmd.Connection.Close();
  }

Explanation: Only visible for itPass4sure members. You can sign-up / login (it's free).

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 database includes a table that
contains information about all the employees.
The database table has a field named EmployeeType that identifies whether an employee is a Contractor or
a Permanent employee.
You declare the Employee entity base type. You create a new Association entity named Contractor that
inherits the Employee base type.
You need to ensure that all Contractors are bound to the Contractor class. What should you do?

• A. Use the Entity Data Model Designer to set up an association between the Contractor class and EmployeeType.
• B. Modify the .edmx file to include the following line of code: <NavigationProperty Name="Type" FromRole="EmployeeType" ToRole="Contractor" />
• C. Use the Entity Data Model Designer to set up a referential constraint between the primary key of the Contractor class and EmployeeType.
• D. Modify the .edmx file to include the following line of code: <Condition ColumnName="EmployeeType" Value="Contractor" />

Explanation: Only visible for itPass4sure members. You can sign-up / login (it's free).