Which command should you use?

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 AdventureWorks. 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 = ‘AdventureWorks’,
NAMESPACE = ‘http://Adventure-Works/Persons’) You need to specify the correct WEBMETHOD and
NAME to create the endpoint. Which command should you use?

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 AdventureWorks. 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 = ‘AdventureWorks’,
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 =
‘AdventureWorks.dbo.usp_GetPersonData’

B.
WEBMETHOD ‘PersonData’NAME = ‘AdventureWorks.dbo.usp_GetPersonData’

C.
WEBMETHOD ‘PersonData’NAME = ‘AdventureWorks.Tom.usp_GetPersonData’

D.
WEBMETHOD ‘AdventureWorks.PersonData’NAME = ‘AdventureWorks.Tom.usp_GetPersonData’

Show Hint