DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance. The instance has a
Products table that is currently in the OevUser schema. The Appusers database role is
assigned Read and update permissions to the table.
The DevUser schema is owned by a database login that has been renamed. You need to
move the Products table from the DevUser schema to the dbo schema. Which two actions
should you perform in sequence? (To answer, move the appropriate actions from the list of
actions to the answer area and arrange them in the correct order.)

You administer a SQL Server 2008 instance.
You need to allow users on the SQL Server instance to query remote data sources by using
the OPENROWSET() function.
Which sp_configure configuration option should you configure?

You administer a SQL Server 2008 instance.
A user named Julie reports repeated failed connections because of incorrect password
usage for the login name srpc8521. Julie has been able to successfully login using this
account in the past. Julie then recalls the correct password. However, her connection is still
denied.
You need to enable the SQL Server login.
Which Transact-SQL statement should you use?

DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database that contains customer invoice
accounts.
Backups are performed according to the following schedule:
-Full database backup at 00:00 hours daily. -Transaction log backups at 06:00 hours, 14:00
hours, and 20:00 hours daily.
You discover that the database failed at 11:59 hours. You also discover that the database is
no longer accessible due to a failure of the hard disk drive that contains the database data
file.
You need to restore the database. You also need to ensure that data loss is minimal.
Which four actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)

You maintain multiple SQL Server 2008 instances.
You develop a failure recovery strategy.
You need to find out the edition and the build of SQL Server that is deployed in your
environment.
What should you use to find the required information?

DRAG DROP
You administer a Microsoft SQL Server 2008 R2 server that hosts two databases named
NorthwindOLTP and NorthwindOLAP. Cross database ownership chaining is currently
disabled for all databases.
A stored procedure in the NorthwindOLTP database writes data to a table in the
NorthwindOLAP database. The public role in both databases has only Read and Execute
permissions assigned to all objects. All objects are located in the DBO schema. Guest
access has been disabled for all databases on the server.
You need to ensure that the stored procedure can execute successfully.
Which two actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)

DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance. The service account
used by SQL Server services must not have administrative permissions.
You configure a new SQL Server Agent job to run every night. One of the steps in the job
runs a PowerShell step. The job continuously fails on this step and throws the following error
message:
“The process could not be created for step 1 of job (reason: A required privilege is not held
by the client). The step failed.”
You need to ensure that the SQL Server Agent Job executes successfully.
Which four actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)

DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance that supports a sales
management application.
Occasionally, users of the application report that they receive a deadlock error. You plan to
troubleshoot this error.
You need to ensure that the instance is configured to capture troubleshooting information
that will allow you to isolate the cause of the error.
Which two actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)

You maintain a SQL Server 2008 instance that contains a database named Finance.
You need to configure SQL Server to automatically send an e-mail message when any file in
the Finance database increases.
Which technology should you include in your solution?

You administer a Microsoft SQL Server 2008 instance that contains two databases named
Work and WorkHistory. Work uses the Latin1_General_CS_AS collation. WorkHistory uses
the Latin1_General_100_CI_AI collation.
Each database has an Orders table that has the following definition: You need to return
records from WorkHistory.dbo.Orders that exist in Work.dbo.Orders. Which Transact-SQL
query should you use?