70-516 Q & A / Study Guide

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft MCITP Training at certkingdom.com

 


QUESTION 1
Exhibit:
ee.SELECT EmployeeID, Name, Region, Country FROM dbo.Employees .
There is a MS Visual Studio 2010 and MS .NET Framework 4 application CertKingdomApp.
CertKingdomApp connects to a MS SQL Server 2008 database CertKingdomDB.
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?

Answer:


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

A. Use entity set attribute…
B. Use entity set operator…
C. Use entity set function…
D. ISNULL
E. IN
F. EXISTS
G. ANYELEMENT
H. EXCEPT
I. EMPTYCOLLECTION

Answer: B,F

Explanation:


QUESTION 3
There is MS Visual Studio 2010 and MS .NET Framework 4 application CertKingdomApp.
CertKingdomApp uses this service to connect to a MS SQL Server 2008 database
CertKingdomDB.
To access data from CertKingdomDB Entity SQL is used.
How should you enable query plan caching? Select two.

A. Use a stored procedure…
B. Use object…
C. Use function…
D. Use operator…
E. EntityConnection
F. queryPlanCaching
G. EntityCommand
H. EntityCaching
I. EntityDataReader
J. sp_caching
K. EnableCaching
L. caching
M. EntityTransaction

Answer: B,G

Explanation:


QUESTION 4
There is MS Visual Studio 2010 and MS .NET Framework 4 application CertKingdomApp.
CertKingdomApp connects to a MS SQL Server 2008 database CertKingdomDB.
CertKingdomApp is calling a stored procedure that has a table-valued parameter.
What steps do you need to take to make this work?

Answer:


QUESTION 5
There is MS Visual Studio 2010 and MS .NET Framework 4 application CertKingdomApp.
CertKingdomApp connects to a MS SQL Server 2008 database CertKingdomDB.
CertKingdomApp is calling a stored procedure that is using a spatial value parameter.
What steps do you need to take to make this work?

Answer:

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft MCITP Training at certkingdom.com

About the author /


Archives

Latest

+

Random

+
February 2012
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
272829