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?

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 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 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 numbers 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 modifying an existing Windows Presentation Foundation (WPF) application that
uses .NET Framework 4. The WPF application uses a wizard to capture data and insert the
data into a database. The database includes one parent table and many child tables.
Inserting captured data in the database locks many database tables and delays application
access. You have the following requirements: • Reduce delays when saving data. • Ensure
that other application users are not blocked from reading data. • Ensure that captured data
is available only after all child tables are updated. You need to recommend an approach for
inserting captured data into the database. What should you recommend?

You are developing an application by using Microsoft .NET Framework 4 and Microsoft
Visual Studio 2010. The application contains a grid that displays customer data stored in a
database table. Users report that the grid takes a long time to display. You plan to
implement data caching to improve loading time for the grid. You need to ensure that the
cached data expires when the customer data is updated. What should you do?

You are designing a Windows Presentation Foundation (WPF) application. The WPF

application displays indicators to compare your company’s past performance to the current
day’s operations data. The WPF application accesses historic data from your company’s
data warehouse through a Web service, and accesses current data directly from a Microsoft
SQL Server 2008 database. The WPF application must meet the following requirements:
Retrieve historic data from the data warehouse at application startup and then once per day.
Retrieve current data from the database every five minutes, and then update the indicators.
Cache all retrieved data. Target the .NET Framework 4 Client Profile. You need to
recommend an approach to data caching. What should you recommend?

You are analyzing a Windows client application that uses Microsoft Visual Studio 2010 and
Microsoft SQL Server 2008. The application updates two database tables from the main
user interface (UI) thread. You need to ensure that the following requirements are met: The
database tables are either updated simultaneously or not updated at all. Users are notified
of the success or failure of the updates. Users are able to perform other tasks during the
update process. What should you do?

You are designing a Windows Presentation Foundation (WPF) application that accesses a
Microsoft SQL Server 2008 database. You must ensure that database administrators can
change the structure of database tables without requiring redeployment of the WPF
application. You need to recommend a data modeling and data access strategy. What
should you recommend?