You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to several SQL Server databases. You create a function that modifies customer records that are stored in multiple databases.
All updates for a given record are performed in a single transaction. You need to ensure that all transactions can be recovered.
What should you do?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application updates several Microsoft SQL Server databases within a single transaction.
You need to ensure that after a resource failure, you can manage unresolved transactions. What should you do?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application uses the ADO.NET Entity Framework to model entities.
You need to ensure that the model and mapping files are not deployed as application resources. What should you do?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application uses the ADO.NET Entity Framework to model entities. You deploy an application to a production server.
The application uses the model and mapping files that are deployed as application resources.

You need to update the conceptual model for the application on the production server. What should you do?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application uses the ADO.NET Entity Framework to model persistence-ignorant entities. The application operates in a disconnected mode.
You need to ensure that changes made to local entities while the application is in the disconnected mode are correctly persisted.
Which method should you call before persisting changes?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application uses the ADO.NET Entity Framework to model entities.
The application allows users to make changes to entities while disconnected from the central data store.

You need to ensure that when the user connects to the central data store and retrieves new data, the application meets the following requirements:
* Changes made to the local data store in disconnected mode are preserved.
* Entities that have already been loaded into the local data store, but have not been modified by the user, are updated with the latest data.
What should you do?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Microsoft ASP.NET application.
The application connects to a Microsoft SQL Server database. The application is hosted on a Web server along with other applications.

You need to secure the transmission of data between the application and the database.
You need to achieve this goal without affecting other applications. What should you do?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server database. The application stores encrypted credit card numbers in the database.
You need to ensure that credit card numbers can be extracted from the database.
Which cryptography provider should you use?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server database. The application stores user names and passwords in the database.
You need to ensure that users cannot read passwords extracted from the database. What should you do?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You use a TableAdapter object to load a DataTable object.
The DataTable object is used as the data source for a GridView control to display a table of customer information on a Web page.

You need to ensure that the application meets the following requirements:
* Load only new customer records each time the page refreshes.
* Preserve existing customer records.
What should you do?