1. | Which protocol enables you to expose SQL Server data to heterogeneous clients? |
|
2. | When creating an HTTP endpoint, which option must be set to allow consumers to execute ad hoc queries against the endpoint? |
|
3. | When creating an HTTP endpoint, which option must be set to allow consumers to view a WSDL document associated with the endpoint? |
|
4. | When executing a query against a linked server, how is the data source identified in the query statement? |
|
Answers
1. | HTTP is the protocol, and you can create HTTP endpoints using the CREATE ENDPOINT statement. This enables you to expose SQL Server data as a Web service to clients that might not be running on the Windows platform. |
2. | You must set the BATCHES=ENABLED option in the CREATE ENDPOINT statement to allow consumers to execute ad hoc queries. Which queries can be executed will still be controlled by the level of access granted to the consumer making the request. |
3. | You must set the WSDL = DEFAULT option in the CREATE ENDPOINT statement for the WSDL document to be generated. This document can be used by consumers to generate a proxy that is used to connect a client application to the endpoint. |
4. | The linked server name is identified through a four-part name whose parts appear as follows:
|