You administer a SQL Server 2008 instance.
A database developer named User1 needs to view the definitions of all database objects in a
database and read data from all user-defined tables, views, and table-valued functions.
You need to set the required permissions for User1. Which Transact-SQL statements should
you execute?

DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database named
AdventureWorks2008R2 that hosts a credit card-processing application.
You need to implement transparent data encryption.
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.)

You administer a Microsoft SQL Server database.
You plan to deploy a new database application. You want to use SQL Server common
language runtime (CLR) integration.
You need to ensure that CLR assemblies can be used.
What should you do?

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 instantiates ActiveX objects from stored procedures in the
database by using sp_OACreate.
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.)

DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance.
You need to identify the purpose of each Dynamic Management Views (DMVs).

What should you do? (To answer, drag the appropriate purpose to the correct DMV in the
answer area. Each purpose may be used once, more than once, or not at all. Each DMV
may be used once or not at all. Additionally, you may need to drag the split bar between
panes or scroll to view content.)

You administer a Microsoft SQL Server database that hosts an order-processing application.
Employees in the order entry group perform real-time data entry for customers. Employees
in the reporting group run historical reports.
Employees in the order entry group report of poor performance when the reporting group
runs reports.
You need to limit the amount of CPU and RAM used by the reporting group.
What should you do?

You administer a database for an online ordering system.
You plan to create a disaster recovery plan that uses transaction log backups by using only
Microsoft SQL Server native tools.
You need to ensure that the transaction log backup schedule meets the following
requirements: -Log backups occur every 15 minutes between 09:00 hours and 17:00 hours. –
Log backups occur every hour between 17:00 hours and 09:00 hours.
What should you do?

You administer a Microsoft SQL Server 2008 R2 instance.
The database has been marked as suspect.
You need to place the database into an EMERGENCY state for troubleshooting.

What should you do?

You administer a Microsoft SQL Server 2008 R2 instance.
A disk drive that contains the files for the database is lost. The drive has been replaced, but
the data files have been irrevocably lost.
You need to restore the database.
What should you do?

You administer a Microsoft SQL Server 2008 R2 instance.
You need to ensure that no suspect pages have been detected in your database.
What should you do?