You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) data flow that adds the data from a source query to a result table for Abc.com. You want to add the rows that are included in the destination table. What should you do? (Choose all that apply)

Question

TuteeHUB · Accepted Answer

You should consider using a Data Mining Query Transformation and a Term Extraction Transformation.5)You should consider using a Character Map Transformation and a Data Mining Query Transformation.

TuteeHUB · Answer

You should consider using a Data Conversion Transformation and a Lookup Transformation.

TuteeHUB · Answer

You should consider using a Character Map Transformation and a Term Extraction Transformation.

TuteeHUB · Answer

You should consider using a Merge Join Transformation and a Lookup Transformation.

1.	You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) data flow that adds the data from a source query to a result table for Abc.com. You want to add the rows that are included in the destination table. What should you do? (Choose all that apply)
A.	You should consider using a Data Conversion Transformation and a Lookup Transformation.
B.	You should consider using a Character Map Transformation and a Term Extraction Transformation.
C.	You should consider using a Merge Join Transformation and a Lookup Transformation.
D.	You should consider using a Data Mining Query Transformation and a Term Extraction Transformation.5)You should consider using a Character Map Transformation and a Data Mining Query Transformation.
Answer» D. You should consider using a Data Mining Query Transformation and a Term Extraction Transformation.5)You should consider using a Character Map Transformation and a Data Mining Query Transformation.

Discussion

No Comment Found

Related MCQs

Reply to Comment