You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 to administrate and maintain its database.
You have received instruction from management to create a repository of function information.

This repository should be created with the following characteristics:
* The data collector is utilized to collect function information.
* One database reserves function information for all the instances.
* 15 Day old function information must be removed.
* Administrative effort to query and operate function data should be minimal.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. The newly appointed Domain.com trainee wants to know what can be used to
check if the database integrity check (DBCC CHECKDB) was implemented for a special database.

What should you reply?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. The other day you have received
instructions to update a SQL Server 6.0 database to the SQL Server instance. You need to ensure
that suspect pages in CK_Prod be detected early.

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_Prod1.
One of Domain.com policies is that the database should not be changed too often on business days.
Thus you have received instructions from management to
create a read-only copy of CK_Prod1 for reporting purposes at the start of each business day.

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_Prod.

The CK_Prod contains the following file groups:
* The PRIMARY file group that contains the On-Line Transaction Processing (OLTP) information that is kept in the reserved in the E: volume.
* A file group named CK_USERS that contains the older information that is kept in the F: volume.
* A transaction log of the information that is kept in the I: volume.

Data transferring occurs from the PRIMARY file group to CK_USERS, as a member of the archiving strategy for CK_Prod.
The backup of CK_Prod is as follows:
* The PRIMARY file group six times a day.
* The CK_USERS at 20:00
* The transaction log every 20 minutes

However, the volume that contains CK_USERS was lost at 14:00 hours. You have received
instructions to perform a recovery of CK_USERS with minimal data loss and in the shortest time as possible.

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_Prod. CK_Prod database does execute the logged operations.
You have received instructions to ensure that the database can be recovered to a specific point in time.

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_Prod. The Domain.com’s SQL Server 2008
is configured to make use of the -T1222 and -T1204 trace flags while booting up. You have
received instructions to make sure that the use of these trace flags are also included in the
recovery method of the backups.

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 two SQL Server 2008 computers named CERTKILLER-DB1 and CERTKILLER-DB2.
Both of these computers contain a copy of a database named CK_DB.
You are using transactional replication between CERTKILLER-DB1 and CERTKILLER-DB2 for CK_DB.
The backups of the databases are as follows:
* Full backup is performed night by night.
* Transaction log backups are performed hourly.

Furthermore, replication latency is less than two minutes. One morning CK_DB becomes corrupt
on CERTKILLER-DB1 and its state were not repairable. However, the database on CERTKILLER-DB2 was not affected.
You need to return CK_DB on CERTKILLER-DB1 and ensure that minimal amount of data loss impact on these servers.

What should you do?