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

The application uses LINQ to SQL to retrieve and modify data from a Microsoft SQL Server 2008 database.

Queries will be frequently executed in the application. However, concurrency validation is not required on the data.

You need to optimize the performance of the application.

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

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?

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?

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

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

The application stores data in a database that might be implemented in Microsoft SQL Server, Microsoft Access, or a variety of third-party databases.

You need to implement a data access strategy that meets the following requirements:

– The same data access code is used for all database platforms.
– The application defines the SQL syntax used.
– The application reduces the vulnerability to SQL injection attacks.

What should you do?

You are creating ASP.NET applications by using the .NET Framework 3.5.

The application has two tables named Products and ProductPrice.

The application retrieves and stores data from the Product table into a Dataset object. The application uses the DataSet object to modify and update the data that is retrieved. The update command for the related SqlDataAdapter class is generated automatically by using a SqlCommandBuilder object.

You plan to retrieve and modify data from the Product and ProductPrice tables as a unit.

You need to ensure that the application can update the data in the tables.

What should you do?

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

The master page contains a Web control that retrieves data from several data sources, including Microsoft SQL Server 2008 and Microsoft Access 2007.

You need to ensure that the Web control can provide the retrieved data for use in other controls on the page.

What should you do?

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

The application will contain a Data Access Layer (DAL) that will support databases from third-party vendors. The application will display data by using a GridView control.

You need to ensure that the application meets the following requirements:

– Allow paging
– Provide optimistic concurrency

Which data access object should you use in the DAL?

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

Each page within the application will contain a disclaimer that will use a Label control. The Label control on each page will need to support localization in English and French.

You need to implement a resource file strategy that meets the following requirements:

– A French-region user views the disclaimer in French.
– All other users view the disclaimer in English.

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

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

Airline passengers access the application over the Internet and from airport kiosks around the world. The airport kiosks do not allow users to modify browser settings.

You have created language-specific resources for all static text elements in the application.

You need to ensure that the content is displayed in the preferred language of the users, regardless of their physical location.

What should you do?