首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. The server contains a database named Accounting. The data files are con
You are the administrator of a SQL Server 2000 computer. The server contains a database named Accounting. The data files are con
admin
2009-05-19
76
问题
You are the administrator of a SQL Server 2000 computer. The server contains a database named Accounting. The data files are configured as shown in the exhibit.
The database has grown to 7 GB. The server has no more available disk space. You need to make more disk space available in the accounting database without affecting system performance.
What should you do?
选项
A、Compress drive E.
B、Add a new hard disk to the server. Create a new file on the new hard disk as part of the PRIMARY filegroup.
C、Add a new hard disk to the server. Create a new file on the new hard disk as part of a new filegroup.
D、Map a network drive to the server. Create a new data file on the network drive as part of the PRIMARY filegroup.
E、Map a network drive on the server. Create a new data file on the network drive as part of a new filegroup.
答案
B
解析
Explanation: When a SQL Server 2000 server runs out of disk space, additional hard drives must be added to the server. A file can then be created on the new disk as part of an existing filegroup or as part of a new filegroup. In this scenario a new file should be placed on the new hard disk for best performance. This file can either be placed in the PRIMARY filegroup or a new filegroup could be created. The performance gain would be equal in both cases, but if we use a new filegroup we would have to configure it so that it would be used.
Incorrect Answers:
A: SQL Server data files cannot be installed on a system that uses compression.
C: When a SQL Server 2000 server runs out of disk space, additional hard drives must be added to the server. A file can then be created on the new disk as part of an existing filegroup or as part of a new filegroup. To use the new filegroup we would have to configure it (add data to it or make it the default filegroup). Without configuration the new filegroup will not be used. All data would still be added to the default PRIMARY filegroup.
D: Mapping a network drive to the server will increase the disk space available to the database but query time will be limited to the network environment and network transfer speeds. This will hamper query response time.
E: Mapping a network drive to the server will increase the disk space available to the database but query time will be limited to the network environment and network transfer speeds. This will hamper query response time.
转载请注明原文地址:https://kaotiyun.com/show/ouhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
HeatIsKillerExtremelyhotweatheriscommoninmanypartsoftheworld.Althoughhotweatherjustmakesmostpeoplefeel
Asthemini-blogisbecomingincreasinglypopularamongnetizens,italsobecomescommontocreaterumors.Youaresupposedtow
SupposeyouphonedyourfriendMaryseveraltimesyesterdaybutshedidn’tansweryourcallatall.Writeheranemailto1
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
GivingmillionsofexistingPayPalcustomerstheabilitytobuyattheclickofabuttonhasenormouspotentialforincreasing
随机试题
关于胸部大血管CT扫描所见的描述,错误的是
Apieceofwritinggivinginstructionshasmuchincommonwiththeexplanationofaprocess,【36】itisaddressedtoadifferentr
A.CD4+T细胞、CD8+T细胞、单核巨噬细胞浸润、肾小管坏死B.肾小血管壁纤维增厚,管腔狭窄C.急性坏死性血管炎,Ig和补体沉积伴肾出血、梗死D.肾间质大量中性粒细胞浸润肾超急性排斥反应
免疫细胞产生、分化、成熟的场所是
环刀法测试细粒土密度试验,平行试验差值要求不大于()g/cm3。
下列立法成果中属于地方性法规的有()。
金融资产的分类中,以票据、债券等契约型投资工具为主的金融资产被称为()。
甲公司2017年销售额为600万元,固定经营成本为100万元,盈亏临界点的销售额为200万元,则2018年经营杠杆系数为()。
现代教育与传统教育的根本区别在于是否重视_______的培养。
【2014年北京第24题】下列有关“函”的表述中,错误的是()。
最新回复
(
0
)