You are a database developer for a company that manufactures bicycles. You are creating a Web application that will retrieve data from a database named Certkiller . The application connects to a database server that is running SQL Server 2005. One of the functions of your application will allow shift supervisors to see how many bicycles were manufactured during the current shift. A user named Tom creates a stored procedure named usp_GetPersonData in the dbo schema. You are creating an HTTP endpoint that exposes a Web method named PersonData. This Web method allows client applications to access the stored procedure. You use the following statement to create the endpoint.
CREATE ENDPOINT SQLEP_AWPersons
AS HTTP (PATH = ‘/AWpersons’, AUTHENTICATION = (INTEGRATED), PORTS = (CLEAR), SITE = ‘SQL1’)
FOR SOAP (WEBMETHOD ” (NAME=”), BATCHES = DISABLED, WSDL = DEFAULT, DATABASE = ‘ Certkiller ‘, NAMESPACE =
‘http://Adventure-Works/Persons’)
You need to specify the correct WEBMETHOD and NAME to create the endpoint.
Which command should you use?
A.
WEBMETHOD ‘http://www.adventure-works.com /PersonData’ NAME = ‘ Certkiller .dbo.usp_GetPersonData’
B.
WEBMETHOD ‘PersonData’NAME = ‘ Certkiller .dbo.usp_GetPersonData’
C.
WEBMETHOD ‘PersonData’NAME = ‘ Certkiller .Tom.usp_GetPersonData’
D.
WEBMETHOD ‘ Certkiller .PersonData’NAME = ‘ Certkiller .Tom.usp_GetPersonData’
Explanation:
The general format of the WEBMETHOD portion of the SOAP payload is as follows:
[ { WEBMETHOD [ ‘namespace’ .] ‘method_alias’
( NAME = ‘database.owner.name’
[ , SCHEMA = { NONE | STANDARD | DEFAULT } ]
[ , FORMAT = { ALL_RESULTS | ROWSETS_ONLY | NONE } ] )