You are analyzing an application that uses Microsoft .NET Framework 4 and Microsoft SQL Server 2008.

The application is used to maintain an inventory database and is accessed from several remote Windows client applications. The application frequently updates multiple rows in a database table by using a DbDotoAdopter object.

Users report that the application runs slowly during peak business hours.

When large number of records are changed by multiple users, you discover the following:
The CPU utilization of the client applications is normal.
The network utilization increases slightly.
The CPU utilization of the database server remains close to the normal average for a day.

You need to resolve the performance issue.

What should you do?

You are designing a Windows Presentation Foundation (WPF) application that will process data. The data is stored in a Microsoft SQL Server 2008 database. You plan to access the data by using ADO.NET Entity Framework 4.

You need to recommend an approach that minimizes the number of calls to the database server.

What should you recommend?

You are designing a Windows Presentation Foundation (WPF) application by using Microsoft .NET Framework 4, Microsoft Visual Studio 2010, and Microsoft SQL Server 2008.

You have designed the application to use the ADO.NET Entity Framework for the Data Access Layer (DAL).

You have designed the user interface (UI) of the application by using the Model-View-ViewModel (M-V-VM) pattern.

The middle tier of the application is designed by using Windows Communication Foundation (WCF).

The database schema changes often. The DAL entity objects are required to be referenced from the middle tier and the ViewModel layer of the UI.

You need to ensure that the DAL entity objects are updated when the database schema changes.

What should you do?

You are designing a .NET Framework 4 solution. The solution contains a Windows Presentation Foundation (WPF) application and a Windows Communication Foundation (WCF) Web service. The WPF application uses the WCF Web service to store data in a Microsoft SQL Server 2008 database.

You have the following requirements:
Ensure that the WPF application functions while users’computers are offline. Minimize the time spent sending data to the WCF Web service.
Minimize disk space requirements for data storage.

You need to recommend an approach for synchronizing data between the WPF application and the database.

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

You are designing an n-tier .NET Framework 4 solution that includes a Windows Presentation Foundation (WPF) application. The WPF application will access data stored in a Microsoft SQL Server 2008 database by using the solution’s data access tier.

The data access tier must also be available from within Microsoft Excel 2010.

You need to recommend a technology for accessing the data access tier.

Which technology should you recommend?