2. 计算机
  3. You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. The database will store sal

You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. The database will store sal

admin2009-05-19  19
问题 You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. The database will store sales transactions. Retail locations must be able to add transactions to the database 24 hours a day every day. The server is configured as shown in the exhibit.


You need to configure the data files and transaction log for the Sales database. What should you do?
选项 A、Place the transaction log on physical disk 0 and the data file on the RAID-5 disk array.
B、Place the transaction log on the RAID-5 disk array and the data file on physical disk 0.
C、Place the transaction log and the data file on physical disk 0.
D、Place the transaction log and the data file on the RAID-5 disk array.
答案D
解析 Explanation: Because retail locations must be able to add transactions to the database 24 hours a day every day, we must minimize any possible downtime and ensure that the server has high availability. Using a hardware-based RAID-5 disk array, we would increase availability as RAID-5 provides redundancy of all data on the array, allowing a single disk to fail and be replaced in most cases without system downtime.

Incorrect Answers:
A: By placing the transaction log on physical disk 0 we will not take advantage of the fault tolerance made possible by the RAID-5 disk array. The transaction log is thus not fault tolerant in this solution.

B: By placing the data file on physical disk 0 we will not take advantage of the fault tolerance made possible by the RAID-5 disk array. The data file is thus not fault tolerant in this solution.

C: By placing the transaction log and the data file on physical disk 0 we will not take advantage of the fault tolerance made possible by the RAID-5 disk array. In this solution the database is not fault tolerant and a disk failure would result in unnecessary downtime.
转载请注明原文地址:https://jikaoti.com/ti/WwO7FFFM
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

相关试题推荐
随机试题
最新回复(0)