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 Data Contexts to access data from the database.
There a function emp_fn that updates the employees table when an employee is marked as
deleted, updates related entries in the Employee_Details table by marking them as deleted,
and prevents employee code to directly update the deleted field.
Now you need to improve emp_fn by checking that there are no Emplyee_details entries for
an employee before it is marked as deleted.
How can you change emp_fn without changing the rest of PassGuideApp (that is using emp_fn)?

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.
PassGuideDB includes two tables Employees and Employees_details with a foreign key
constraint between them.
How can you ensure that the Employees_details records are deleted, when you delete a
corresponding record in the Employee table.

How can this be ensured? Select two.

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.
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.
Even if PassGuideDB is disconnected the users should be able to make changes. That is
these changes made in offline mode changes must be updated in PassGuideDB.
At the moment when you use Submit changes method, from the data context, is used to
save offline entities then an exception is received.
What action should you take to remedy this problem?