There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server 2008 database PassGuideDB.
PassGuideApp uses Data Contexts to access data from the database.
The Data Contexts allows PassGuideApp online changes to be submitted back to the SQL
Server.
PassGuideApp stores Employee data offline.
PassGuideApp enables end users to edit employee records while they are not connected to
PassGuideDB.
PassGuideApp must be able to detect conflicts between the offline and online data.
PassGuideApp must allow rollback of offline updates.
What action should be taken? Select all that apply.

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server 2008 database PassGuideDB.
PassGuideApp uses EDM to model entities. These entities includes Employees to
PassGuideDB.
You must add a new Employees entity, but you do not want to set all properties of the
entity.
What should you do? Select three.

DRAG DROP
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server 2008 database PassGuideDB.
PassGuideApp uses EDU to model entities. These entities includes Product and
Product_details.
PassGuideApp is a multi-tier application.

You are going to do a search on the Product table. To make the search faster you deattach
Product_details.
The search is performed.
How can you at this point ensure that any changed made on the Product_details (by end
users for example) are saved in PassGuideDB as well.

DRAG DROP
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp uses this service to connect to a MS SQL Server 2008 database
PassGuideDB.
To access data from PassGuideDB ADO.NET Entity Framework is used.
PassGuideApp manages Product and Product_details records.
A new Product_details record, for an existing product, is added. How can you associate the
new Product_details record to the correct Product details.

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to several SQL Server databases.
Within PassGuideApp there is a function PG_fn.
PG_fn changes a product record, that are stored in severalSQL Server databases, within a
single transaction.
How can ensure that the transactions can be recovered? Select two.

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to several SQL Server databases.
Within PassGuideApp there is a function PG_fn.
PG_fn changes a product record, that are stored in severalSQL Server databases, within a
single transaction.
Assume there is a resource failure.
How can you ensure that the unresolved transactions can be managed? Select two.

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a SQL Server database over the local network.
PassGuideApp uses data from different related database tables.
Assume there the connection is unavailable or disconnected.
PassGuideApp must still work in this circumstance.
How can you achieve this? Select two.

DRAG DROP
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
There is a web page PassGuideWP.
On PassGuideWP is a Gridview control PassGuideGW.
PassGuideGW displays employee information in a table.
PassGuideGW uses a Data Table as data source.
A Table Adapter is used for the Data Table.
How can you make sure that new employees data is retrieved whenever PassGuideWP is
refreshed while keeping current employee data?

DRAG DROP

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp uses this service to connect to a MS SQL Server 2008 database
PassGuideDB.
PassGuideApp puts password and credit card information in PassGuideDB.
How can you ensure that users are unable to access the password in PassGuideDB?

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp uses this service to connect to a MS SQL Server 2008 database
PassGuideDB.
PassGuideApp puts password and credit card information in PassGuideDB.
How can you ensure that the credit card information can be retrieved from PassGuideDB?
Select two.