70-516：最新的Microsoft認證70-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 uses the ADO.NET Entity Framework to model entities.
The application includes a Customer entity along with a CustomerKey property of the Guid type as shown in
the following exhibit:

You discover that when the application adds a new instance of a Customer, calling the SaveChanges
method
results in the following error message: "Server generated keys are only supported for identity columns."
You need to ensure that the application can add new Customer entities. What should you do?

A. Call the ObjectContext.CreateEntityKey method before saving a Customer entity.

B. Add a handler for the ObjectContext.SavingChanges event. In the event handler, set the CustomerKey value.

C. Add a handler for the ObjectContext.ObjectMaterialized event. In the event handler, set the CustomerKey value.

D. Call the ObjectContext.Attach method before saving a Customer entity.

正確答案: B

說明：（僅 PDFExamDumps 成員可見）

問題2
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

問題3
The user interface requires that a paged view be displayed of all the products sorted in alphabetical order.
The user interface supplies a current starting index and a page size in variables named startIndex and
pageSize of type int.
You need to construct a LINQ expression that will return the appropriate Parts from the database from an
existing
ContosoEntities context object named context. You begin by writing the following expression:
context.Parts
Which query parts should you use in sequence to complete the expression?
(To answer, move the appropriate actions from the list of actions to the answer area and arrange them in
the correct order.)

A. .OrderBy(x => x.Name)

B. .Skip(pageSize)

C. .Skip(startIndex)

D. .Take(pageSize);

E. .Take(startIndex)

正確答案: A,C,D

問題4
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application that
connects to a database by using the Entity Framework.
You create an Entity Data Model (EDM) by using the Generate from database wizard for the following
tables.

You need to ensure that the EDM contains an entity type named Employee that contains all of the data from
both tables.
What should you do?

A. Create a one-to-one association named CanAccessBuildingsAssociation between the EmployeeAccess entity and the Employee entity.

B. Create an inheritance relationship between the Employee and EmployeeAccess entities, and use CanAccessBuildings as an inheritance condition.

C. Delete the EmployeeAccess entity, create a new property named CanAccessBuildings on the Employee entity, and add a mapping for the new property.

D. Modify the .edmx file to include the following line of code. <NavigationProperty Name="Type" FromRole="EmployeeAccess" ToRole="Employee" />

正確答案: C

問題5
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 to retrieve data from the
database.
You need to find out whether a collection is empty. Which entity set operator should you use?

A. IN

B. ANYELEMENT

C. EXCEPT

D. EXISTS

正確答案: D

說明：（僅 PDFExamDumps 成員可見）

問題6
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. The model contains an entity type
named Product.
You need to ensure that a stored procedure will be invoked when the ObjectContext.SaveChanges method
is executed after an attached Product has changed.
What should you do in the ADO.NET Entity Framework Designer?

A. Add a new entity that has a base class of Product that is mapped to the stored procedure.

B. Add a complex type named Product that is mapped to the stored procedure.

C. Add a stored procedure mapping for the Product entity type.

D. Add a function import for the Product entity type.

正確答案: C

說明：（僅 PDFExamDumps 成員可見）

問題7
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 retrieve an entity from an object context.
A different application updates the database. You need to update the entity instance to reflect updated
values in the database.
Which line of code should you use?

A. context.LoadProperty(entity, "Client", MergeOption.OverwriteChanges);

B. context.AcceptAllChanges();

C. context.LoadProperty(entity, "Server", MergeOption.OverwriteChanges);

D. context.Refresh(RefreshMode.StoreWins, entity);

正確答案: D

說明：（僅 PDFExamDumps 成員可見）

問題8
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.
The application uses the ADO.NET LINQ to SQL model to retrieve data from the database.
The application will not modify retrieved data. You need to ensure that all the requested data is retrieved.
You want to achieve this goal using the minimum amount of resources. What should you do?

A. Set DeferredLoadingEnabled to true on the DataContext class.

B. Set ObjectTrackingEnabled to false on the DataContext class.

C. Set ObjectTrackingEnabled to true on the DataContext class.

D. Set DeferredLoadingEnabled to false on the DataContext class.

正確答案: B

說明：（僅 PDFExamDumps 成員可見）

問題9
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 application allows users to make changes to entities while disconnected from the central data store.
You need to ensure that when the user connects to the central data store and retrieves new data, the application meets the following requirements:
-Changes made to the local data store in disconnected mode are preserved.
-Entities that have already been loaded into the local data store, but have not been modified by the user,
are updated with the latest data. What should you do?

