WHEN CREATING THE ENDPOINT, WHAT HAPPENS WHEN THE STATE ARGUMENT I...

14. When creating the endpoint, what happens when the STATE argument is set

to STARTED?

A. The endpoint is started, and it is actively listening for connections.

B. The endpoint will not start until after the database server has been

restarted.

C. The endpoint will start when SQL Agent calls it.

D. The endpoint will start when a user requests it.

The correct answer is A. Answers B, C, and D are incorrect because these

events are not accurate in relation to setting the STATE argument to

STARTED.