首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
13
问题
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
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
InParagraphs1and2,thetextshowsPTK’s______.Skepticalobserversbelievethatancestrytestingfailsto______.
InToday’smanagement-theoryindustry,reputation—oratleastthecorporatekind—isa"strategicasset"thatcanbe"leveraged"
随机试题
“有神”之脉象主要是指:
从国际贸易支付工具的角度讲,票据主要包括( )。
期转现使买卖双方在确定期货平仓价格的同时,也确定了相应的现货买卖价格。()
某银行业从业人员在向客户销售理财产品时,故意混淆预期收益率与保证收益率的概念,并口头保证该产品肯定能够达到预期收益率。此行为违反了从业人员职业操守中的()。
生态学谬论:根据整体的分析结果去推断个体,认为个体具有整体的特征与属性。根据这个定义,下列不属于生态学谬论的是()。
一、注意事项 1.本试卷由给定资料与作答要求两部分构成。考试时限为150分钟。其中,阅读给定资料参考时限为40分钟,作答参考时限为110分钟。 2.一律用现代汉语在答题卡上作答。未按要求作答的,不得分。 3.请在答题卡上作答,严禁折叠答题卡!
光纤通信中使用的复用方式是(56)。E1载波把32个信道按(57)方式复用在一条2.048Mbit/s的高速信道上,每条话音信道的数据速率是(58)。
使用VC6打开考生文件夹下的源程序文件modi3.cpp,其中定义了用于表示雇员的Employee类,但类Employee的定义并不完整。请按要求完成下列操作,将类CEmployee的定义补充完成。(1)定义私有数据成员name、street、c
Lookatthelistbelow.Itshowsarangeofbusinessbooksavailablefromaninternetbookseller.Forquestions6-10ontheop
AFlattoLetAcomfortableflatwith3bedrooms,onedining-room,oneliving-roomandonebathroom,istolet.Theflatisloca
最新回复
(
0
)