Question 17

Answer C is correct. To define a connection to use SSL, you must set the port to SSL. There is no such option as AS HTTPS; AS HTTP handles standard and SSL definitions. WSDL sets the document generation options and has nothing to do with the protocol used in the communication. BASIC authentication is the poorest of settings and should almost never be used. ENCRYPTION REQUIRED is the default setting when none is specified.

For more information, see the following sources:

• Chapter 5, "Data Consumption and Throughput"

• SQL Server 2005 Books Online: "SQL Server Language Reference, Transact-SQL Reference, CREATE ENDPOINT (Transact-SQL)"

• "Overview of Native XML Web Services for Microsoft SQL Server 2005," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2005websvc.asp

• Within MSDN Library, go to MSDN Home, MSDN Library, Servers and Enterprise Development, SQL Server, Overview of Native XML Web Services for Microsoft SQL Server 2005.