You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains a SQL Server 2005 computer named Certkiller -DB01.
You have received instruction from the CIO to create an HTTP endpoint that will be used to provide customer data to external applications. A Domain.com user named Andy Booth is a junior technician appointed in the Research and Development department. You instruct him to create a stored procedure named dbo.usp_GetResData to retrieve the information in the CK_R&D database. Andy Booth creates the endpoint by using the following code.
CREATE ENDPOINT SQLEP_R&DData
AS HTTP
(PATH = ‘/R&DData’,
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = ‘ Certkiller -DB01’)
FOR SOAP
(WEBMETHOD ‘PersonData’
(NAME=’ Certkiller .dbo.usp_GetResData’),
BATCHES = DISABLED,
WSDL = DEFAULT,
DATABASE = ‘CK_R&D’,
NAMESPACE = ‘http:// Domain.com/R&D’)
You receive various complaints by users stating that they are unable to get any data when they connect to the endpoint. As the administrator you connect to the endpoint and discover that it is not responding. You instruct Andy Booth to modify the endpoint in order that data is returned as expected.
What should he do?
A.
In order to receive data Andy Booth must specify WSDL = ‘pr_GetResData’.
B.
It is important that Andy Booth specify STATE = Started in order to rectify the data.
C.
In order to rectify the error Andy Booth should specify BATCHES = ENABLED.
D.
It is important that Andy Booth change the AUTHENTICATION property to KERBEROS.
Explanation:
The possible states for an endpoint are STARTED, STOPPED, and DISABLED. For an endpoint to respond to requests, the state must be set to STARTED. To comply with the SQL Server 2005 "off by default" approach to security, the default state is STOPPED.