Exam 70-765 topic 3 question 69 discussion

Actual exam question from Microsoft's 70-765

Question #: 69
Topic #: 3

You administer a Microsoft SQL Server 2012 instance named SQL2012. You are in the process of migrating a database from a SQL Server 2008 instance named
SQL2008 to the SQL2012 instance.
You have upgraded a database from the SQL2008 instance by using the side-by-side migration technique.
You need to migrate the SQL Server logins from the SQL2008 instance to the SQL2012 instance.
What should you do?

A. Back up the master database on the SQL2008 instance. Restore the master database on the SQL2012 instance
B. Use the Transfer Logins task in a Microsoft SQL Server Integrated Services package
C. Use sp_grantlogin
D. Use xp_logininfo.

Show Suggested Answer

Suggested Answer: C 🗳️
sp_grantlogin creates a SQL Server login.
Incorrect Answers:
D: xp_logininfo returns information about Windows users and Windows groups.
References:
https://technet.microsoft.com/en-us/library/ms173449(v=sql.110).aspx

by AlexandreVM at May 9, 2019, 2:15 p.m.

Comments

Submit Cancel

AlexandreVM

Highly Voted 5 years, 7 months ago

B!!!!!!!

upvoted 11 times

KC

4 years, 5 months ago

Yup: https://www.sqlshack.com/migrate-logins-database-different-server/

upvoted 1 times

...

RohitM

Highly Voted 5 years, 2 months ago

Answer is B

upvoted 5 times

...

sql14

Most Recent 4 years, 2 months ago

Should be B

upvoted 1 times

...

Varad

5 years, 1 month ago

Yes. It should be B