You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems
table. The table has the following definition:

Data is grouped into quarterly partitions.
You need to configure the groupings into 12 monthly partitions.
What should you do?

You administer a Microsoft SQL Server 2008 R2 instance. The instance has a database
named CustomerOrders.
The database is backed up by using the weekly scheduled SQL Server Agent jobs. The
backup schedule is shown in the following table:

A drive fails and the CustomerOrders database goes into suspect mode on Sunday at 09:00
hours.
You need to restore the backup.
What should you do?

You administer a Microsoft SQL Server 2008 R2 instance. The instance has a database
named CustomerOrders.
The database is backed up by using the weekly scheduled SQL Server Agent jobs. The
backup schedule is shown in the following table:

A drive fails and the CustomerOrders database goes into suspect mode on Tuesday at
09:00 hours.
You need to restore the backup.
What should you do?

You administer a Microsoft SQL Server 2008 R2 instance. The instance has a database
named CustomerOrders.
The database is backed up by using the weekly scheduled SQL Server Agent jobs. The
backup schedule is shown in the following table:

A drive fails and the CustomerOrders database goes into suspect mode on Tuesday at
09:00 hours.
You need to restore the backup.
What should you do?

You administer a Microsoft SQL Server 2008 R2 instance. The instance has a database
named CustomerOrders.
The database is backed up by using the weekly scheduled SQL Server Agent jobs. The
backup schedule is shown in the following table:

A drive fails and the CustomerOrders database goes into suspect mode on Monday at 09:00
hours.

You need to restore the backup.
What should you do?

You administer a Microsoft SQL Server 2008 R2 instance.
You need to configure mirroring between two servers in high-performance mode.
What should you do?

DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance.
Occasionally, the following problems occur:
-The SQL Server service fails to start. -A query from the application runs slower than
expected.

You need to be able to diagnose each of these problems.
Which tool or tools should you use? (To answer, drag the appropriate problem to the correct
tool in the answer area. Each problem may be used once, more than once, or not at all.
Each tool may be used once or not at all. Additionally, you may need to drag the split bar
between panes or scroll to view content.)

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 create an XML document detailing the deadlock condition.
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 Microsoft SQL Server 2008 R2 database instance.
You need to identify queries or stored procedures that are consuming server resources.
You also need to view the query plan that is being used by each of these queries or
procedures.
Which Dynamic Management Views (DMVs) should you use to find details about specific
queries? (Choose all that apply.)

DRAG DROP
You install a Microsoft SQL Server 2008 R2 instance that uses default settings.
You want to add a storage area network (SAN) array. The SAN has two mapped drives: D
and L.
You need to ensure that all new databases meet the following requirements:
-Data files are stored on drive D in the SQLData folder. -Log Files are stored on drive L in
the SQLLogs folder.
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.)