Pass with 70-516 Practice Materials 100% for sure

The entity data model must be configured to provide a way you cal the sp_FindObsolete stored procedure. The returned data must implement the Descendants property.
In Visual Studio 2010, you open the Add functions Import dialog box from the EDMX diagram and enter the information shown in the following graphic.

You need to complete the configuration in the dialog box. What should you do?

• A. In the Returns a Collection Of area, click Scalars and then, in the Scalars list, click Int32
• B. In the Returns a Collection Of area, click Entities and then, in the Entities list, click Component
• C. Click the Get Column Information button, click Create New Complex Type and then, in the Complex box, enter Parts.
• D. In the Returns a Collection Of area, click Scalars and then, in the Scalars list, click string

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.ValidationType = ValidationType.None; XmlReader reader = XmlReader.Create("data.xml", settings);
• B. XmlReaderSettings settings = new XmlReaderSettings(); settings.ConformanceLevel = ConformanceLevel.Auto; 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.XmlResolver = null; 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.
You need to use a spatial value type as a parameter for your database query. What should you do?

• A. Set the parameter's SqlDbType to Variant.
• B. Set the parameter's SqlDbType to Udt. Set the parameter's UdtTypeName to GEOMETRY.
• C. Set the parameter's SqlDbType to Binary.
• D. Set the parameter's SqlDbType to Structured. Set the parameter's TypeName to GEOMETRY.

You have been assigned the task of writing code that executes an Entity SQL query that returns entity type
objects that contain a property of a complex type.
(Line numbers are included for reference only.)
01 using (EntityCommand cmd = conn.CreateCommand())
02 {
03 cmd.CommandText = esqlQuery;
04 EntityParameter param = new EntityParameter();
05 param.ParameterName = "id";
06 param.Value = 3;
07 cmd.Parameters.Add(param);
08 using (EntityDataReader rdr = cmd.ExecuteReader
(CommandBehavior.SequentialAccess))
09 {
10 while (rdr.Read())
11 {
12 ...
13 Console.WriteLine("Email and Phone Info:");
14 for (int i = 0; i < nestedRecord.FieldCount; i++)
15 {
16 Console.WriteLine(" " + nestedRecord.GetName(i) + ": " +
nestedRecord.GetValue(i));
17 }
18 }
19 }
20 }
Which code segment should you insert at line 12?

• A. ComplexDataRecord nestedRecord = rdr["EmailPhoneComplexProperty"]
• B. DbDataRecord nestedRecord = rdr["EmailPhoneComplexProperty"] as DbDataRecord;
• C. DataSet nestedRecord = rdr["EmailPhoneComplexProperty"] as ComplexDataSet
• D. DbDataRecord nestedRecord = rdr["EmailPhoneComplexProperty"]

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application. A file named books.xml contains the following XML.
<bib>
<book title="Programming in Unix" year="1992">
<author>Author1</author>
<author>Author2</author>
<author> Author 3 </author>
</book> </bib>
The application must generate an XML result that contains an XML element named BookTitle for each
book. The text content of the element must contain the title of the book.
You need to create a query that generates the new XML result. What should you do?

• A. XDocument document = XDocument.Load("books.xml");
  var query = from node in document.Descendants()
  where node.Name.LocalName == "book"
  select new XElement("BookTitle", node.FirstAttribute.Value);
• B. XDocument document = XDocument.Load("books.xml");
  var query = from node in document.Descendants()
  where node.Name.LocalName == "book"
  select new XElement("BookTitle").Value = node.FirstAttribute.Value;
• C. XDocument document = XDocument.Load("books.xml");
  var query = from node in document.DescendantNodes()
  where node.ToString() == "book"
  select new XElement("BookTitle", node.ToString());
• D. XDocument document = XDocument.Load("books.xml");
  var query = from node in document.DescendantNodes()
  where node.ToString() == "book"
  select new XText("BookTitle" + node.ToString());