首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
38
问题
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
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
随机试题
Internet所提供的服务基本上可以分为三类:________、交流信息和分布式处理。
Literaturemustconsistofwords,()musicmustconsistofsounds.
预防甲状腺肿的碘化食盐,常用剂量为每10~20kg食盐中均匀地加入碘化钾或碘化钠
临床药理学这一概念是在何时提出的
建设用地规划管理的任务不包括()。
高级语言编写的程序不能被计算机直接识别和运行。()
下列关于证券交易所对交易异常情况的处理的说法中,正确的有()。Ⅰ.按照交易资金一定比例收取罚款Ⅱ.口头或书面警示Ⅲ.报请中国证监会冻结相关证券账户或资金账户Ⅳ.限制相关证券账户交易
发展经济和保护环境,关系到人类的前途和命运,成为全球普遍关注、亟待解决的重大问题。西方工业社会_________了二战以来经济和社会迅猛发展的人间喜剧,_________了科技革命给人类带来的空前无限的风光,但也亲身体验了环境破坏所带来的生态危机的切肤之痛
Iftheprofitsinoneyeararenotsufficienttopaythedividend,the______willbepaidfromtheprofitsoflateryear.
如果学校的财务部门没有人上班,我们的支票就不能人账;我们的支票不能人账,因此,学校的财务部门没有人上班。请在下列各项中选出与上句推理结构最为相似的一句。
最新回复
(
0
)