You are designing a Windows Presentation Foundation (WPF) application by using
Microsoft .NET Framework 4 and Microsoft Visual Studio 2010. You plan to create a
Customer object that contains an Orders property. The Orders property contains an array of
Order objects. When users browse Customer objects, they must be able to optionally view
Order objects. You need to design a data access strategy that retrieves data only when
necessary. Which strategy should you use?

You are designing the data access layer (DAL) for an application that uses Microsoft SQL
Server 2008, Microsoft ADO.NET, and Microsoft Visual Studio 2010. Conflicts are occurring
in the SQL Server database due to concurrent updates. You need to design a database
locking strategy that meets the following requirements: Resolves concurrent update conflicts
without loss of data Ensures that data conflicts can be resolved by users Locks only the
data necessary for updates What should you do?

You are designing an application by using Microsoft .NET Framework 4, Microsoft Visual
Studio 2010, and Microsoft SQL Server 2008. The application will be used by a sales team
to enter sales orders and update customer information. You need to ensure that the
application meets the following requirements: Allows users to enter sales orders while their
computers are disconnected from the network Uploads sales orders to the server database
when connected to the network Compiles against the .NET Framework 4 client profile What
should you use?

You are designing a sales and inventory tracking system by using Microsoft Visual Studio
2010 and Microsoft SQL Server 2008. The sales, inventory, and shipping tables will reside
in different databases on different database servers. You need to ensure that the tables are
updated simultaneously. What should you do?

You are developing a Windows application by using Microsoft .NET Framework 4, Microsoft
Visual Studio 2010, and Microsoft SQL Server 2008. New features that require changes to
be made to the database schema are added to the application every week. You need to
ensure that the changes made to the database schema do not require the application to be
recompiled. Which two actions should you perform? (Each correct answer presents part of
the solution. Choose two.)

You are designing a Windows application by using Microsoft .NET Framework 4 and
Microsoft Visual Studio 2010. You plan to implement control caching to improve the loading
time of a control. It is not required to refresh the content of the control after the application
loads. The application will be compiled by using the .NET 4 client profile. You need to
ensure that the following requirements are met: The control is reusable in multiple forms.
Data in the control is cached when the application is loaded. What should you do?

You are designing an application by using Microsoft .NET Framework 4 and Microsoft
Visual Studio 2010. The application is used mostly in a disconnected scenario. The
application requires offline data from a Microsoft SQL Server 2008 database. When the
application connects to the network, data will be modified and synchronized. You need to
ensure that the application does not access the database server directly to synchronize data
when online. Which technology should you use?

You are designing a Windows Presentation Foundation (WPF) application by using
Microsoft .NET Framework 4 and Microsoft Visual Studio 2010. You plan to create an
Author object that contains a Books property. The Books property contains a large array of
Book objects. When users browse through author data in the application, they must be able
to view all information related to books written by that author without additional queries. You
need to design a data access strategy that meets the requirement. Which strategy should
you use?

You are developing an application by using Microsoft .NET Framework 4 and Microsoft
Visual Studio 2010. You plan to use Microsoft Sync Framework to synchronize the data
stored in a local Microsoft SQL Server Compact Edition database with the data stored in a
centralized SQL Server 2008 database. Four columns are added to each table involved in
the synchronization process to track changes to the database. You add the following four
columns to the database table. Users report that the synchronization process is not always
successful. You need to ensure that the application synchronizes data successfully. What
should you do?

You are designing a Windows application by using Microsoft .NET Framework 4, Microsoft
Visual Studio 2010, and Microsoft SQL Server 2008. You need to design a data access
strategy that meets the following requirements: Automatically tracks changes Maps the
database data model to the object model Which data access technology should you use?