首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
73
问题
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
微软认证
相关试题推荐
Inthe1930s,anAmericanmeatcompanycameoutwithaspicedhamproductsoldinacan.Beforelong,Spam,asitwascalled,be
Inthe1930s,anAmericanmeatcompanycameoutwithaspicedhamproductsoldinacan.Beforelong,Spam,asitwascalled,be
HeatIsKillerExtremelyhotweatheriscommoninmanypartsoftheworld.Althoughhotweatherjustmakesmostpeoplefeel
Fewthingssay"forgetI’mhere"quitesoeloquentlyastheposeoftheshy—theavertedgaze,thehunchedshoulders,thebodypi
TheBestMediatoUseThereareplentyofoptionsavailableforspreadingnews,suchasnewspapers,radio,TV,theInternet
Youareanactivememberofthestudentnewspaper.Thenewspaperiscurrentlylookingforajournalistforthesummersemester.
TheoutbreakofswinefluthatwasfirstdetectedinMexicowasdeclaredaglobalepidemiconJune11,2009.Itisthefirstwo
通过【网上邻居】查找网上计算机和共享文件资源,IP为“202.204.54.23”,主机名为administrator,共享文件夹名为“tools”。
Guest账户和Administrator账户一样是由系统建立的,不能被禁用。
Exhibit:BULKINSERTEzonexam.dbo.employeesFROM‘tk\africe\fubar512.txt’WITHDATAFILETYPE=‘char’,FIELD/TERMINATOR=‘\t’,R
随机试题
女性茶艺人员在茶艺表演中应该选用何种站姿
物质激励
《麦琪的礼物》的故事结局是()
血证病因病理不包括下列哪项
活塞式压缩机主轴采用()。
2012年4月份,社会消费品零售总额15603亿元,同比名义增长14.1%(扣除价格因素实际增长10.7%,以下除特殊说明外均为名义增长)。其中,限额以上企业(单位)消费品零售额7483亿元,增长14.6%。1-4月份,社会消费品零售总额64922亿元,同
如果城乡男女性别比一致,2009年,全国农村男性人口大约为()万人。
设y=f(x)为区间[0,1]上的非负连续函数.(1)证明:存在c∈(0,1),使得在区间[0,c]上以f(c)为高的矩形面积等于区间[c,1]上以y=f(x)为曲边的曲边梯形的面积;(2)设f(x)在(0,1)内可导,且f’(x)>,
下列图像格式中,可以将多幅图像保存为一个图像文件,从而形成动画的是(29)。不属于视频影像文件的是(30)。
数据流图(DFD)中的有向箭头(→)表示()。
最新回复
(
0
)