A. Call the query's Execute method by using the MergeOptions.OverwriteChanges option.

B. Call the Refresh method of ObjectContext by using the RefreshMode.StoreWins option.

C. Call the Refresh method of ObjectContext by using the RefreshMode.ClientWins option.

D. Call the query's Execute method by using the MergeOptions.AppendOnly option.

正確答案: C

問題10
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You use Microsoft ADO.NET Entity Data Model (EDM) to model entities.
You create an entity named Person with a schema defined by the following XML fragment.
<EntityType Name="CPerson"> <Key> <PropertyRef Name="PersonId" /> </Key>
<Property Name="PersonId" Type="Int32" Nullable="false" />
<Property Name="CompanyName" Type="String" />
<Property Name="ContactName" Type="String" />
<Property Name="ContactTitle" Type="String" />
<Property Name="Address" Type="String" />
</EntityType>
You need to ensure that entities within the application are able to add properties related to the city, region,
and country of Person's address.
What should you do?

A. Create a view named Name that returns city, region, and country along with person IDs. Add a WHERE clause to filter the results to display only the City, Region and Country properties for a specific Person entity.

B. Create a new complex type named CAddress that contains the properties for city, region, and country. Change the Type of the Address property in CPerson to "Self.CAddress".

C. Create a SubEntity named Address. Map the SubEntity to a stored procedure that retrieves city, region, and country.

D. Create a new entity named Address. Add a person ID property to filter the results to display only the City, Region, and Country properties for a specific Person entity.

正確答案: B

問題11
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. The application uses the ADO.NET Entity
Framework to model entities.
The database includes objects based on the exhibit.
The application includes the following code segment. (Line numbers are included for reference only.)
01 using (AdventureWorksEntities context = new AdventureWorksEntities()){
02 ...
03 foreach (SalesOrderHeader order in customer.SalesOrderHeader){
04 Console.WriteLine(String.Format("Order: {0} ",
order.SalesOrderNumber));
05 foreach (SalesOrderDetail item in order.SalesOrderDetail){
06 Console.WriteLine(String.Format("Quantity: {0} ", item.Quantity));
07 Console.WriteLine(String.Format("Product: {0} ",
item.Product.Name));
08 }
09 }
10 }
You want to list all the orders for a specified customer. You need to ensure that the list contains the following fields:
-Order number
-Quantity of products
-Product name
Which code segment should you insert at line 02?

A. context.ContextOptions.LazyLoadingEnabled = true;
Contact customer = (from contact in context.Contact
include("SalesOrderHeader.SalesOrderDetail")
select conatct).FirstOrDefault();

B. Contact customer = context.Contact.Where("it.ContactID = @customerId", new ObjectParameter ("customerId", customerId)).First();

C. Contact customer = context.Contact.Where("it.ContactID = @customerId", new ObjectParameter ("@customerId", customerId)).First();

D. Contact customer = (from contact in context.Contact
include("SalesOrderHeader") select conatct).FirstOrDefault();

正確答案: B

問題12
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application contains the following XML document:
<bib> <book title="TCP/IP Illusrated" year="1994">
<author>Author1</author>
</book>
<book title="Programming in UNIX" year="1992">
<author>Author1</author>
<author>Author2</author>
<author>Author3</author>
</book>
<book title="Data on the web" year="2000">
<author>Author4</author>
<author>Author3</author>
</book> </bib>
You add the following code fragment. (Line numbers are included for reference only.)
01 public IEnumerable<XElement> GetBooks(string xml)
02 {
03 XDocument doc = XDocument.Parse(xml);
04 ...
05 }
You need to return a list of book XML element that are authored by Author1. Which code segment should you insert at line 04?

A. return doc.Elements("bib").Elements() .Where(e1 => e1.Elements().Any(e2 => (string)e2 == "Author1"));

B. return doc.Elements("bib").Elements()
.Where(e1 => e1.Elements().Any(e2 => e2.Equals(new XElement("author", "Author1"))));

C. return doc.Element("bib").Elements() .SelectMany(el => el.Elements() .Where(e2 => (string)e2 == "Author1"));

D. return doc.Element("bib").Elements() .SelectMany(el => el.Elements() .Where(e2 => e2.Equals(new XElement("author", "Author1"))));

正確答案: A

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

專業認證

品質保證

輕松通過

免費試用