1. Identify the open standards used to facilitate native XML web services through the SQL Server 2005 Database Engine.

A. HTTP
B. RPC
C. SOAP
D. WSDL

2. Which functions can you use to insert an XML document into a table and set it to use the xml type? (Choose all that apply)

A.CAST
B.CONVERT
C.EXPLICIT XML
D.OPEN XML

3. Which operator is used to summarize data with subtotals and totals from two or more columns?

A. CUBE
B. EXCEPT
C. GROUP
D. ROLLUP

4. Which code do you use to start a transaction called UpdatePayroll?

A. BEGIN UpdatePayroll;
B. BEGIN TRANSACTION UpdatePayroll;
C. TRANSACTION UpdatePayroll;
D. TRANSACTION BEGIN UpdatePayroll;

5. You are creating an HTTP endpoint, and want to specify the authentication method. All users have Windows Domain user accounts and you want them to be able to be authenticated with a user name and password. The authentication method must be allowed by HTTP 1.1. Which authentication method should you use?

A. BASIC
B. DIGEST
C. INTEGRATED
D. KERBEROS
E. NTLM
F. None

Back to Top
Site Code:
DIRECT