多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

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 should be managed by you. The computer on which the instance run has the following three features: a 64-GB RAM, four quad-core processors, and several independent physical raid volumes. A transactional database will be implemented on the instance. In addition, the database should have a high volume of INSERT, UPDATE, and DELETE activities. Creation of new tables is contained by the activities. You need to maximize disk bandwidth and decrease the contention in the storage allocation structures so as to have the performance of the database optimized.    Which action will you perform to finish the task?()

  • A、To finish the task, database and log files should be placed on the same volume.
  • B、To finish the task, the affinity mask option should be configured properly.
  • C、To finish the task, multiple data files should be create for the database. 
  • D、To finish the task, the affinity I/O mask option should be configured properly.
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题