Exam 70-765 topic 3 question 85 discussion

Actual exam question from Microsoft's 70-765

Question #: 85
Topic #: 3

HOTSPOT -
A company has an on-premises Microsoft SQL Server environment with a SQL-Server named SQL01.
You need to create a local sysadmin account on SQL01 named Admin1.
How should you complete the Transact-SQL statements? To answer, select the appropriate Transact-SQL segments in the answer area.
Hot Area:

Show Suggested Answer

Suggested Answer:

Expalantion:
B: First we create a login with the CREATE LOGIN command.
E: Then we add it to the sysadmin role.
1. To add a member to a fixed server role
2. In Object Explorer, connect to an instance of Database Engine.
3. On the Standard bar, click New Query.
Copy and paste the following example into the query window and click Execute.
ALTER SERVER ROLE diskadmin ADD [Domain\Juan] ;

GO -
G: Finally we add a database user for the login we created.
References: https://technet.microsoft.com/en-us/library/aa337562(v=sql.110).aspx

by manman at July 18, 2019, 12:51 p.m.

Comments

Submit Cancel

manman

Highly Voted 6 years ago

The last statement should be CREATE USER [Admin] FOR LOGIN [Admin]

upvoted 19 times

...

RohitM

Highly Voted 5 years, 9 months ago

Last option seems incorrect. Once a login is sysadmin you don’t have to add a user for it in a particular database. Login has access on every database anyway. Question doesn’t make sense giving that 3rd option.

upvoted 9 times

...

KC

Most Recent 5 years, 1 month ago

The answer is correct. You need to use GRANT to allow the the server permissions. The question is more concerned with those server permissions than the database permissions. https://docs.microsoft.com/en-us/sql/t-sql/statements/create-login-transact-sql?view=sql-server-ver15

upvoted 1 times

axdev

4 years, 12 months ago

The command would have looked differently then https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-server-principal-permissions-transact-sql?view=sql-server-ver15. Only CREATE USER is right here.

upvoted 3 times

...