首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
60
问题
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
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
Inanyrealmoflife-whetheracademic,social,business,orpolitical-theonlywaytosucceedistotalkeapractical,rathe
Itneverrainsbutitpours.Justasbossesandboardshadfinallysortedouttheirworstaccountingandcompliancetroubles,an
CigarettesmokingisahealthhazardofsufficientimportanceintheUnitedStatestowarrantappropriateremedialaction.Itwa
Thisweekandnext,governments,internationalagenciesandnongovernmentalorganizationsaregatheringinMexicoCityattheWo
Thisweekandnext,governments,internationalagenciesandnongovernmentalorganizationsaregatheringinMexicoCityattheWo
Writeanessayof160~200wordsbasedonthefollowingdrawing.Inyouressay,youshould1)describethedrawingbriefly,
Whateverhappenedtothedeathofnewspaper?Ayearagotheendseemednear.Therecessionthreatenedtoremovetheadvertising
Bobisanewsecurityadministratoratafinancialinstitution.Theorganizationhasexperiencedsomesuspiciousactivityonone
随机试题
PASSAGEONE(1)Ifyouwanttoseewhatittakestosetupanentirelynewfinancialcenter(andwhatisbestavoided),he
Wemadeaphonecalltohimyesterdayaswe______anyletterfromhimforalongtime.
肩周炎的病变包括
牙髓变性有哪些表现,除了
危险源辨识、评价的方法不包括( )。
电算化系统软件工作方式选择的依据是()。
基金信息披露方面要求披露的信息应当以客观事实为基础体现了()。
某商品流通企业的物流部门只为本企业提供服务。随着物流业振兴规划的出台,企业的决策层对市场上现有的物流企业进行了调查分析,对本企业的资金运作、物流部门的员工及其技能、物流设备及其运转能力等内部条件进行了认真的分析研究,决定成立一个独立经营、自负盈亏的MK物流
根据我国票据法律制度的规定,下列各顼中,可以挂失止付的票据是()。
你一到那儿请务必给我写信。
最新回复
(
0
)