70-516 Q & A / Study Guide

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:

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