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 Application 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 . GRAN
E . CONNECT ON ENDPOINT:: Application3_EndPoint TO Public
F . GRANT CONNECT ON ENDPOINT::[TSQL Default TCP] TO PUBLIC
G . REVOKE CONNECT ON ENDPOINT::[TSQL Default TCP] TO Application3
H . REVOKE CONNECT ON ENDPOINT::[TSQL Default TCP] TO PUBLIC

View Answer

Answer: A,C,G