Exam 70-462 topic 3 question 21 discussion

Actual exam question from Microsoft's 70-462

Question #: 21
Topic #: 3

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 ACG

Show Suggested Answer

Suggested Answer: Explanation 🗳️
C: Create the endpoint -
A: Grant permissions to Appliciation3 on the endpoint.
G: Revoke information from public on the endpoint.
Incorrect Answers:
B: We should grant, not deny, access to Application3.
D, E: Access to Public should not be granted.

by Eden at March 18, 2020, 6:19 p.m.

Comments

Submit Cancel

Fame

4 years, 9 months ago

CAG or CGA in Sequence of execution

upvoted 1 times

...

Eden

5 years, 2 months ago

The answer is ACG

upvoted 2 times

...