Câu 42: 70-462: MCSA Administering Microsoft SQL Server 20122014 Databases

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.

1. A. GRANT CONNECT ON ENDPOINT::[TSQL Default TCP] TO Application3 — đáp án hiện tại
2. B. DENY CONNECT ON ENDPOINT::[TSQL Default TCP] TO Application3
3. C. CREATE ENDPOINT Application3_EndPoint STATE=STARTED AS TCP (LISTENER_PORT=1388) — đáp án hiện tại
4. D. GRANT .CONNECT ON ENDPOINT:: Application3_EndPoint TO Public
5. E. GRANT CONNECT ON ENDPOINT::[TSQL Default TCP] TO PUBLIC
6. F. REVOKE CONNECT ON ENDPOINT::[TSQL Default TCP] TO Application3
7. G. REVOKE CONNECT ON ENDPOINT::[TSQL Default TCP] TO PUBLIC — đáp án hiện tại