Administering Microsoft SQL Server 2012/2014 Databases — Question 31

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.

Answer options

• 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 ACG

Correct answer:

Explanation

The correct steps involve creating a new endpoint specifically for Application3 and managing access to it. Option C creates the new endpoint, while option A allows Application3 to connect to the default TCP endpoint, which is necessary for it to function. Option B denies access to Application3, which contradicts the requirement. The other options do not directly support the need to ensure that only Application3 can use the new endpoint.