You are creating an HTTP endpoint that will be used to provide customer data to external applications. Your
SQL Server 2005 computer is named SQL1. You create a stored procedure named dbo.usp_GetPersonData to
retrieve the data in the AdventureWorks database. You create the endpoint by using the following code.
CREATE ENDPOINT SQLEP_AWPersons
AS HTTP
(PATH = ‘/AWpersons’,
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = ‘SQL1’)
FOR SOAP
(WEBMETHOD ‘PersonData’
(NAME=’AdventureWorks.dbo.usp_GetPersonData’),
BATCHES = DISABLED,
WSDL = DEFAULT,
DATABASE = ‘AdventureWorks’,
NAMESPACE = ‘http://Adventure-Works/Persons’)
The first users to connect to the endpoint tell you that they do not get any data. You connect to the endpoint and
discover that it is not responding.
You need to modify the endpoint so that data is returned as expected.
What should you do?
A.
Change the AUTHENTICATION property to KERBEROS.
B.
Specify BATCHES = ENABLED.
C.
Specify STATE = Started.
D.
Specify WSDL = ‘pr_GetPersonData’.