最新的Microsoft 70-516免費考試真題

問題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 database. You create the classes shown in the following exhibit:

You add the following code segment to the application. (Line numbers are included for reference only.)
01 public void QueryPlayers (List <League> leagues) {
02 ...
03 }
You create a LINQ query to retrieve a collection of Player objects.
You need to ensure that the collection includes all the players from each team and every league. Which
code segment should you insert at line 02?

A. var query = leagues.SelectMany(l => l.Teams.SelectMany(t => t.Players));

B. var query = leagues.Select(l => l.Teams.SelectMany(t => t.Players));

C. var query = leagues.Select(l => l.Teams.Select(t => t.Players));

D. var query = leagues.SelectMany(l => l.Teams.Select(t => t.Players));

正確答案: A

問題2

How do you define a WCF Data Service query to grab the first 10 records. Options are something like:

A. DataServiceQuery<Order> selectedOrders = context.Orders.AddQueryOption("$expand", "10");

B. DataServiceQuery<Order> selectedOrders = context.Orders.AddQueryOption("$top", "10");

C. DataServiceQuery<Order> selectedOrders = context.Orders.AddQueryOption("$filter", "10");

D. DataServiceQuery<Order> selectedOrders = context.Orders.AddQueryOption("$select", "10");

正確答案: B

說明：（僅 Fast2test 成員可見）

問題3

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database.
You need to ensure that the application connects to the database server by using SQL Server
authentication.
Which connection string should you use?

A. SERVER=MyServer; DATABASE=AdventureWorks; Integrated Security=SSPI; UID=sa; PWD=secret;

B. SERVER=MyServer; DATABASE=AdventureWorks; Integrated Security=false;

C. SERVER=MyServer; DATABASE=AdventureWorks; UID=sa; PWD=secret;

D. SERVER=MyServer; DATABASE=AdventureWorks; Trusted Connection=true;

正確答案: C

說明：（僅 Fast2test 成員可見）

問題4

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 GetProducts AS BEGIN
SELECT ProductID, Name, Price, Cost FROM Product END
You create a SqlDataAdapter named adapter to execute the stored procedure. You need to fill a DataTable
instance with the first 10 rows of the result set.
What are two possible code segments that you can use to achieve the goal?

A. DataSet ds = new DataSet(); adapter.Fill(ds, 0, 10, "Product");

B. DataSet ds = new DataSet(); DataTable dt = ds.Tables.Add("Product"); dt.ExtendedProperties["RowCount"] = 10; dt.ExtendedProperties["RowIndex"] = 0; adapter.Fill(dt);

C. DataSet ds = new DataSet(); DataTable dt = ds.Tables.Add("Product"); adapter.Fill(0, 10, dt);

D. DataSet ds = new DataSet(); ds.ExtendedProperties["RowCount"] = 10; ds.ExtendedProperties["RowIndex"] = 0; adapter.Fill(ds);

正確答案: A,C

說明：（僅 Fast2test 成員可見）

問題5

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. You use the ADO.NET Entity Framework to model entities. You write the following code segment. (Line numbers are included for reference only.)
01 public partial class SalesOrderDetail : EntityObject
02 {
03 partial void OnOrderQtyChanging(short value)
04 {
05 ...
06 {
07 ...
08 }
09 }
10 }
You need to find out whether the object has a valid ObjectStateEntry instance. Which code segment should you insert at line 05?

A. if (this.EntityState != EntityState.Detached)

B. if (this.EntityState != EntityState.Added)

C. if (this.EntityState != EntityState.Modified)

D. if (this.EntityState != EntityState.Unchanged)

正確答案: B

說明：（僅 Fast2test 成員可見）

問題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 stored procedure mapping for the Product entity type.

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

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

正確答案: B

說明：（僅 Fast2test 成員可見）

問題7

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database.
The application uses nested transaction scopes. An inner transaction scope contains code that inserts
records into the database.
You need to ensure that the inner transaction can successfully commit even if the outer transaction rolls
back.
What are two possible TransactionScope constructors that you can use for the inner transaction to achieve
this goal?
(Each correct answer presents a complete solution. Choose two.)

A. TransactionScope()

B. TransactionScope(TransactionScopeOption.Suppress)

C. TransactionScope(TransactionScopeOption.RequiresNew)

D. TransactionScope(TransactionScopeOption.Required)

正確答案: B,C

說明：（僅 Fast2test 成員可見）

問題8

You use Microsoft .NET Framework 4.0 to develop an application that uses LINQ to SQL. The LINQ to SQL
model contains the Product entity.
A stored procedure named GetActiveProducts performs a query that returns the set of active products from
the database.
You need to invoke the stored procedure to return the active products, and you must ensure that the LINQ
to SQL context can track changes to these entities. What should you do?

A. Navigate to the GetActiveProducts stored procedure in Server Explorer, and drag the procedure onto the Product entity in the LINQ to SQL model designer surface.

B. Add a property named GetActiveProducts to the Product entity.

C. Select the Product entity, view the entity's property window, and change the Name for the entity to GetActiveProducts.

D. Select the Product entity, view the entity's property window, and change the Source for the entity to GetActiveProducts.

正確答案: A

說明：（僅 Fast2test 成員可見）

問題9

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database.
You need to ensure that the application connects to the database server by using SQL Server
authentication.
Which connection string should you use?

A. SERVER=MyServer; DATABASE=AdventureWorks; Integrated Security=SSPI; UID=sa; PWD=secret;

B. SERVER=MyServer; DATABASE=AdventureWorks; Integrated Security=false;

C. SERVER=MyServer; DATABASE=AdventureWorks; UID=sa; PWD=secret;

D. SERVER=MyServer; DATABASE=AdventureWorks; Trusted Connection=true;

正確答案: C

說明：（僅 Fast2test 成員可見）

問題10

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 => e2.Equals(new XElement("author", "Author1"))));

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

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

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

正確答案: B

問題11

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. Add the following line of code to the InitializeService method of the service: config.SetEntitySetAccessRule ("*", EntitySetRights.WriteDelete | EntitySetRights.WriteMerge);

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

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

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

正確答案: D

說明：（僅 Fast2test 成員可見）

問題12

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. Add a handler for the ObjectContext.SavingChanges event. In the event handler, set the CustomerKey value.

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

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

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

正確答案: A

說明：（僅 Fast2test 成員可見）

問題13

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses the Entity Framework.
You create an Entity Data Model (EDM) named Model. You need to ensure that the Storage Schema
Definition Language (SSDL)
of the EDM can be modified without rebuilding the application. What should you do?

A. Set the Metadata Artifact Processing property to Embed in Output Assembly and use the following connection string: metadata=.\Model.csdl| .\Model.ssdl| .\Model.msl; provider=System.Data.SqlClient; provider connection string="& "

B. Set the Metadata Artifact Processing property to Copy to Output Directory and use the following connection string: metadata=.\Model.csdl| .\Model.ssdl| .\Model.msl; provider=System.Data.SqlClient; provider connection string ="& "

C. Set the Metadata Artifact Processing property to Copy to Output Directory and use the following connection string: metadata=res://*/Model.csdl| res://*/Model.ssdl| res://*/Model.msl; provider=System.Data.SqlClient; provider connection string ="& "

D. Set the Metadata Artifact Processing property to Embed in Output Assembly and use the following connection string: metadata=res://*/Model.csdl| res://*/Model.ssdl| res://*/Model.msl; provider=System.Data.SqlClient; provider connection string="& "

正確答案: B

說明：（僅 Fast2test 成員可見）

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

聯系我們

站內鏈接

最新更新