Microsoft
70-450 · Question #49
70-450 Question #49: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #49. The question stem and answer options stay visible for context.
Question
You administer two SQL Server 2008 instances named Instance1 and Instance2. A database named Customers resides on Instance1. You move the Customers database from Instance1 to Instance2. A SQL Server login named User1 that has the password "111999" is used by a user to access the database on Instance1. You create the same SQL Server login on Instance2. The user attempts to access the Customers database on Instance2 by using the SQL Server login User1. However, the user receives an error message which indicates that the access to the Customers database is denied. You need to ensure that User1 can access the Customers database. Which Transact-SQL statements should you execute on Instance2?
Options
- AUSE Customers; ALTER USER User1 WITH LOGIN = User1;
- BUSE Customers; ALTER USER User1 ENABLE;
- CUSE Customers; ALTER LOGIN User1 WITH PASSWORD = '111999' UNLOCK;
- DUSE Customers; ALTER LOGIN User1 WITH DEFAULT_DATABASE = Customers;
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.