You work as a database developer at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com that manufactures bicycles. At present you are creating a Web application that will retrieve data from a database named Certkiller -DB01. Currently the application connects to a database server that is configured to run SQL Server 2005. One of the functions of this application will permit shift managers to see the amount of bicycles that was manufactured during the current shift. A Domain.com employee named Kara Lang creates a stored procedure named usp_GetPersonData in the dbo schema. You create an HTTP endpoint that exposes a Web method named PersonData. This Web method permits client applications to access the stored procedure.
Kara Lang makes use of 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 identify the correct WEBMETHOD and NAME to create the endpoint.
What command should you use?
A.
WEBMETHOD ‘PersonData’NAME = ‘ Certkiller .Tom.usp_GetPersonData’ is the command that needs to be used to create the endpoint.
B.
WEBMETHOD ‘http://www.adventure-works.com/PersonData’ NAME = Bill.dbo.usp_GetPersonData’ is the command that needs to be used to create the endpoint.
C.
WEBMETHOD ‘ Certkiller .PersonData’NAME = ‘ Certkiller .Tom.usp_GetPersonData’ is the command that needs to be used to create the endpoint.
D.
WEBMETHOD ‘PersonData’NAME = ‘ Certkiller .dbo.usp_GetPersonData’ is the command that needs to be used to create the endpoint.
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 } ] )