首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
59
问题
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
微软认证
相关试题推荐
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
"3M"comesfrom"MinnesotaMining&Manufacturing,"butthosethreeMsmightbetterstandforMistake=Magic=Money.Throughoutit
Thisweekandnext,governments,internationalagenciesandnongovernmentalorganizationsaregatheringinMexicoCityattheWo
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
Asthemini-blogisbecomingincreasinglypopularamongnetizens,italsobecomescommontocreaterumors.Youaresupposedtow
YouarepreparingforanEnglishtestandhaveorderedareferencebookfromabookstore.Afteryoureadthebook,youfoundtha
TheoutbreakofswinefluthatwasfirstdetectedinMexicowasdeclaredaglobalepidemiconJune11,2009.Itisthefirstwo
Google,whichdominatesmuchoflifeontheInternet,hasbeentryingtoexpandbeyondcomputersandtelephonestolivingrooms,
在用户管理组administrators中删除lusi用户。
Emilyislisteningtonetworktrafficandcapturingpasswordsastheyaresenttotheauthenticationserver.Sheplanstouseth
随机试题
贫血患者,Hb<60g/L、以往有输全血及血浆引起严重荨麻疹病史、本次输血治疗应选择哪一种红细胞制品?
患者,女性,34岁,左胸外伤后肋骨骨折,极度呼吸困难,发绀、烦躁不安。体检:脉搏细速,血压84/62mmHg,皮肤湿冷,气管右移,颈静脉充盈,头颈部和右胸皮下气肿,左胸廓饱满、肋间隙增宽、呼吸幅度降低,叩诊呈鼓音,右肺呼吸音消失。若该病人行胸腔闭式引流
A.甘露醇B.氢氯噻嗪(双氢克尿噻)C.呋塞米(速尿)D.链霉素E.螺内酯与呋塞米合用可增强耳毒性的药物是
下列不属于供水设施设备的维护管理规定的是()。
督察长由()提名。
某企业2006年1月1日的房产原值为3000万元,4月1日将其中原值为1000万元的临街房出租给某连锁商店,月租金5万元。当地政府规定允许按房产原值减除20%后的余值计税。该企业当年应缴纳房产税( )。
旅游团在各站停留期间,全陪的工作主要有()。
她A像B什么C也D发生似的,又上班了。
ASocioculturalApproachtoReading,LanguageandLiteracyI.WhattakingasocioculturalapproachactuallymeansA.Itrejectst
WhatdidJackdooverthesummer?
最新回复
(
0
)