单选题A customer needs to install a database on a server.  Which of the following statements describes how to modify the RAID configuration for optimal performance？（）A Place both the database and transaction log on two logical drives in one RAID-10 arrayB Pl

题目
单选题
A customer needs to install a database on a server.  Which of the following statements describes how to modify the RAID configuration for optimal performance？（）
A

Place both the database and transaction log on two logical drives in one RAID-10 array

B

Place both the database and transaction log on two logical drives in one RAID-1E array

C

Place the database on a RAID-1E array and place the transaction log on a separate RAID-5 array

D

Place the database on a RAID-5 array and place the transaction log on a separate RAID-1E array

相似考题

1.You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.What should you do?A．Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.B．Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.C．Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.D．Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.

2.A system administrator needs to maintain 1.2TB of storage for a database server. There are six 250GB drives available in the server for storage space. Which of the following RAID configurations would be the BEST choice given that performance and fault tolerance are important factors?（）A. RAID 1 across drive pairs totaling 3 pairsB. RAID 5 across all 6 drivesC. RAID 10 across all 6 drivesD. RAID 0 across all 6 drives

3.You are the administrator of a SQL Server 2000 computer. The server contains a database named Acct. You purge the Acct database of old records and perform. a full backup. The database now uses 4 GB of space. The database files are configured as shown in the Acct Properties exhibit.The server has two hard disks that are configured as shown in the Server Configuration exhibit.The 3 GB transaction log file for the Acct database is stored on drive C. You need to make room for a new database that has a 3 GB data file and a 1 GB transaction log file. You want to optimize database performance on both databases. You also want to minimize administrative overhead.What should you do?A．Shrink the empty data file on drive E. Place the new data file and the new log file on drive E.B．Shrink the empty data file on drive E. Backup and shrink the log file on drive C to 2 GB. Place the new data file on drive E and the new log file on drive C.C．Shrink the data file on drive D to 1 GB, and then shrink the data file on drive E to 2 GB. Place the new data file on drive D and the new log file on drive E.D．Shrink and delete the data file on drive C, and then shrink the database files on drives D and E so that they are both 2 GB. Place the new data file and the new log file on drive C.

4.An administrator needs to maintain 1TB of storage space for a server. A performance critical application will use this storage space for a database. The database will be replicated between multiple servers. Cost and performance are the most important considerations.Which of the following RAID configurations would be the BEST choice for the storage array?（）A. RAID 6 with six 250GB hard drivesB. RAID 5 with five 250GB hard drivesC. RAID 0 with four 250GB hard drivesD. RAID 10 with eight 250GB hard drives

