DRAG DROP
Exhibit:
ee.SELECT EmployeeID, Name, Region, Country FROM dbo.Employees .
There is a MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server 2008 database PassGuideDB.
A SQL statement is used to retrieve dataset instance (see exhibit).
You need to use this dataset to access rows where the Name field is not null.
Which code should you use?

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server 2008 database PassGuideDB.
To access data from PassGuideDB Entity SQL is used.
How can you check if a collection is empty or not? Select two.

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 Entity SQL is used.
How should you enable query plan caching? Select two.

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 is calling a stored procedure that has a table-valued parameter.
What steps do you need to take to make this work?

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 is calling a stored procedure that is using a spatial value parameter.
What steps do you need to take to make this work?

DRAG DROP
Exhibit:

<ApplicationMenu>
<MenuItem name’Code’>
<MenuItem name=’Region’>
<MenuItem name’Web Site’>
<MenuItem name=’Flamenco’>
<MenuItem name=”Employees”>
<MenuItem name’PassGuide Office”>
</MenuItem>
</MenuItem>
</ApplicationMenu’>
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp includes some XML code being displayed in the exhibit.
PassGuideApp uses the Xml Document class to query the XML.
PassGuideApp must return all descendant elements of the specific Menuitem elment that
has a name attribute Flamenco.
Which XPATH expression should be used?

DRAG DROP
Exhibit:
Country=England AND Salary > 20000
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
An ASF data service service is created.
This service use the URL http://PassGuide.com/PassGuide.svc.
The service return employee objects sorted by in ascending order by country and salary.
Only objects meeting the criteria displayed in the exhibit should be retrieved.
Which URL should you use?

DRAG DROP
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
An WCF data service service is created.
This service use the URL http://PassGuide.com/PassGuide.svc.
You need to an HTTP request to update the Country property of an Employees record
which has a value of as 1000. The other properties should not be changed.

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.