You administer two SQL Server 2008 instances on separate servers named Server1 and
Server2.
The AdventureWorks database is set up for synchronous mirroring between the two
instances.
You need to configure the database to support automatic failover.
What should you do?

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 an
Operating System (CmdExec) step. The job continuously fails on this step and throws the
following error message: “The user does not have sufficient permission to perform the
operation.”
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.)

You administer a Microsoft SQL Server 2008 R2 instance.
You need to check the physical consistency of the database.
What should you do?

You administer a Microsoft SQL Server 2008 R2 instance.
You need to rectify a damaged index without losing any data.
What should you do?

You administer a SQL Server 2008 instance that contains a database named DB1. DB1
contains a table named Sales.Table1.
You need to obtain the effective permissions of a user named User1 to access the
Sales.Table1 table.
Which Transact-SQL statement(s) should you execute in the DB1 database?

You administer a SQL Server 2008 instance. A payroll application is used to store sensitive
data in a database named PayrollDB.

You plan to implement the following security measure: -All the data files, log files, and
backup files of the database are automatically encrypted. You need to devise a method to
encrypt data. What should you include in your solution?

DRAG DROP
You administer a Microsoft SQL Server 2008 R2 instance by using a database named
AdventureWorks2008R2.

You need to implement transparent data encryption for a database hosted by the server.
Which four Transact-SQL statements should you use? (To answer, move the appropriate
SQL statements from the list of statements to the answer area and arrange them in the
correct order.)

DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database installed along with the default
settings.

You want to migrate a database from a SQL Server 2000 server that is being
decommissioned. The application executes a number of Windows command-line calls from
stored procedures in the database.
You need to configure SQL Server 2008 R2 to allow command-line calls from this database.
Which three 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 Microsoft SQL Server 2008 R2 database that contains an OrderItems
table. The table has the following definition:

Currently, the table is not partitioned and contains no indexes.
You need to partition the table by year.
What should you do?