首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. The server is configured as shown in the Database Server Configuration
You are the administrator of a SQL Server 2000 computer. The server is configured as shown in the Database Server Configuration
admin
2009-05-19
74
问题
You are the administrator of a SQL Server 2000 computer. The server is configured as shown in the Database Server Configuration exhibit.
You need to create a new database named Inventory. Employees in your company will use the Inventory database to track inventory data. Users will require immediate responses to queries that help them locate where parts are stored. The tables in the database will be configured as shown in the Database Schema exhibit.
The database will consume 14 GB of disk space. You must configure the data files and transaction log to accelerate query response time.
Which two courses of action should you take? (Each correct answer represents part of the solution. Choose two.)
A. On drive C, create a transaction log.
On drive D, create a data file in the PRIMARY filegroup.
On drive E, create a data file in the SECONDARY filegroup.
B. On each drive, create a transaction log.
On each drive, create a data file in the PRIMARY filegroup.
C. On drive D, create a transaction log.
On drive E, create a data file in the PRIMARY filegroup.
D. On the PRIMARY filegroup, create all tables and all indexes.
E. On the PRIMARY filegroup, create all tables. On the SECONDARY filegroup, create all indexes.
F. On the PRIMARY filegroup, create the Parts table and its indexes.
On the SECONDARY filegroup, create all other tables and their indexes.
选项
答案
A,E
解析
Explanation:
A: The transaction log should be placed on a separate disk. A transaction log would not benefit of two or more disks since it is sequential. Create two data files on two separate physical disks would improve performance.
E: Separating the tables and the indexes improve performance for in particular joins.
Note: With SQL Server 2000 it is possible to create tables or indexes on specific filegroups. This allows us to control where the database’s tables and indexes are physically located as filegroups can be placed on different hard drives. Placing tables in one filegroup and the table’s nonclustered indexes in another filegroup on different physical disk can improve database performance because it will allow separate threads to access the tables and indexes.
However, a table and its clustered index cannot be separated into different filegroups as the clustered index determines the physical order of the data in the table. Furthermore, the transaction log should be placed on a physically separate disk. The transaction log file is written serially; therefore, using a separate, dedicated disk allows the disk heads to stay in place for the next write operation. This will further improve performance.
Incorrect Answers:
B: To improve performance, the transaction log should not be placed on the same physical disk that the tables or indexes are placed on. The transaction log file is written serially; therefore, placing it on a separate, dedicated disk allows the disk heads to stay in place for the next write operation and thus improves performance.
Furthermore, placing tables in one filegroup and the table’s nonclustered indexes in another filegroup on different physical disk can improve database performance because it will allow separate threads to access the tables and indexes. However, a table and its clustered index cannot be separated into different filegroups as the clustered index determines the physical order of the data in the table.
C: The transaction log should be placed on a physically separate disk. The transaction log file is written serially; therefore, using a separate, dedicated disk allows the disk heads to stay in place for the next write operation. This will further improve performance. In this solution, the tables and their indexes are placed on the same disk. This solution thus does not take advantage of the performance improvements that can be realised through the correct utlization of the available hardware.
D: In this solution, the tables and their indexes are placed on the same disk. This solution thus does not take advantage of the performance improvements that can be realised through the correct utlization of the available hardware.
F: Greater performance gains can be realized by placing tables in one filegroup and the table’s nonclustered indexes in another filegroup on different physical disk. This will allow separate threads to access the tables and indexes.
转载请注明原文地址:https://kaotiyun.com/show/XuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
Writeanessayof160-200wordsbasedonthefollowingdrawing.Inyouressay,youshould1)describethedrawingbriefly,
Writeanessayof160-200wordsbasedonthefollowingdrawings.Inyouressay,youshould1)describethedrawingsbriefly,
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
TheU.S.PostalService(USPS)continuestobleedredink.Itreportedanetlossof$5.6billionforfiscal2016,the10thst
TheU.S.PostalService(USPS)continuestobleedredink.Itreportedanetlossof$5.6billionforfiscal2016,the10thst
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
Faceit,moviefans:theDVDisdestinedtobedeadasadoornail.OnlyafewBlockbusterstoresarestillopen.Netflix’s(o
随机试题
“彼亦一是非,此亦一是非。”这句话中体现的是()。
根据零件定位方法的不同,焊接结构装配的方法可分为哪几种?
某宗房地产1992年至1996年的价格分别为681/m2、713/m2、781/m2和818元/m2,若估计该房地产1999年的趋势价格,则可用()方法进行评估。
在计算粮食产量时,薯类折算粮食的比例为()。
节税与风险并存,节税越多的方案往往也是风险()的方案,两者的权衡取决于多种因素,包括客户对风险的态度这个因素。
编写教科书和教师进行教学工作的直接依据是()。
经教育部同意,2015年6月1日,位于四川省泸州市的泸州医学院更名为四川医科大学。但几天之后,四川大学以公函的形式,向教育部表达了反对意见。认为“四川医科大学”的简称易与华西医科大学(2000年9月已并人四川大学)历史曾用名“四川医学院”的简称“川医”混淆
Onedaythewindsaidtothesun,"Lookatthatmanwalkingalongtheroad.Icangethiscoatoffmorequicklythanyoucan.""
Theaccommodationwascheap,butthefoodwasvery____.
Theblue,mysticLakeElsinoreliesinaninlandCaliforniavalley,whichisteemingandsteamingwithhotsprings.Rimmedbysh
最新回复
(
0
)