PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

Which LINQ query should you use?

You are creating an ASP.NET application by using the .NET Framework 3.5.

You use LINQ to SQL to query a Microsoft SQL Server 2008 database. You need to create a LINQ query to retrieve information on order and order details.

You need to ensure that the LINQ query executes the following SQL statement:

SELECT Order.OrderID

, Order.Description

, OrderDetails.UnitPrice

FROM Order JOIN OrderDetails

ON Order.OrderID = OrderDetails.OrderID

Which LINQ query should you use?

Which technology should you choose?

You are an enterprise application developer. You are creating an application for the sales department. Users in the sales department are occasionally connected to the network. Users enter orders through a smart client interface. The orders are sent to a business component that is installed on an application server. The business component updates the orders. You need to ensure that the orders are reliably delivered to the server. Which technology should you choose?

What should you do?

You are assigned only the Global Administrator role for the PerformancePoint Server. A user named User1 is assigned a Modeler role for a model. You add a domain user account named User2 to the user list on the PerformancePoint Server. You need to ensure that User2 is a member of an existing business role for the model. What should you do?

What should you do?

You are creating an ASP.NET application by using the .NET Framework 3.5.

You create a Web form in the application. You add a GridView control to the Web form.

You plan to use an existing business object. The business object provides the select, insert, update, and delete methods.

You need to implement data binding that will allow the GridView control to take full advantage of the business object.

What should you do?

What should you recommend?

You are an enterprise application developer. Your company operates a Microsoft Windows-based client application. The application is deployed to 50 client computers on the network. The application uses a separate class library as a data access layer. The data access layer is currently deployed to the application folder of the client application. It is time consuming to deploy new versions of the data access layer. You need to evaluate the current physical design of the application and recommend changes to speed up deployment of new versions of the data access layer.
What should you recommend?

Which two actions should you perform?

You are creating ASP.NET applications by using the .NET Framework 3.5. You plan to display data from a Microsoft SQL Server 2005 database. You write the following stored procedure. (Line numbers are included for reference only.)

01 CREATE PROCEDURE GetEventHistory

02 AS

03 SELECT HistoryID, EventName, EventDescription

04 FROM EVENTHistory FOR XML AUTO

You need to ensure that the Web page design meets the following requirements:

– Each row from the database is displayed on a separate row on the Web page.
– The result is displayed in a GridView control.

Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)

What should you conclude?

You are an enterprise application developer. Your company has a Web-based application that runs on a single Web server. Session information is currently being stored by using the default session mode. You are redesigning the application to run in a Web farm. You must ensure that the failure of any single server does not make session information unavailable. A developer in your team recommends using the default session mode on each server in the Web farm. You need to evaluate this recommendation. What should you conclude?