You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 instance is managed by you. A new database should be deployed, and the capacity requirements listed below should be satisfied. There should be 275 GB for the database data file, while there should be 50 GB for the transaction log file. There are six 100-GB disk drives which are accessible for the database in the storage array. The six disks are attached to a redundant array of independent disks (RAID) controller, and the controller supports RAID levels 0, 1, 5, and 10. Since you are the technical support, you are required to maximize the write performance of the transaction log. In addition, you should protect the database and transaction log files, when a drive fails. The storage system should be designed. From the following four storage configuration, which one should you utilize?（）
A、A single RAID 5 volume should be utilized.

B、A RAID 1 volume and a RAID 5 volume should be utilized.

C、A single RAID 10 volume should be utilized.

D、A RAID 0 volume and a RAID 5 volume should be utilized.

提示：未搜索到的试题可在搜索页快速提交，您可在会员中心"提交的题"快速查看答案。

答案

查看答案

搜题

相关试题

You administer a SQL Server 2008 infrastructure. An instance runs on a computer that has eight quad-core processors and 128-GB RAM. Four different applications use the instance. The instance experiences a low number of CXPACKET waits. The instance also experiences a large number of lazy writer waits. You need to optimize the performance of the instance. What should you do?（）

A、Configure the Resource Governor.

B、Configure the Windows System Resource Manager.

C、Configure software non-uniform memory access (soft-NUMA).

D、Configure an increase in the maximum degree of parallelism option.

查看答案解析

下列哪一项不是多发性骨髓瘤的特点（）。

A、高钙血症

B、高黏滞血症

C、高尿酸血症

D、高白蛋白血症

E、高球蛋白血症

查看答案解析

You administer a SQL Server 2008 instance. You plan to deploy a new database that has the following capacity requirements: 275 GB for the database data file; 50 GB for the transaction log file. The storage array has six 100-GB disk drives available for the database. The disks are attached to a redundant array of independent disks (RAID) controller that supports RAID levels 0, 1, 5, and 10. The write performance of the transaction log needs to be maximized. The database and transaction log files must be protected in the event of a drive failure. You need to design the storage system. Which storage configuration should you use?（）

A、A single RAID 5 volume

B、A single RAID 10 volume

C、A RAID 0 volume and a RAID 5 volume

D、A RAID 1 volume and a RAID 5 volume

查看答案解析

外源性凝血因子缺乏时（）。

A、APTT延长，PT正常

B、APTT正常，PT延长

C、APTT延长，PT延长

D、APTT正常，PT正常

E、APTT正常，TT延长

查看答案解析