皮皮学，免费搜题
登录
搜题
【单选题】
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.
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
皮皮学刷刷变学霸
举一反三
【简答题】阅读理解。 Friendship Restaurant We have different kinds of Japanese food here. The food menu is in Japanese and Chinese. All the waiters or waitress can speak at least one foreign language. Tel: 312-9997 ...
【简答题】请将下面给出的句子依据视频的内容写成四个投诉: 1. I have no hot water. 2. The food is cold. 3. The internet is down. 4. You overcharged me for this item. 5. This is unacceptable. 6. This is ridiculous. 7. This is wrong. 8. ...
【单选题】根据合伙企业法律制度的规定，下列关于普通合伙企业合伙人处分财产份额的说法中，正确的是( )。
A.
合伙人之间可以自由转让各自的财产份额，无须经其他合伙人同意，也不需要通知其他合伙人
B.
合伙人不得将其财产份额转让给合伙企业以外的人
C.
合伙人以其在合伙企业中的财产份额出质的，须经其他合伙人一致同意
D.
在任何情况下，合伙人均不得以其财产份额出质
相关题目：