You create a Web Service by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. The Web service will retrieve data from text files in a network share. The network share uses the NTFS file system permissions. You need to design a component that allows users to access only the files for which they have the necessary permission. What should you do?

You are creating a Web application for an enterprise solution by using Microsoft SQL Server 2008 and the .NET Framework 3.5. The application environment has the following specifications:

Several users access the same data.
Data does not change frequently.
The database schema is as shown in the exhibit. (Refer to the Exhibit.)

You need to build the business logic layer to meet the following requirements:

Support the DataRelation class.
Minimize redundant data.
Maintain the design of the original schema.

What should you do?

You create a class library by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. When an instance of the class is created, the class acquires a handle from the WIN32 DLL and saves the handle to a data member. You need to identify a strategy to ensure that the Win32 DLL handle releases resources when they are no longer being used. What should you do?

You are designing an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. The application implements the following design:

Client applications will be accessed by using a mobile device or a browser. All client applications will connect to a Windows Communication Foundation (WCF) service. All client applications will use Microsoft SQL Server Compact 3.5.

You need to ensure that the client applications can perform the following tasks:

Maintain local copies of data offline.
Synchronize changes.
Detect data conflicts.

What should you do?

You create an ASP.NET application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. The application uses a Microsoft SQL Server database. During testing, the application intermittently logs the following exception message:

“Transaction (Process ID xxx) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.”

The error cannot be reproduced in the development environment. You need to identify the root cause of the exception. What should you do?

You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. The application contains the following components:

A business tier component
A data access tier component
A Microsoft SQL Server database
The database stores sales order data. You plan to design a validation strategy that meets the following requirements:

For each order, the ship date must be greater than the order date. Validation errors must be detected as early as possible. Validation must be enforced regardless of which applications or application components modify the order data.

You need to ensure that the validation strategy meets the specified requirements. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. The application must use a local data store to support those applications that connect occasionally. You need to ensure that the local data store meets the following requirements:

It does not create additional services on client computers.
It provides synchronization capabilities to other data stores.

Which local data store should you use?

You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. The application contains several classes. A code review reveals redundant business logic within the classes in the application. You need to eliminate the redundant business logic in the classes. What should you do?

You create an ASP.NET application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. The application retrieves a large amount of application-wide data from a database. The data retrieval is very slow. The data gets refreshed every 30 minutes. You need to ensure that the data is available for frequent access. You also need to make the most efficient use of resources. Which storage mechanism should you use?

You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. The application currently generates output to a comma-delimited text file. Users have requested the output be generated to an XML file, a PDF file, or an HTML file. You need to design the application to allow output in different formats. You also need to allow addition of different output format types without recompilation of the application. Which three actions should you perform? (Each correct answer presents part of the solution. Choose three.)