You create a Windows application by using the .NET Framework 3.5.
The application has a complex form that is used to capture information.
Users of the application enter data in the forms quickly by using tabs to navigate through the form controls.
They must be immediately notified when they enter invalid data in the form controls.
You need to notify the users without blocking the data entry process.
Which control should you use?

You are creating a Windows application by using the .NET Framework 3.5.
The application has the following specifications:
It uses a centralized Microsoft SQL Server 2008 database instance.
It is deployed to several computers within the network.
It retrieves and updates the records of the Customer table.
A customer record can exist on multiple forms within the application. Users log on to the application by
using their unique user ID. You implement optimistic concurrency on the Customer table.
You need to design a strategy to detect conflicts by using minimum amount of network bandwidth.
What should you do?

You are creating a Windows application that processes sales orders by using the .NET Framework
3.5.
The application has the following specifications:
It connects to a Microsoft SQL Server 2008 database.
It retrieves data from a table named Products.
The product table has three columns named Name, Description, and Quantity. The application uses the
Name and Description columns as lookup fields. It updates the Quantity column when orders are placed.
You need to design a concurrency management strategy that meets the following requirements:
Data integrity is maintained during the update process.
Database locking for the lookup data is minimal.
What should you do?

You are creating a Windows application by using the .NET Framework 3.5.
The application will be used for processing sales orders.
Individual product quantities are retrieved from the database before an order is placed. The product
quantity is reduced after an order is placed.
You need to design a concurrency model to ensure that the correct product quantity on hand is displayed
at all times.
What should you do?

You create a Windows application by using the .NET Framework 3.5.
The application connects to a Microsoft SQL Server 2008 database table named Customer to retrieve and
display customer information.
Users of the application view and modify data from the Customers table. You plan to use a DataAdapter
object and a DataSet object to retrieve data.
You need to select an appropriate concurrency strategy that maintains data integrity and scalability.
What should you do?

You are creating a Windows application by using the .NET Framework 3.5.
You can use data manipulation operations on the entities stored in a database. You are designing a data
access layer for the application.
The database schema can change.
You need to ensure that the application is minimally affected by the changes made to the database
schema.
What should you do?

You create a Windows application by using the .NET Framework 3.5.
The application will connect to a Microsoft SQL Server 2008 database on the network. You are creating
the data access layer for the application.
The database schema will change regularly.
You need to ensure that the schema changes can be applied with minimum possible development effort.
Which data access technology should you use?

You are creating a Windows application by using the .NET Framework 3.5.
The application has the following features:
Users access the application from their local computers.
Each user specifies the data file to be used for the current session at the start of the application.
You plan to design a strategy to enable users to share their data files with other users.
You need to implement the strategy to meet the following requirements:
Users can open the data file only by using a password.
Users can work on the data file only by using the application.
What should you do?

You are creating a Windows application by using the .NET Framework 3.5.
The application is connected to a database named Contoso_DB on the corporate network.
You need to ensure that the following requirements are met:
The application can modify the data when it is offline.
The application can update the changes to or from the Contoso_DB database when it is online.
What should you do?

You are creating a Windows application by using the .NET Framework 3.5.
The application will retrieve and save data that is located on the network. The application will be deployed
to client computers that retrieve and save data from a shared location.
You need to ensure reliable storage of data.
Which data storage mechanism should you use?