070-516：最新的Microsoft認證070-516考題，TS: Accessing Data with Microsoft .NET Framework 4認證

問題1
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 uses DataContexts to
query the database.
You create a function that meets the following requirements:
-Updates the Customer table on the database when a customer is marked as deleted.
-Updates the related entries in other tables (CustomerAddress, CustomerContacts) by marking them as deleted.
-Prevents consumer code from setting the Deleted column's value directly.
You need to ensure that the function verifies that customers have no outstanding orders before they are
marked as deleted.
You also need to ensure that existing applications can use the update function without requiring changes in
the code.
What should you do?

A. Override the Delete operation of the DataContext object.

B. Modify the SELECT SQL statement provided to the DataContext object to use an INNER JOIN between the Customer and Orders tables.

C. Override the Update operation of the DataContext object.

D. Add new entities to the DataContext object for the Customers and Orders tables.

正確答案: A

問題2
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 the following SQL statement to retrieve an instance of a DataSet object named ds:
SELECT CustomerID, CompanyName, ContactName, Address, City FROM dbo.Customers
You need to query the DataSet object to retrieve only the rows where the ContactName field is not NULL. Which code segment should you use?

A. from row in ds.Tables[0].AsEnumerable() where !Convert.IsDBNull(row.Field<string>("ContactName")) select row;

B. from row in ds.Tables[0].AsEnumerable() where (string)row["ContactName"] != null select row;

C. from row in ds.Tables[0].AsEnumerable() where row.Field<string>("ContactName") != null select row;

D. from row in ds.Tables[0].AsEnumerable() where !row.IsNull((string)row["ContactName"]) select row;

正確答案: C

說明：（僅 PDFExamDumps 成員可見）

問題3
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application uses the ADO.NET Entity Framework to model entities.
The conceptual schema definition language (CSDL) file contains the following XML fragment.
<EntityType Name="Contact"> ... <Property Name="EmailPhoneComplexProperty"
Type="AdventureWorksModel.EmailPhone" Nullable="false" />
</EntityType>
...
<ComplexType Name="EmailPhone">
<Property Type="String" Name="EmailAddress" MaxLength="50" FixedLength="false" Unicode="true" />
<Property Type="String" Name="Phone" MaxLength="25" FixedLength="false" Unicode="true" /> </ComplexType>
You write the following code segment. (Line numbers are included for reference only.)
01 using (EntityConnection conn = new EntityConnection("name=AdvWksEntities"))
02 {
03 conn.Open();
04 string esqlQuery = @"SELECT VALUE contacts FROM
05 AdvWksEntities.Contacts AS contacts
06 WHERE contacts.ContactID == 3";
07 using (EntityCommand cmd = conn.CreateCommand())
08 {
09 cmd.CommandText = esqlQuery;
10 using (EntityDataReader rdr = cmd.ExecuteReader())
11 {
12 while (rdr.Read())
13
{
14
...
15
}
16
}
17
}
18 conn.Close(); 19 }
You need to ensure that the code returns a reference to a ComplexType entity in the model named
EmailPhone.
Which code segment should you insert at line 14?

A. int FldIdx = 0; EntityKey key = record.GetValue(FldIdx) as EntityKey; foreach (EntityKeyMember keyMember in key.EntityKeyValues)
{
return keyMember.Key + " : " + keyMember.Value;
}

B. int fieldCount = rdr["EmailPhone"].DataRecordInfo.FieldMetadata.Count; for (int FldIdx = 0; FldIdx < fieldCount; FldIdx++) {
rdr.GetName(FldIdx);
if (rdr.IsDBNull(FldIdx) == false)
{
return rdr["EmailPhone"].GetValue(FldIdx).ToString();
}
}

C. DbDataRecord nestedRecord = rdr["EmailPhoneComplexProperty"] as DbDataRecord; return nestedRecord;

D. IExtendedDataRecord record = rdr["EmailPhone"]as IExtendedDataRecord; int FldIdx = 0; return record.GetValue(FldIdx);

正確答案: C

問題4
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 need to update the City property of the Customer record that has its ID value as 123.
You also need to preserve the current values of the remaining properties. Which HTTP request should you
use?

A. MERGE /Northwind.svc/Customers(123) Host: contoso.com
Content-Type: application/json { City: 'Seattle' }

B. PUT /Northwind.svc/Customers(123) Host: contoso.com Accept: application/json { City: 'Seattle' }

C. MERGE /Northwind.svc/Customers(123) Host: contoso.com Accept: application/json { City: 'Seattle' }

D. PUT /Northwind.svc/Customers(123) Host: contoso.com Content-Type: application/json { City: 'Seattle' }

正確答案: A

說明：（僅 PDFExamDumps 成員可見）

