首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
74
问题
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
微软认证
相关试题推荐
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
Thenewaircraftrepresentsa$250mbetbyBombardierthatMexicocouldprovidenotjustroutinelabourbutmanufacturingthat
Youliveinaroomincollegewhichyousharewithanotherstudent.Youfinditverydifficulttoworktherebecauseyourroomma
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
Supposeyouaregoingtoresignfromyourcompanyforpersonalreasons.Writealetterofresignationtoyourmanagerto1)
Themethodsoftestingaperson’sknowledgeandabilityremainasprimitiveasevertheywere.Afteralltheseyears,education
UsingFacebookmakespeoplesadder,atleastaccordingtosomeresearch.Burjustwhatisitaboutthesocialnetworkthattakes
Superiorcustomerservicecanbeanessentialsourceofstrengthascompaniesemergefromtherecession,butmanagersneedtoun
如果WindowsXP能够识别网络适配器如何安装网络适配器。
随机试题
孙明与周大风自小就是好朋友。孙明为人老实,性格内向;周大风很是机灵,颇有经济头脑。改革开放以来,各大、中、小城市都致力于规划建设,改善市容。周大风看到建材市场前景很好,就约孙明一起做建材生意。由于两人齐心合力,勤奋吃苦,加之机会好,开始几趟生意都很不错,赚
单卵双胎发生原因:
颈椎斜位(前斜位)摄影,中心线应
基金管理人的董事、监事可以担任基金托管人或者其他基金管理人的任何职务。()
国际上用来综合考察居民间收入分配差异状况的一个重要分析指标是()。
电信条例规定,电信业务经营者因工程施工、网络建设等原因,造成电信服务中断的,在及时告知用户后,应当()。
给定资料1.国家秘密是国家安全和利益的信息表现形式,是国家的重要战略资源,也是国家财产的一种特殊形态.与广大公民的切身利益密切相关。党政机关是国家秘密生成的重要源头和运转枢纽,机关工作人员是国家秘密信息及载体制作、使用和处理的主要承担者。随着我国
设f(x)在[0,1]上连续,在(0,1)内可导,f(0)=0,=1,f(1)=0.证明:存在η∈,使得f(η)=η;
A.taughtB.violentC.vigorousD.tacklingE.contactF.meetingG.fixedH.onI.heldJ.tocomeK.spreadL.manyM.throug
Whetherit’scurledupinthefetalposition,flatonthestomachorstretchedoutacrossthebed,thewaypeoplesleep【C1】_____
最新回复
(
0
)