Microsoft UPG:Transition MCPD.NET Frmwrk 3.5 Web Dev to 4 Web Dev 認定 070-523 試験問題:

1. You are moving a Windows Communication Foundation (WCF) service into production.
You need to be able to monitor the health of the service. You only want to enable all performance counter
instances exposed by the ServiceModelService 4.0.0.0 counter group.
Which element should you add to the system.serviceModel section in the application configuration file?

A) <diagnostics wmiProviderEnabled="true" />
B) <diagnostics wmiProviderEnabled="true" performanceCounters="Off" />
C) <diagnostics performanceCounters="All" />
D) <diagnostics performanceCounters="ServiceOnly" />

2. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application connects to a Microsoft SQL Server database. The application uses the following object query
to load a product from the database. (Line numbers are included for reference only.)
01using (AdventureWorksEntities advWorksContext = new AdventureWorksEntities())
02{
03ObjectQuery <Product> productQuery = advWorksContext.Product.Where("it.ProductID = 900");
04
05}
You need to log the command that the query executes against the data source. Which code segment
should you insert at line 04?

A) Trace.WriteLine(productQuery.CommandText);
B) Trace.WriteLine(productQuery.ToTraceString());
C) Trace.WriteLine(productQuery.ToString());
D) Trace.WriteLine(((IQueryable)productQuery).Expression);

3. You create a page in an ASP.NET Web application. The page retrieves and displays data from a Microsoft SQL Server database. You need to create a data source that can connect to the database. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

A) Use a SqlDataSource control and configure its ConnectionString in the web.config file.
B) Use an XmlDataSource control together with an Xml control that represents the database.
C) Use a LinqDataSource control with entity classes that represent the elements in the database.
D) Use an ObjectDataSource control and set its TypeName property to System.Data.SqlClient. SqlConnection.

4. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application connects to a Microsoft SQL Server 2008 database. You create classes by using LINQ to SQL based on the records shown in the exhibit. (Click the Exhibit button.) You need to create a LINQ query to retrieve a list of objects that contains the OrderID and CustomerID properties. You need to retrieve the total price amount of each Order record. What are two possible ways to achieve this goal (Each correct answer presents a complete solution. Choose two.)

A) from order in dataContext.Orders group order by order.OrderID into g join details in dataContext.Order_Details on g.Key equals details. OrderID select new { OrderID = details.OrderID, CustomerID = details.Order.CustomerID, TotalAmount = details.UnitPrice * details.Quantity }
B) dataContext.Order_Details.GroupJoin(dataContext.Orders, d => d.OrderID, o => o.OrderID, (dts, ord) => new { OrderID = dts.OrderID, CustomerID = dts.Order.CustomerID, TotalAmount = dts.UnitPrice * dts.Quantity } )
C) from details in dataContext.Order_Details group details by details.OrderID into g join order in dataContext.Orders on g.Key equals order.OrderID select new { OrderID = order.OrderID, CustomerID = order.CustomerID, TotalAmount = g.Sum(od => od.UnitPrice * od.Quantity) }
D) dataContext.Orders.GroupJoin(dataContext.Order_Details, o => o.OrderID, d => d.OrderID, (ord, dts) => new { OrderID = ord.OrderID, CustomerID = ord.CustomerID, TotalAmount = dts.Sum(od => od. UnitPrice * od.Quantity) } )

5. You create an ASP.NET page named TestPage.aspx that contains validation controls. You need to verify that all input values submitted by the user have been validated by testing the Page.IsValid property. Which page event should add an event handler to?

A) Load
B) Init
C) PreInit
D) PreLoad

質問と回答：