Exam 70-462 topic 1 question 30 discussion

Actual exam question from Microsoft's 70-462

Question #: 30
Topic #: 1

You are migrating a database named Orders to a new server that runs Microsoft SQL Server 2012.
You attempt to add the [Corpnet\User1] login to the database. However, you receive the following error message:
"User already exists in current database."
You need to configure the [Corpnet\User1] login to be able to access the Orders database and retain the original permissions. You need to achieve this goal by using the minimum required permissions.
Which Transact-SQL statement should you use?

A. DROP USER [User1]; CREATE USER [Corpnet\User1] FOR LOGIN [Corpnet\User1]; ALTER ROLE [db_owner] ADD MEM3ER [Corpnet\User1];
B. ALTER SERVER RCLS Isysadmin] ADD MEMBER [Corpnet\User1];
C. ALTER USER [Corpnet\User1] WITH LOGIN [Corpnet\User1];
D. ALTER ROLE [db owner] ADD MEMBBR [Corpnet\User1]; C

Show Suggested Answer

Suggested Answer: Explanation 🗳️
Reference:
http://msdn.microsoft.com/en-us/library/ms176060.aspx

by Varad at Sept. 30, 2019, 7:47 p.m.