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’



Leave a Reply 0

Your email address will not be published. Required fields are marked *