You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a stored procedure which is used as the data source for a report.
However, a Domain.com user named Mia Hamm complains that the data returned by the report
does not comply with normal safety standards. During the investigation you notice that the results
are caused by phantom reads. You need to make sure that the report result does not connect to
the other users at Domain.com.

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 database uses a full recovery model.
To adapt to business requirements, Domain.com now need to make use of a
process which changes 20,000 records from the Accounts table at 22:00 hours, which is published, daily.
You have received instruction to ensure that any changes to the records could be effected without the database going offline.

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_Prod that contains has a backup method which is as follows:
* CK_Prod is backed up to a file called CK_Prod.bak is performed at 08:00 hours each day.
* Transaction log backed up to a file called CK_Prod _HHMM.trn is executed every 20 minutes starting at 09:30 hours.

Furthermore, CK_Prod is configured in single-user mode. One morning at 09:40, a Domain.com
user named Mia Hamm stated that some information was removed by a search which was executed at 09:20.
You have received instructions to ensure that you recovery the database to its original status.

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. The database at Domain.com contains transaction
information which is for the Web-based order system.

The full recovery model is used on the database. Domain.com is awaiting a few orders that will
come through between 20:00 and 04:00. However, there could be a one hour risk when the
system is running the Database backup.
You need to run the backup as soon as possible and get a solution that will negate this type of risk.

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 need to be backed up completely.
The transaction log for CK_Prod runs from 08:00 to 17:00, in two hour intervals.
The database snapshot needs to be done daily at 07:00.

A Domain.com user named Mia Hamm has removed all the information on CK_Prod which was
entered into the CurrentSpeaker table the previous day. Deletion is the first step for the database.
However, later in the day many other changes in CK_Prod have been effected.
You received instructions to run a full backup on CK_Prod despite all these problems.

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. Domain.com has a SQL Server login
named CK_Tst that maps to a Domain.com learner administrator named CK_ProdApp in CK_Prod.
You have received instruction from management that the Domain.com user can to do the following:
* That the entire stored procedures which at present exist in CK_Prod can be run.
* That the entire stored procedures will be developed in CK_Prod can be run.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. The a SQL Server 2008 instance is used on a Windows Server 2000 server and
uses the mixed authentication mode. Management wants you to ensure the following:
* SQL Server 2008 authenticated logins has the same password complexity rules which are enforced by Windows Server 2000.
* Full compliance of all users with regarding to adhering to the password complexity rules.

What should you do? (Choose TWO)

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 that has a table named CK_Tbl that
keeps data about the entire catalogue of products. The users at Domain.com search CK_Tbl
which is based on the TestPro column. The TestPro column owns the NULL value for the entire
catalogue except products such as Televisions. However, there is no index on the TestPro column
presently. You have received instructions from management to ensure that queries are performed
more efficiently while minimizing the effect your solution will have on the disk space.

What should you do?