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?

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 developing a Windows application by using Microsoft .NET Framework 4, Microsoft
Visual Studio 2010, and Microsoft SQL Server 2003. 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 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 developing a Windows application by using Microsoft .NET Framework 4, Microsoft
Visual Studio 2010, and Microsoft SQL Server 2008. The application will store data in a
SQL Server database instance. You plan to use the Code Generation technology to develop
data entities. You need to ensure that the following requirements are met: • When the
application runs, a database must be created if it does not already exist. • When the
database schema changes, data entities must be added dynamically. Which data access
technology should you use?

You are developing a Windows application by using Microsoft .NET Framework 4 and
Microsoft Visual Studio 2010. The application will consume a Windows Communication

Foundation (WCF) service. The WCF service will provide data to the application. You plan
to use the ADO.NET Entity Framework to create a data model that will be used by the
application. Another development team makes changes to the WCF service data contract.
You need to ensure that changes made to the WCF service data contract do not require the
application to be recompiled. What should you do?

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. You plan to design an instrumentation strategy for the application. You
need to ensure that the strategy meets the following requirements: • Captures detailed
performance information. • Enables or disables diagnostic messages by using an
application configuration option without requiring the application to restart. What should you
design?

You are developing a Windows application by using Microsoft .NET Framework 4. You plan
to design a diagnostic logging strategy that will be used in a production environment. You
need to ensure that the strategy meets the following requirements: • Enables or disables

diagnostic messages by using an application configuration option. • Changes the level of
detail in the diagnostic messages without recompiling the application. Which class should
you use?