You work as a database administrator at Domain.com. Domain.com is using a remote SQL
Server 2008 instance. One morning you have received complaints that the applications are
running sluggish. To get hold of the workload, you need to trace the table on the remote SQL
Server instance. You need to use the Database Engine Tuning Advisor and use the SQL Profiler
tool to analyze the workload of the remote SQL Server instance on a local SQL Server instance.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. Domain.com contains a database that is used by a mission critical application.
You have received complaints from a Domain.com user named Mia Hamm that the performance
of the server is not running by her as it should be. You need to use the Database Engine Tuning
Advisor to help the functions of the application however you should ensure that the performance of
the server does not affect the other users.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. Domain.com contains quite a few databases that are utilized by applications. You
are planning to use the Resource Governor to cut the result of searches. These searches are run
via Microsoft SQL Server Management Studio. However, the characteristics should be as follows:
The searches done by the SQL Server Management Studio should not exceed 40 % of CPU
utilization and the applications need of 200 % CPU utilization may be allowed when needed.
You need to comply with the Domain.com needs.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. One morning you have a complaint from a Domain.com user that applications on
the server is performing very sluggish. However, you do not want to use the table scans get more
information because of the poor performance.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. The SQL Server 2008 instance contains a database named CK_DB. You are
planning to collect performance information on the whole examples with the data collector. You
should reserve collected data in CK_DB and to gather and load function data in the management
data warehouse every 12 hours.
What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB1. The Domain.com management would
like the database to conform to the following security requirements:

Only successful and failed logon attempts in log files.
The SQL Server 2008 instance must close if the records are not written to the log files.
You need to set the SQL Server sample to conform to the security requirements.
What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. You have received instruction from management to keep a management data
warehouse. It will be used to store functions data through utilizing the data collector. For this, you
need to use a process which gathers and uploads information in the management information
warehouse on different schedules.

What should you do?

You work as a database administrator at Domain.com. You are working on a SQL Server 2005
database called TestCont and are using a Transact-SQL script to restore TestCont. The Transact-SQL script is as follows:

RESTORE DATABASE TestCont
FROM contracts_bu_device
WITH CONTINUE_AFTER_ERROR, CHECKSUM, RECOVERY

However, after the restore there were still errors in some page restores in the SQL Server logs.
You have received instructions to repair the database pages as soon as possible.
What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance for a Server Agent job. During a routine monitoring, you notice that the Server
Agent job is not running as it should be. However, when you check the job history information, you
saw that it was not complete and shortened. However, in the future, you need to ensure that the
info from the job history is useful for browsing.

What should you do?