QUESTION: 1
You work as a database administrator at ABC.com. You are in the process of preparing the
deployment of a new database that wil have 45 gigabytes storage space for the transaction log
file, and 280 gigabytes storage space for the database data file.
There are approximately six 120 GB disk drives available for the database in the storage array.
ABC.com contains a RAID controller that supports RAID levels 0, 1, 5 and 10. The disks are on
the RAID controller. You have received an instruction from the CIO to make sure that the
transaction log's write performance runs at optimum. The CIO has also instructed you to make
sure that in the event of a drive failure, the database and transaction log files are protected.
To achieve this goal, you decide to configure a storage solution.
Which of the following actions should you take?

A. You should consider using a RAID 1 volume as well as a RAID 5 volume in your storage
configuration.
B. You should consider using a RAID 1 volume as well as a RAID 10 volume in your storage
configuration.
C. You should consider using a RAID 3 volume as well as a RAID 5 volume in your storage
configuration.
D. You should consider using a RAID 1 volume as well as a RAID 3 volume in your storage
configuration.
Answer(s): A
QUESTION: 2
You work as a database administrator at ABC.com. ABC.com has a database server named
ABC- DB04 with a SQL Server 2008 instance that includes an extensive mission-critical
database that is constantly being used ABC-DB04 has a quad-core motherboard with four
CPUs.
When it is reported that ABC-DB04 often encounters CPU pressure, you receive an instruction
from management to make sure that the accessible CPU cycles are not exhausted by online
index rebuilds.
Which of the following actions should you take?

A. You should make use of the affinity I/O mask option.
B. You should make use of the optimize for ad hoc workloads option.
C. You should make use of the affinity mask option.
D. You should make use of the max degree of parallelism option.
Answer(s): D
QUESTION: 3
You work as a database administrator at ABC.com. ABC.com has a database server named
ABC- DB01 with a SQL Server 2008 instance.
During routine monitoring on ABC-DB01, you discover that the amount of CXPACKET waits
experienced by the instance is low, while the amount of lazy writer waits is abundant.
You have been instructed to enhance the operation of the instance to ensure productivity.
Which of the following actions should you take?

A. You should consider setting up the Windows System Monitoring tool to better the
performance.
B. You should consider setting up the Asynchronous database mirroring to better the

2

Free 70-450 Exam Braindumps

Pass your PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 (RETIRED) exam with these free Questions and Answers