皮皮学，免费搜题
登录
搜题
【单选题】
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.
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
皮皮学刷刷变学霸
举一反三
【单选题】斯大林曾说过: “伟大的精力只是为了伟大的目的而产生。”高尔基也指出:“一个人追求的目标越高,他的才能就会发展得越快,对社会就越有益。”这说明
A.
理想信念等同于现实
B.
. 理想信念是人生前进发展的精神动力
C.
理想信念是人们的主观意志和想当然
D.
理想信念是人们的一种真诚信服与坚决执行的态度
【单选题】“千锤万凿出深山,烈火焚烧若等闲。粉身碎骨全不怕,要留清白在人间。”这首诗通常被认为是明代政治家于谦的一首托物言志诗。它吟咏的对象是( )
A.
花岗岩
B.
大理石
C.
石灰
D.
煤炭