首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. You have two new hard disks on which you will create a database named i
You are the administrator of a SQL Server 2000 computer. You have two new hard disks on which you will create a database named i
admin
2009-05-19
22
问题
You are the administrator of a SQL Server 2000 computer. You have two new hard disks on which you will create a database named inventory. You want to insert, update, and delete data as quickly as possible.
Which two actions should you take? (Each correct answer presents parts of the solution. Choose two)
A. Configure the hard disks as two mirrored NTFS volumes.
B. Configure the hard disks as one mirrored NTFS volumes.
C. Configure the hard disks as two independent NTFS volumes.
D. Configure the hard disks as one extended NTFS volume.
E. Place inventory_data.mdf on the first volume and inventory_log.ldf on the second volume.
F. Place inventory_data.mdf on the first volume and inventory_data2.ndf and inventory_log.ldf on the second volume.
G. Place inventory_data.mdf and inventory_log.ldf on the same volume.
选项
答案
C,E
解析
Explanation: Placing log files and the data files on different physical disks or independent volumes, 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 and thus less seek time.
Note: A Windows 2000 supports basic disks, in which physical disks are divided into partitions, and dynamic disks, in which disks are divided into volumes that can comprise an entire disk, two or more entire disks, portions of a disk, or portions of up to 32 physical disks.
A NTFS volume is volume that is formatted with the NTFS file system. 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.
Incorrect Answers:
A: For redundancy and fault protection the log file can be placed on a mirrored volume. It would not be a good idea to put data files on a mirrored volume though. Performance when accessing the data would suffer.
Note: A mirrored volume is a fault-tolerant volume that duplicates data on two physical disks. It provides data redundancy as it copies the data on one volume to another volume on a different disk. When one of the physical disks fails, the data on the failed disk becomes unavailable, but the system can continue to operate by using the mirror disk. In such a set up, the data file and the log file will reside on the same drive. This will not improve database performance.
B: A mirrored volume cannot comprise of one volume only. It must comprise of two volumes on separate physical disks as a mirrored volume is a fault-tolerant volume that duplicates data on two physical disks. When one of the physical disks fails, the data on the failed disk becomes unavailable, but the system can continue to operate by using the mirror disk.
D: Data is written and read sequentially on extended volumes. As a result the data file and the log file will be placed on the same physical disk.
F: In this scenario the data file is separated into a primary data file, that uses the .mdf extension, and a secondary data file, that uses the .ndf extension. However, the secondary data file is placed on the same volume as the log file. This will lead to performance improvements only in cases where data is not read from the secondary data file.
G: Placing the data file and the log file on the same volume will not improve database performance as it will not allow parallel processing.
转载请注明原文地址:https://kaotiyun.com/show/auhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Rao’s,thelegendaryeastHarlemItalianeatery,ismorethanahundredblocksaboveWallStreet.Butwithaclientelethatincl
Youaresupposedtowritealettertoyouruniversitycanteen,suggestinghowtoimproveitsservice.Youshouldwriteneatly
WriteanessaywiththetitleofOnOfficeWorkers’Sub-health.Inyouressay,youshould;1.describethepresenthealthcondit
Youarethepresidentofacompany.WriteamemotoSallyCooper,theHRmanagerontheemployeestrainingoncomputerto,1
Supposeyouwanttoapplyforajobinacompanyasanofficesecretary.Writeanapplicationemailto1)introduceyourself
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
Superiorcustomerservicecanbeanessentialsourceofstrengthascompaniesemergefromtherecession,butmanagersneedtoun
Insectsaredisappearing.Theworldhas25percentfewerterrestrialinsectsnowthanin1990.Thisincludesthosewerelyon
随机试题
某健康30岁未孕妇女,其子宫峡部长度约为
()是指行政机关为了执行法律或地方性法规以及上级行政机关发布的规范性文件所作出的具体规定。
产氢产乙酸菌把除乙酸、甲酸、甲醇以外的()产生的中间产物,如丙酸、丁酸等脂肪酸和醇类等转化成乙酸和氢,并有CO2产生。
根据我国现行规定,按()划分的基本建设项目,属于生产性工程项目中的能源、交通、原材料部门的工程项目,投资额达到5000万元以上为大、中型项目。
按照现行消费税制度规定,下列说法正确的是( )。
在一般情况下,即将到期的公司债券,应在资产负债表中()。
出众对于()相当于()对于刚愎自用
可以导致诉讼时效中断的情形有()。
Weusebothwordsandgesturestoexpressourfeelings,buttheproblemisthatthesewordsandgesturescanbeunderstoodindi
最新回复
(
0
)