You maintain a default SQL Server 2008 instance.
You plan to configure FILESTREAM data to meet the following requirements:
-Enable FILESTREAM for file I/O streaming access. -Allow remote client computers to have
streaming access to FILESTREAM data.
You need to ensure that FILESTREAM data is enabled.
What should you do?

You configure a SQL Server 2008 instance that contains a database named Customers. The
Customers database experiences deadlock problems.
You need to capture the deadlock information to the SQL Server error log.
What should you do?

You plan to install a SQL Server 2008 instance for a new application on an existing server
that contains a default SQL Server 2005 instance.
You need to ensure that both database instances are available for their applications. Your
solution must meet the following requirements:
-Minimize administrative effort. -Prevent changes to the existing application environments.
What should you do?

You administer a SQL Server 2008 instance. The instance contains an On-Line Analytical
Processing (OLAP) database along with a dimension table named Customers. The data of
the Customers table is updated every thirty minutes.

The Customers table contains redundant data.
You need to conserve the disk space used to store the Customers table.
What should you do?

You migrate an application named App1 from Microsoft SQL Server 2000 to SQL Server
2008.
You plan to monitor the SQL Server instance.
You need to capture the use of features that will be discontinued.
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 Friday 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 Saturday at
10: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 Thursday at 17:00 hours.

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

You administer a Microsoft SQL Server 2008 R2 database that contains a schema named
Reporting. The Reporting schema contains store procedures, tables, and views.
Stored procedures and views in the Reporting schema access objects that are not contained
in the schema.
You need to ensure that the DOMAIN\BusinessReporting Active Directory group meets the
following requirements:
-Users are able to access objects in the Reporting schema through existing stored
procedures. -Users are unable to modify tables and views in the database.
What should you grant the DOMAIN\BusinessReporting group?

You are reviewing and configuring the security of a SQL Server 2008 instance that contains
database DB1.
The security audit policy specifies the following requirements:
-Only successful and failed logon attempts are recorded in log files. -The SQL Server
instance is shut down if records cannot be written to the log files.
You need to configure the SQL Server instance to comply with the security audit policy.
What should you do?