問題5
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.CheckCharacters = true; XmlReader reader = XmlReader.Create("data.xml", settings);

C. XmlReaderSettings settings = new XmlReaderSettings(); settings.ValidationType = ValidationType.None; XmlReader reader = XmlReader.Create("data.xml", settings);

D. XmlReaderSettings settings = new XmlReaderSettings(); settings.XmlResolver = null; XmlReader reader = XmlReader.Create("data.xml", settings);

正確答案: D

說明：（僅 PDFExamDumps 成員可見）

問題6
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows
Communication Foundation (WCF) Data Services service.
The service connects to a Microsoft SQL Server 2008 database. The service is hosted by an Internet
Information Services (IIS) 6.0 Web server.
The application works correctly in the development environment. However, when you connect to the service
on
the production server, attempting to update or delete an entity results in an error.
You need to ensure that you can update and delete entities on the production server. What should you do?

A. Configure IIS to allow the POST and DELETE verbs for the .svc Application Extension.

B. Add the following line of code to the InitializeService method of the service: config.SetEntitySetAccessRule ("*", EntitySetRights.WriteDelete | EntitySetRights.WriteInsert);

C. Configure IIS to allow the PUT and DELETE verbs for the .svc Application Extension.

D. Add the following line of code to the InitializeService method of the service: config.SetEntitySetAccessRule ("*", EntitySetRights.WriteDelete | EntitySetRights.WriteMerge);

正確答案: C

說明：（僅 PDFExamDumps 成員可見）

問題7
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application contains the following XML fragment:
<ApplicationMenu> <MenuItem name="File">
<MenuItem name="New">
<MenuItem name="Project" />
<MenuItem name="Web Site" />
</MenuItem>
<MenuItem name="Open">
<MenuItem name="Project" />
<MenuItem name="Web Site" />
</MenuItem>
<MenuItem name="Save" />
</MenuItem>
<MenuItem name="Edit">
<MenuItem name="Cut" />
<MenuItem name="Copy" />
<MenuItem name="Paste" />
</MenuItem>
<MenuItem name="Help">
<MenuItem name="Help" />
<MenuItem name="About" />
</MenuItem> </ApplicationMenu>
The application queries the XML fragment by using the XmlDocument class. You need to select all the descendant elements of the MenuItem element that has its name attribute as File. Which XPath expression should you use?

A. //*[@name='File'][name()='MenuItem']

B. /ApplicationMenu/MenuItem/descendant::MenuItem['File']

C. /ApplicationMenu/MenuItem[@name='File']/descendant::MenuItem

D. /ApplicationMenu/MenuItem['File']//MenuItem

正確答案: C

說明：（僅 PDFExamDumps 成員可見）

問題8
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application.
You use the ADO.NET Entity Framework Designer to model entities.
You need to associate a previously deserialized entity named person1 to an object context named model
and persist changes to the database.
Which code segment should you use?

A. model.People.Attach(person1); model.SaveChanges();

B. model.People.ApplyChanges(person1) ; model.SaveChanges();

C. person1.AcceptChanges(); model.SaveChanges();

D. model.AttachTo("People", person1); model.SaveChanges();

正確答案: D

說明：（僅 PDFExamDumps 成員可見）

問題9
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.DescendantNodes()
where node.ToString() == "book"
select new XText("BookTitle" + node.ToString());

B. XDocument document = XDocument.Load("books.xml");
var query = from node in document.DescendantNodes()
where node.ToString() == "book"
select new XElement("BookTitle", node.ToString());

C. 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);

D. 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

問題10
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses the Entity Framework.
Entity types in the model are generated by the Entity Data Model generator tool (EdmGen.exe).
You write the following code. (Line numbers are included for reference only.)
01 MemoryStream stream = new MemoryStream();
02 var query = context.Contacts.Include("SalesOrderHeaders.SalesOrderDetails");
03 var contact = query.Where("it.LastName = @lastname", new ObjectParameter
("lastname", lastName)).First();
04 ....
You need to serialize the contact and all of its related objects to the MemoryStream so that the contact can
be deserialized back into the model.
Which code segment should you insert at line 04?

A. var formatter = new SoapFormatter(); formatter.Serialize(stream, contact);

B. var formatter = new BinaryFormatter(); formatter.Serialize(stream, contact);

C. var formatter = new XmlSerializer(typeof(Contact), new Type[] { typeof(SalesOrderHeader), typeof(SalesOrderDetail)
});
formatter.Serialize(stream, contact);

D. var formatter = new XmlSerializer(typeof(Contact)); formatter.Serialize(stream, contact);

正確答案: C

說明：（僅 PDFExamDumps 成員可見）

最新的Microsoft TS: Accessing Data with Microsoft .NET Framework 4 - 070-516免費考試真題

專業認證

品質保證

輕松通過

免費試用