可学答题网 > 问答 > MCITP(70-450)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You are a professional


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?()

  • ATo finish the task, database and log files should be placed on the same volume.
  • BTo finish the task, the affinity mask option should be configured properly.
  • CTo finish the task, multiple data files should be create for the database. 
  • DTo finish the task, the affinity I/O mask option should be configured properly.
参考答案
参考解析:
分类:MCITP(70-450)题库
相关推荐

1、You are a professional

You are a professional level SQL Sever 2008 Database Administrator in an international corporation&e...

2、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...

3、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...

4、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...

5、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...

6、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...