首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. You are configuring a database for an inventory application. The hard d
You are the administrator of a SQL Server 2000 computer. You are configuring a database for an inventory application. The hard d
admin
2009-05-19
73
问题
You are the administrator of a SQL Server 2000 computer. You are configuring a database for an inventory application. The hard disks on your server are configured as shown in the exhibit.
The operating system files are located on drive C. Your database will store a maximum of 6 GB of data and requires a maximum of 2 GB of disk space for the transaction log.
You want to optimize database performance. What should you do?
选项
A、Add a 2-GB transaction log to drive D, a 3-GB data file to drive E, and a 3-GB data file to drive F
B、Add a 1-GB transaction log to drive C, a 1-GB transaction log to drive D, a 3-GB data file to drive E, and a 3-GB data file to drive F
C、Add a 1-GB transaction log to drive E, a 1-GB transaction log to drive F, a 3-GB data file to drive E, and a 3-GB data file to drive F
D、Add a 2-GB transaction log to drive F, a 3-GB data file to drive D, and a 3-GB data file to drive E
答案
D
解析
Explanation: Basically there are two methods to improve performance in this scenario:
Method 1: put the transaction log file on a separate physical disk.
One way to improve performance and recoverability of your database is to place the data files and the transaction log files on separate disk subsystems, and to use dedicated disks for your data files so that data read and write (I/O) requests are not competing with other I/O requests on those disks. This is (A).
Method 2: data files split across two physical disks
Splitting your data files among a number of disks results in increased I/O performance in particular when multiple controllers are used like in this scenario. This is (D).
To decide which is better we must think about the application. This is an inventory system and we can assume that the queries would be more frequent than additions and update of rows. So we should choose method 2 since it gives the best performance for reading data.
Note: Physical database design involves mapping the logical design onto physical media to allow for the data to be physically accessed and maintained as quickly as possible by taking advantage of the available hardware and software features.
It is important to correctly design the database and to take advantage of hardware and software features early in the development cycle of a database application, because making changes to these components at a later stage it is difficult. Placing log files and the data files on different physical disks, and placing the log file of a drive that does not hold the operating system can improve database performance as it allows the frequently written to log file to exist a disk with its own read/write heads.
Incorrect Answers:
A: In an inventory system data is read more frequently and not so many changes are made to the database. We should optimize the data files not the log file.
B: Placing log files and the data files on different physical disks and placing the log file of a drive that does not hold the operating system can improve database performance as it allows the frequently written to log file to exist a disk with its own read/write heads. In this part of the log file is placed on drive C, which would also hold the operating system.
C: Placing log files and the data files on different physical disks can improve database performance as it allows the frequently written to log file to exist a disk with its own read/write heads. In this solution the log file and the data file are placed on the same physical drive.
转载请注明原文地址:https://kaotiyun.com/show/puhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Afterthedotcomboomofthe1990s,theworldisabouttoexperienceaboomindots.Over1,000newgenerictop-leveldomainnam
Afterthedotcomboomofthe1990s,theworldisabouttoexperienceaboomindots.Over1,000newgenerictop-leveldomainnam
Rao’s,thelegendaryeastHarlemItalianeatery,ismorethanahundredblocksaboveWallStreet.Butwithaclientelethatincl
[A]Butworkisunderwaytogetcomputerstocapturehumanlifeandrememberitaspeopledo—recallingbitsofexperiencethata
SupposetheMartialArtAssociationinyouruniversitywantstorecruitnewmembers.Writeanadtoallstudentsto1)infor
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
Theideaisasaudaciousasitaltruistic:provideapersonallaptopcomputertoeveryschoolchild—particularlyinthepoorestp
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
InParagraphs1and2,thetextshowsPTK’s______.Skepticalobserversbelievethatancestrytestingfailsto______.
TheStudents’UnionofyourdepartmentisplanningaChineseSpeakingContest.Writeanannouncementwhichcoversthefollowing
随机试题
国际收支平衡表中除了经常项目、资本和金融项目、储备资产外,还包含()
下列条件中,能提高雏鸡的孵化率,降低“死胎”率的是()
羧甲司坦
根据《水利水电工程标准施工招标文件》,承包人有权根据本合同任何条款及其他有关规定,向发包人索取追加付款,但应在索赔事件发生后的()内,将索赔意向书提交发包人和监理人。
下列说法中,正确的是()。
2018年4月27日,中国人民银行、中国银保监会、中国证监会、国家外汇管理局联合印发了(),这意味着证券行业步入金融强监管时代。
下列关于权利和义务的说法中,错误的有()。
“亚罗马”事件
下列叙述中正确的是
在数据表中用户可以查找需要的数据并替换为新的值,如果要将成绩为80分~99分[含80和99]的分数替换为A-,应在“替换值”项中输入()。
最新回复
(
0
)