You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 server.
Management wanted the backups to be done on a daily basis. Transaction log backups are
performed every afternoon and morning. This worked fine for six months. However, as the content
of the log file grew it resulted in a large transaction log file. The size of the transaction log file is
affecting the performance of the server. You have received instructions to take appropriate
measures when doing the backups of the transaction log files.
What is the preferred action in this scenario?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_DB. ABC_DB have 200 GB information where 3
GB of the information is changed daily. ABC_DB has its recovery model set for Simple. However,
ABC.com states that data loss of more than one hour for transactions during business hours is a
NO – NO.

How can you setup a backup service while also making sure that minimum disk space is used?
Select two.

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. The SQL Server 2008 instance contains a database named ABC_Tester that is used by
the ABC.com’s developers. You need to allow the developers to access the SQL Server Profiler to
get traces which can be used to troubleshoot the application that ABC_Tester uses.
What action can you take to comply with this scenario?

You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2
instance that contains a database named ABC_DB1.
You have configured SQL Server log shipping for ABC_DB1 to occur every hour on the hour. You
then receive instructions to create a scheduled task to run a full backup of ABC_DB1 after
business hours.
Which of the following is TRUE with regards to this scenario?

You work as a SQL Server 2008 database administrator at ABC.com. One morning you have
received numerous complaints from the users at ABC.com that a database application is running
very sluggish. You need to check the disk, CPU, and memory utilization; information and still
consider the network.
What should you do?

You work as a database administrator at ABC.com. ABC.com makes use of a SQL Server 2008
R2 instance.
ABC.com has a database, named ABCSales, which has a primary filegroup that includes the OnLine Transaction Processing (OLTP) data. ABCSales also has another filegroup, named
ABCSalesHistory, which hosts antiquated records for the database. These two filegroups are
located on separate drives, while the transaction log for ABCSales is located on a different drive
altogether.
ABC.com’s business hours are from 8 Am to 5 PM. You have configured an archiving solution that
allows for the constant relocation of information from the primary filegroup to ABCSalesHistory.
You have also configured a backup solution that backs up the primary filegroup every 2 hours,
starting at 9 AM and ending at 5 PM. The backup solution includes a daily backup of the
ABCSalesHistory filegroup at 5 PM, and an hourly backup of the transaction log.
When the drive that hosts the ABCSalesHistory filegroup becomes corrupt during the day, you are
instructed to perform a restore procedure that allows for as little records as possible to be lost. The
speed of the restore procedure should also be as fast as possible.
You start by manually backing up the transaction log.
Which two of the following actions should you take NEXT? (Choose two.)

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a large database named ABC_DB1 that is only updated during working
hours. You have received instructions to create a backup and recovery plan that will ensure that
no data that is older than 1 hour is lost.
How should you configure your backup and recovery plan? (Choose all that apply)

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2005
instance that host a database named Products. You want to monitor query response times on the
Products database.
How would you accomplish this task?

You work as a SQL Server 2008 database administrator at ABC.com. ABC.com is using a SQL
instance that has a stored procedure which is used create a report. One day, a ABC.com user
named Mia Hamm complains that the data returned by the report lacks consistency. During the
investigation you notice that this is the results of phantom reads. You need to make sure that the
report resultsare consistent. Other database users at ABC.com must not be affected by your
solution.
How would you accomplish this task?

You work as a SQL Server 2008 database administrator at ABC.com. ABC.com is using a SQL
instance that contains a database named ABC_Prod. Recently ABC_Prod has frequently become
deadlocked. You have received instructions from management to have the database log
information when it becomes deadlocked.
How would you configure the ABC_Prod database? (Choose TWO)