070-523試験無料問題集（118題）「Microsoft UPG:Transition MCPD.NET Frmwrk 3.5 Web Dev to 4 Web Dev 認定」

出題：1

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. 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 } )

B. 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) }

C. 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 }

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) } )

正解：B,D 解答を投票する

出題：2

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. 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 updated function without requiring changes in the code. What should you do?

A. Override the Delete operation of the DataContext object.

B. Override the Update operation of the DataContext object.

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

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

正解：A 解答を投票する

出題：3

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 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 query's Execute method by using the MergeOptions.AppendOnly option.

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

D. Call the Refresh method of ObjectContext by using the RefreshMode.ClientWins method.

正解：D 解答を投票する

出題：4

You are developing an ASP.NET application by using Visual Studio 2010. You need to interactively debug the entire application. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

A. Add a DebuggerDisplay attribute to the code-behind file of the page that you want to debug.

B. Set the Debug attribute of the compilation node of the web.config file to true.

C. Select the ASP.NET debugger option in the project properties.

D. Define the DEBUG constant in the project settings.

正解：B,C 解答を投票する

出題：5

You are implementing an ASP.NET application that uses data-bound GridView controls in multiple pages. You add JavaScript code to periodically update specific types of data items in these GridView controls. You need to ensure that the JavaScript code can locate the HTML elements created for each row in these GridView controls, without needing to be changed if the controls are moved from one pa to another. What should you do?

A. Replace the GridView control with a ListView control.

B. Set the @ OutputCache directive's VaryByControl attribute to the ID of the GridView control.

C. Set the ClientIDMode attribute to Predictable in the web.config file.

D. Set the ClientIDRowSuffix attribute of each unique GridView control to a different value.

正解：C 解答を投票する

出題：6

You need to design a deployment solution for the rewritten Web application. Which approach should you recommend?

A. Use MSDeploy and FTP.

B. Use MSDeploy and One-Click Publishing.

C. Use DB Deployment and One-Click Publishing.

D. Use DB Deployment and FTP.

正解：B 解答を投票する

出題：7

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application updates several Microsoft SQL Server databases within a single transaction. You need to ensure that after a resource failure, you can manage unresolved transactions. What should you do?

A. Call the Reenlist method of the TransactionManager class.

B. Call the RecoveryComplete method of the TransactionManager class.

C. Call the EnlistVolatile method of the Transaction class.

D. Call the EnlistDurable method of the Transaction class.

正解：A 解答を投票する

出題：8

You use Microsoft Visual Studio 2010, Microsoft Sync Framework, and Microsoft .NET Framework 4 to
create an application. You have a ServerSyncProvider connected to a Microsoft SQL Server database. The
database is hosted on a Web server. Users will use the Internet to access the Customer database through
the ServerSyncProvider. You write the following code segment. (Line numbers are included for reference
only.)
01SyncTable customerSyncTable = new SyncTable("Customer");
02customerSyncTable.CreationOption = TableCreationOption. UploadExistingOrCreateNewTable;
03
04customerSyncTable.SyncGroup = customerSyncGroup;
05 this.Configuration.SyncTables.Add(customerSyncTable);
You need to ensure that the application meets the following requirements: "Users can modify data locally
and receive changes from the server. "Only changed rows are transferred during synchronization. Which
code segment should you insert at line 03?

A. customerSyncTable.SyncDirection = SyncDirection.UploadOnly;

B. customerSyncTable.SyncDirection = SyncDirection.DownloadOnly;

C. customerSyncTable.SyncDirection = SyncDirection.Bidirectional;

D. customerSyncTable.SyncDirection = SyncDirection.Snapshot;

正解：C 解答を投票する

出題：9

You use Microsoft Visual Studio 2010, Microsoft Sync Framework, and Microsoft .NET Framework 4 to create an application. You have a ServerSyncProvider connected to a Microsoft SQL Server database. The database is hosted on a Web server. Users will use the Internet to access the Customer database through
the ServerSyncProvider. You write the following code segment. (Line numbers are included for reference
only.)
01SyncTable customerSyncTable = new SyncTable("Customer");
02customerSyncTable.CreationOption = TableCreationOption. UploadExistingOrCreateNewTable;
03
04customerSyncTable.SyncGroup = customerSyncGroup;
05 this.Configuration.SyncTables.Add(customerSyncTable);
You need to ensure that the application meets the following requirements: "Users can modify data locally
and receive changes from the server. "Only changed rows are transferred during synchronization. Which
code segment should you insert at line 03?

A. customerSyncTable.SyncDirection = SyncDirection.UploadOnly;

B. customerSyncTable.SyncDirection = SyncDirection.DownloadOnly;

C. customerSyncTable.SyncDirection = SyncDirection.Bidirectional;

D. customerSyncTable.SyncDirection = SyncDirection.Snapshot;

正解：C 解答を投票する

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