最新更新 Microsoft TS 70-448

pitiess · 发表于 2011-9-5 11:41:41

科目编号：70-448
认证名称：TS:MS SQL Server 2008.Business Intelligence Dev & Maintenan

1.Youare developing a SQL Server 2008 Integration Services (SSIS) data flow that loads data to a SQLServer 2008
database. You needto ensure that the data flow updates theexisting records in the SQL Server database byusingda
ta from the rows in your data flow. Which data flow component should you use?
A.SQLServer Destination
B.OLE DB Destination
C.OLE DB Command Transformation
D.Data ConversionTransformation

Answer:C

2.Youdesign a SQL Server 2008 IntegrationServices (SSIS) data flow that inserts data from a sourcequery toa desti
nationtable.You need to insert only those rows that do not already exist in the destination tablE.What are twopossibl
eways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
A.Use the Merge transformation.
B.Use theLookup transformation.
C.Use the UnionAll transformation.
D.Use the Merge Join transformation.
E.Use the Fuzzy Lookup transformation.
F.Use the Fuzzy Grouping transformation.

Answer:BD

3.You implement a SQL Server 2008Integration Services (SSIS) package. The package contains the following com
ponents: Adata flow task contained in a For Loop containerA Flat File destination component that uses a Flat File co
nnection managerAn OnError event handler When an error occurs in the package, you plan to write diagnostic infor
mation from an expression that includes the version of the package to atext file. You needto ensure that the require
d information is written to the text file. What should you do?
A.Use the VersionGUID variable.
B.Use the ExecutionGUID variable.
C.Use the SourceID variable.
D.Use the TaskID variable.

Answer:A

有需要的朋友请下载附件：

游客，如果您要查看本帖隐藏内容请回复

pitiess · 发表于 2011-9-5 11:41:49

smil晴空 · 发表于 2011-10-15 16:21:42

感谢分享

zsy0711 · 发表于 2011-10-26 23:22:21

感谢分享

张222222010 · 发表于 2012-9-21 21:03:26

张222222010 · 发表于 2012-9-21 21:02:53

yinheswim · 发表于 2012-4-18 20:31:53

renet · 发表于 2012-5-10 14:14:46

lvfeng · 发表于 2012-5-10 20:26:16

谢谢大哥分享，学习学习

monkeyman · 发表于 2012-7-1 16:41:56

不会还有密码吧?

monkeyman · 发表于 2012-7-1 16:44:21

老大,您放在这里的好东西,快一年不来了,也不知道密码,我晕

thompson-tomcat · 发表于 2012-7-15 10:53:57

感恩

梦想家园 · 发表于 2012-9-20 09:37:52

caidaoyiba · 发表于 2012-9-20 16:17:16

顶！！！！！！！！！！！！！！！！！！！！！！！！！

xxx20100915 · 发表于 2012-10-24 10:02:50

xiexie

账号		自动登录	找回密码
密码			论坛注册

[分享] 最新更新 Microsoft TS 70-448

客服中心

投诉建议