2. 计算机
  3. You are the administrator of a SQL server 2000 computer that contains a database named Acct. The database contains 1.5 GB of dat

You are the administrator of a SQL server 2000 computer that contains a database named Acct. The database contains 1.5 GB of dat

admin2009-05-19  18
问题 You are the administrator of a SQL server 2000 computer that contains a database named Acct. The database contains 1.5 GB of data. The server has one 9-GB hard disk that is configured as shown in the Exhibit.


You need to import data into the database without adversely affecting database performance. The data will require an additional 2GB of storage space.
What should you do?
选项 A、Add another data file on drive E, and then add the file to the PRIMARY filegroup.
B、Move the transaction log file to drive E, and set the file growth of Acc_Data.mdf by selecting the Unrestricted file growth option.
C、Rebuild all clustered indexes so that they have a fill factor of 100.
D、Compress drive D.
答案A
解析 Explanation: We must take precautions so that the import process of 2 GB data will run. We add a new file to drive E, which has 3 GB free disk space. By placing the new file in the primary file group we ensure that new data added to the database will be added to new data file. The primary file group is the default file group and new data is automatically added to it.

Incorrect Answers:
B: Moving the transaction log from Drive D to Drive would free up 800MB. This would leave 1.3GB of free disk space on drive D. But the import process will require another 2GB so we will not have enough free disk space.

C: Rebuilding the clustered indexes with a fill factor of 100 makes that the index pages full. This would degrade performance during the import process due to page splits.

D: Compressing a partition which is used by SQL Server is not a good idea. It would, if at all possible, degrade performance.
转载请注明原文地址:https://jikaoti.com/ti/XVO7FFFM
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

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