更多“单选题A customer needs to install a database on a server.  Which of the following statements describes how to modify the RAID configuration for optimal performance？（）A Place both the database and transaction log on two logical drives in one RAID-10 arrayB Pl”相关问题

  • 第1题：

    An administrator needs to maintain 1TB of storage space for a server. A performance critical application will use this storage space for a database. The database will be replicated between multiple servers. Cost and performance are the most important considerations. Which of the following RAID configurations would be the BEST choice for the storage array?（）

    • A、RAID 6 with six 250GB hard drives
    • B、RAID 5 with five 250GB hard drives
    • C、RAID 0 with four 250GB hard drives
    • D、RAID 10 with eight 250GB hard drives

    正确答案:C

  • 第2题：

    Which of the following RAID arrays should be used to achieve the MOST performance？（）

    • A、 Four drives with RAID 0
    • B、 Three drives with RAID 5
    • C、 Four drives with RAID 10
    • D、 Two drives with RAID 50

    正确答案:A

  • 第3题：

    A database administrator wants to design a multi-partition database that can take advantage of both intra-partition parallelism and inter-partition parallelism. Which configuration will allow the use of these types of parallelism while using the least number of hardware components (servers, processors)? （）

    • A、one server having at least two processors  
    • B、two servers having one processor and one logical database partition  
    • C、one server having four processors and two logical database partitions  
    • D、two servers each having four processors and two logical database partitions

    正确答案:C

  • 第4题：

    A customer has a need for an xSeries server for an application requiring 12GB memory with the capacity of up to 20GB.  The HDD configuration needs to be as follows：      （1）Two drives RAID-1 for the operating system   （2）Five drives for Data in a RAID-5 configuration with one Hot-Spare       （3）All drives have to be internal.  Which of the following will satisfy the requirements for the application？（）

    • A、x366
    • B、x255
    • C、x346
    • D、x455

    正确答案:B

  • 第5题：

    You have an Exchange Server 2010 organization. You plan to deploy two new Mailbox servers.  Both Mailbox servers will be members of a database availability group （DAG）. You need to recommend a hard-disk configuration for the new servers. Your recommendation must meet the following requirements：.Maximize write performance .Prevent a switchover if a single disk fails Which disk configuration should you recommend？（）

    • A、RAID 0 array
    • B、RAID 1 array
    • C、RAID 5 array
    • D、RAID 10 array

    正确答案:D

  • 第6题：

    A customer needs to install a database on a server.  Which of the following statements describes how to modify the RAID configuration for optimal performance？（）

    • A、Place both the database and transaction log on two logical drives in one RAID-10 array
    • B、Place both the database and transaction log on two logical drives in one RAID-1E array
    • C、Place the database on a RAID-1E array and place the transaction log on a separate RAID-5 array
    • D、Place the database on a RAID-5 array and place the transaction log on a separate RAID-1E array

    正确答案:D

  • 第7题：

    单选题
    A customer has a need for an xSeries server for an application requiring 12GB memory with the capacity of up to 20GB.  The HDD configuration needs to be as follows：      （1）Two drives RAID-1 for the operating system   （2）Five drives for Data in a RAID-5 configuration with one Hot-Spare       （3）All drives have to be internal.  Which of the following will satisfy the requirements for the application？（）
    A

    x366

    B

    x255

    C

    x346

    D

    x455


    正确答案： A
    解析： 暂无解析

  • 第8题：

    多选题
    In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server？ （）
    A

    increase the size of the redo log buffer

    B

    increase the number of redo log groups

    C

    increase the number of log writer processes

    D

    increase the number of ARCn processes

    E

    change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location


    正确答案： B,E
    解析： 暂无解析

  • 第9题：

    单选题
    A system administrator needs to maintain 1.2TB of storage for a database server. There are six250GB drives available in the server for storage space.  Which of the following RAID configurations would be the BEST choice given that performance and fault tolerance are important factors？（）
    A

     RAID 1 across drive pairs totaling 3 pairs

    B

     RAID 5 across all 6 drives

    C

     RAID 10 across all 6 drives

    D

     RAID 0 across all 6 drives


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    A system administrator needs to maintain 1.2TB of storage for a database server. There are six 250GB drives available in the server for storage space. Which of the following RAID configurations would be the BEST choice given that performance and fault tolerance are important factors?（）
    A

    RAID 1 across drive pairs totaling 3 pairs

    B

    RAID 5 across all 6 drives

    C

    RAID 10 across all 6 drives

    D

    RAID 0 across all 6 drives


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    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
    解析： 暂无解析

  • 第12题：

    单选题
    An administrator is configuring RAID 1 in a server.  The administrator has been given two matching 80GB SATA-2 hard drives， two SATA-2 cables， and a SATA-2 RAID adapter.  How should the administrator BEST configure these drives？（）
    A

    Install one drive on the first channel and install the second drive on the second channel.

    B

    Install one drive on the first cable， on the first channel. Install the second drive on the secondcable， on the second channel.

    C

    Install both drives on the same channel. Cable both drives as the primary master on the samecable.

    D

    Install both drives on the same channel. On the same cable one drive should be set as primaryslave and the other drive as the primary master.


    正确答案： A
    解析： 暂无解析

  • 第13题：

    A system administrator needs to maintain 1.2TB of storage for a database server. There are six 250GB drives available in the server for storage space. Which of the following RAID configurations would be the BEST choice given that performance and fault tolerance are important factors?（）

    • A、RAID 1 across drive pairs totaling 3 pairs
    • B、RAID 5 across all 6 drives
    • C、RAID 10 across all 6 drives
    • D、RAID 0 across all 6 drives

    正确答案:B

  • 第14题：

    An administrator is configuring RAID 1 in a server.  The administrator has been given two matching 80GB SATA-2 hard drives， two SATA-2 cables， and a SATA-2 RAID adapter.  How should the administrator BEST configure these drives？（）

    • A、Install one drive on the first channel and install the second drive on the second channel.
    • B、Install one drive on the first cable， on the first channel. Install the second drive on the secondcable， on the second channel.
    • C、Install both drives on the same channel. Cable both drives as the primary master on the samecable.
    • D、Install both drives on the same channel. On the same cable one drive should be set as primaryslave and the other drive as the primary master.

    正确答案:B

  • 第15题：

    A customer needs maximum performance with fault-tolerance from their disk subsystem. Which RAID level meets this requirement？（）

    • A、RAID-0
    • B、RAID-1
    • C、RAID-5
    • D、RAID-10

    正确答案:D

  • 第16题：

    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.

    正确答案:B

  • 第17题：

    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

    正确答案:D

  • 第18题：

    A customer has determined they want to install an IBM x445 system in their company.  They will be running a large database on the system.  In order to determine how many CPUs will be needed to attain the optimum cost-effective solution， which TWO of the following questions should be asked？（）

    • A、How large is the database？
    • B、What is the expected user workload？
    • C、How is the database software licensed？
    • D、What type of user interface will be used？
    • E、How much data cache will the database be allocated？

    正确答案:A,B

  • 第19题：

    单选题
    A customer needs to install a database on a server.  Which of the following statements describes how to modify the RAID configuration for optimal performance？（）
    A

    Place both the database and transaction log on two logical drives in one RAID-10 array

    B

    Place both the database and transaction log on two logical drives in one RAID-1E array

    C

    Place the database on a RAID-1E array and place the transaction log on a separate RAID-5 array

    D

    Place the database on a RAID-5 array and place the transaction log on a separate RAID-1E array


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    A database administrator wants to design a multi-partition database that can take advantage of both intra-partition parallelism and inter-partition parallelism. Which configuration will allow the use of these types of parallelism while using the least number of hardware components (servers, processors)? （）
    A

    one server having at least two processors  

    B

    two servers having one processor and one logical database partition  

    C

    one server having four processors and two logical database partitions  

    D

    two servers each having four processors and two logical database partitions


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    An administrator needs to maintain 1TB of storage space for a server. A performance critical application will use this storage space for a database. The database will be replicated between multiple servers. Cost and performance are the most important considerations. Which of the following RAID configurations would be the BEST choice for the storage array?（）
    A

    RAID 6 with six 250GB hard drives

    B

    RAID 5 with five 250GB hard drives

    C

    RAID 0 with four 250GB hard drives

    D

    RAID 10 with eight 250GB hard drives


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    An administrator needs to maintain 1TB of storage space for a server. A performance critical application will use this storage space for a database. The database will be replicated between multipleservers. Cost and performance are the most important considerations.  Which of the following RAID configurations would be the BEST choice for the storage array？（）
    A

     RAID 6 with six 250GB hard drives

    B

     RAID 5 with five 250GB hard drives

    C

     RAID 0 with four 250GB hard drives

    D

     RAID 10 with eight 250GB hard drives


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    Which of the following RAID arrays should be used to achieve the MOST performance？（）
    A

     Four drives with RAID 0

    B

     Three drives with RAID 5

    C

     Four drives with RAID 10

    D

     Two drives with RAID 50


    正确答案： D
    解析： 暂无解析

相关内容