Which three statements should you execute?

You manage a server that has SQL Server installed and hosts databases for five applications. Each application has a different login to the SQL Server instance.
You need to create a TCP endpoint to be used only by a login named Application3. The solution must ensure that Application3 only uses the new endpoint.
Which three statements should you execute? Each correct answer presents part of the solution.
A. GRANT CONNECT ON ENDPOINT::[TSQL Default TCP] TO Application3
B. DENY CONNECT ON ENDPOINT::[TSQL Default TCP] TO Application3
C. CREATE ENDPOINT Application3_EndPoint STATE=STARTED AS TCP (LISTENER_PORT=1388)
D. GRANT .CONNECT ON ENDPOINT:: Application3_EndPoint TO Public
E. GRANT CONNECT ON ENDPOINT::[TSQL Default TCP] TO PUBLIC
F. REVOKE CONNECT ON ENDPOINT::[TSQL Default TCP] TO Application3
G. REVOKE CONNECT ON ENDPOINT::[TSQL Default TCP] TO PUBLIC

microsoft-exams

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.