首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a new multiprocessor SQL Server 2000 computer. You are migrating data from other database managemen
You are the administrator of a new multiprocessor SQL Server 2000 computer. You are migrating data from other database managemen
admin
2009-05-19
37
问题
You are the administrator of a new multiprocessor SQL Server 2000 computer. You are migrating data from other database management systems to this server. You need to load data from two data files into a new table on the server. The table is empty and has no indexes.
You want to complete the data load as quickly as possible. What should you do? (Each correct answer represents part of the solution. Choose all that apply.)
选项
A、Apply a bulk update lock to the table.
B、Use separate client connections to load the files into the table simultaneously.
C、Create a clustered index on the table.
D、Specify the Full Recovery model for the database.
E、Specify the Bulk-Logged Recovery model for the database.
答案
A,B,E
解析
Explanation:
A: Bulk update locks are taken when bulk copying data into a table and either the TABLOCK hint is specified, or the table lock on bulk load table option is set using sp_tableoption. Bulk update locks allow processes to bulk copy data concurrently into the same table while preventing other processes that are not bulk copying data from accessing the table. In this scenario the bulk update lock would meet the requirement that data should be loaded as quickly as possible.
B: SQL Server 2000 allows data to be bulk copied into a single table from multiple clients in parallel using the bcp utility or BULK INSERT statement. This can improve the performance of data load operations. To bulk copy data into an instance of SQL Server in parallel, the database must be set to Bulk-Logged Recovery, the TABLOCK hint must be specified, and the table must not have any indexes.
E: By specifying the Bulk-Logged Recovery model, the logging for all SELECT INTO, CREATE INDEX, and bulk loading data operations will be minimal and will therefore require less log space while also improving performance.
Incorrect Answers:
C: When data is bulk copied into a single table from multiple clients in parallel using the bcp utility or BULK INSERT statement to improve the performance of data load operations, the database must be set to Bulk-Logged Recovery, the TABLOCK hint must be specified, and the table must not have any indexes.
D: When data is bulk copied into a single table from multiple clients in parallel using the bcp utility or BULK INSERT statement to improve the performance of data load operations, the database must be set to Bulk-Logged Recovery, the TABLOCK hint must be specified, and the table must not have any indexes.
转载请注明原文地址:https://kaotiyun.com/show/YuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
InParagraphs1and2,thetextshowsPTK’s______.Skepticalobserversbelievethatancestrytestingfailsto______.
InToday’smanagement-theoryindustry,reputation—oratleastthecorporatekind—isa"strategicasset"thatcanbe"leveraged"
随机试题
不寐多梦,甚则彻夜不眠,急躁易怒,伴头晕头胀,头痛欲裂,目赤耳鸣,便秘溲赤,舌红苔黄,脉弦而数。治疗宜选
肝移植是治疗终末期肝病的唯一治疗手段,移植的术前、术中和术后均需要大量输注血液制品,以提高肝脏移植的效果。下列哪个不是肝脏移植输血后的并发症
(2011年、2010年)按在给水系统中的作用,给水泵站一般分为送水泵站、加压泵站、循环泵站和()。
限额以上的批发企业是指()。
美国心理学家吉尔福特提出了智力形态理论,主张可以将人的智力解释为两种不同的形态:流体智力和晶体智力。()
资料1农业是立国之本。强国之基。2015年2月1日,指导2015年全国“三农”工作的中央一号文件全文发布。这份文件题为《关于加大改革创新力度加快农业现代化建设的若干意见》,全文约12000字,共分5个部分32条。文件要求在经济发展新常态下,继续强
甲乙签订合同,约定甲向乙出售家具。在履行合同过程中的下列何种情况下。甲可以将家具提存?()
A.良性肿瘤B.恶性肿瘤C.非肿瘤性良性病变D.癌前病变类癌是
有的人“聪明早慧”,而有的人则“大器晚成”,这说明人的身心发展具有
ModesofTransportation Thereareavarietyofmeansfortransportation.Usually,thechoiceoftransportationdependsonthe
最新回复
(
0
)