nerdexam
Microsoft

70-458 · Question #98

You are migrating a database named Orders to a new server that runs Microsoft SQL Server 2012. You attempt to add a SQL login, [User1], to the database. However, you receive the following error…

The correct answer is B. Option B. See the full explanation below for the reasoning.

Question

You are migrating a database named Orders to a new server that runs Microsoft SQL Server 2012. You attempt to add a SQL login, [User1], to the database. However, you receive the following error message: "User already exists in current database." You need to configure the [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?

Exhibit

70-458 question #98 exhibit

Options

  • AOption A
  • BOption B
  • COption C
  • DOption D

How the community answered

(42 responses)
  • A
    5% (2)
  • B
    71% (30)
  • C
    17% (7)
  • D
    7% (3)

Community Discussion

No community discussion yet for this question.

Full 70-458 Practice