Microsoft TS:MS SQL Server 2008,Implementation and Maintenance Sample Questions:

1. You maintain a SQL Server 2008 instance.
You plan to deploy an instance of SQL Server Reporting Services (SSRS) to the same machine.
You need to ensure that by default. SSRS maintains version histories of all deployed reports.
What should you do?

A) Install the SSRS instance by using the Internet Information Services default Web site.
B) Install the SSRS instance by using the http.sys listener.
C) Configure the SSRS database to use Native mode.
D) Configure the SSRS database to use SharePoint integrated mode.

2. You maintain a SQL Server 2008 instance that contains a database named Finance. The most recent full backup was taken at 13:00 horns, a differential backup was taken at
15:00 hours, and database snapshots were created at 16:00 horns and at 17:00 hours. The backups and the database snapshots are stored on a different disk from the database files. The hard disk that contains the database files fails at 17:02 hours.
You need to restore the Finance database by ensuring minimal data loss.
What should you do?

A) Restore the full backup and the differential backup.
B) Restore the database snapshot from 17:00 hours.
C) Restore the database snapshot from 16:00 hours.
D) Restore the full backup.

3. 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?

A) Configure a Data Collector Set and then restart the SQL Server instance.
B) Enable file system auditing.
C) Enable the Windows Event Collector service.
D) Configure trace flags and then restart the SQL Server instance.

4. You maintain a SQL Server 2008 instance.
You find a SQL Server Agent job is failing. When you review the job history information, you notice that the job history information is incomplete and appears to be truncated. You need to ensure that all information produced by a job is available for viewing. What should you do?

A) Enable write OEM file.
B) Enable notifications to the Windows application event log when the job completes.
C) Enable all job steps to send the output to a file.
D) Include execution trace messages in the SQL Agent Error log.

5. You are a database administrator for your company. The company uses a SQL Server 2008 database that includes a table named Inventory.
The table contains a column named Price. A company policy states that the value in the Price column cannot be decreased by more than 10 percent in any single database operation.
Updates to the Price column are made by various means, including by using ad hoc queries. You need to ensure that this company policy is enforced. What should you do?

A) You should develop a trigger which rolls back changes to the Price column which breaks company policy.
B) You should develop a view which rolls back changes to the Price column which breaks company policy.
C) You should develop a stored procedure which allows changes to the Price column which breaks company policy.
D) On the Price column, you should develop a primary key constraint to a table which includes valid prices.

Solutions: