皮皮学，免费搜题
登录
搜题
【单选题】
You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Integration Services （SSIS） package to perform an extract， transform， and load （ETL） process to load data to a DimCustomer dimension table that contains 1 million rows. Your data flow uses the following components： A SQL Destination data flow task to insert new customers An OLE DB Command transform that updates existing customers On average， 25 percent of existing customer records is updated each night. You need to reduce the amount of time required to update customer records. What should you do？（）A.
Modify the UPDATE statement in the OLE DB Command transform to use the PAGLOCK table hint.
B.
Modify the UPDATE statement in the OLE DB Command transform to use the TABLOCK table hint.
C.
Stage the data in the data flow. Replace the OLE DB Command transform in the data flow with an Execute SQL task in the control flow.
D.
Stage the data in the data flow. Replace the UPDATE statement in the OLE DB Command transform with a DELETE statement followed by an INSERT statement.
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
皮皮学刷刷变学霸
举一反三
【简答题】The enclosures of the l7th and l8th centuries meant that__________．
【单选题】What is a heater used for in modern times?
A.
To cook food.
B.
To generate electricity.
C.
To frighten animals.
D.
To keep warm.
【简答题】心阳不足者,法宜( )
【单选题】The clear[l]and dark[l]are the______of the phoneme /l/.
A.
phones
B.
allophones
C.
phonemes
D.
morphemes
【单选题】下列有关合作医疗的叙述，错误的是
A.
合作医疗是农民主要的医疗保障形式
B.
合作医疗是建立在集体经济的基础之上的
C.
合作医疗是一种共担疾病风险的制度
D.
合作医疗从根本上解决了农民“因病致贫”与“因病返贫”的问题
相关题目：