You work as a database administrator at ABC.com.ABC.com is making use of a SQL Server 2008

R2 instance.
You have previously configured a SQL Server 2008 R2 cluster. You then disconnect the network
cable(s) from the active node, as well as delete the shared array from the active node.
Which of the following describes a reason for doing this?

You work as a database administrator at ABC.com.ABC.com is making use of a SQL Server 2008
R2 instance.
You monitor the transaction log of the instance on a daily basis. On this particular day you are
presented with information regarding torn page errors in the database.
You have been instructed to rectify these errors as soon as possible.
Which of the following actions should you take? (Choose two.)

You work as a database administrator at ABC.com. ABC.com has recently upgraded to SQL
Server 2008 R2.

You have been instructed to have an existing SQL Server 6.0 database, named ABCSales,
upgraded to an instance of SQL Server 2008 R2. You have to make sure that any questionable
pages in ABCSales can be identified at an early stage.
Which of the following actions should you take?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2
instance that contains a database named ABCSales.
Minimal changes to the information in ABCSales take place on a daily basis. You have been
instructed to devise a solution that fully logs all transactions and keeps the transaction log records
until after they are backed up. The solution should also allow for ABCSales to be restored to the
point of failure.
Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com is making use of a SQL Server 2008
R2 instance that contains a database named ABC_Prod1.
You have been instructed to devise a strategy that produces a read-only duplication of

ABC_Prod1 at the start of each business day. This duplication will be used as a reporting tool.
Your strategy should also have a minimal effect on ABC_Prod1.
Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com is making use SQL Server 2008 R2
in their environment.
ABC.com has a server, named ABC-SR07, which runs an instance of SQL Server 2008 R2 and
has multiple applications installed.
You have configured the SQL Server Agent service to make use of the ABC-SR07/ACCOUNT.
You then configured a job that must be written to a database server. You now need to make sure
that only the SQL Server Agent service has read and write permissions to the database server.
Which of the following actions should you take?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2

instance that contains a database named ABCSales.
Minimal changes to the information in ABCSales take place on a daily basis. You have been
instructed to devise a solution that minimizes administrative overhead for the transaction log of
ABCSales.
Which of the following actions should you take?

You work as a database administrator at ABC.com. ABC.com makes use of a SQL Server 2008
R2 instance.
You have been instructed to make sure that all stored procedures that are defined by ABC.com’s
users make use of the prefix usp_. You are also instructed to make sure that administrators are
prevented from creating stored procedures that do not make use of the prefix usp_.
Which of the following actions should you take? (Choose all that apply.)

You work as a database administrator at ABC.com. You are responsible for managing a SQL
Server 2008 R2 instance.

ABC.com has an Internet Information Services (IIS) application that should be able to log on to the
SQL Server Analysis Services (SSAS) instance anonymously.
Which of the following actions should you take?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2
instance that includes a database named ABCSales.
Minimal changes to the information in ABCSales take place on a daily basis. You have been
instructed to devise a solution that produces for a read-only copy of the database. Furthermore,
the solution has to run every morning and should consume as little disk resources as possible.
Which of the following actions should you take?