Microsoft
70-448 · Question #83
You are creating a SQL Server 2008 Integration Services (SSIS) data flow which increases information from a source search to a result table for Company.com. In order to increase those rows which…
The correct answer is B. You should utilize the Lookup transformation. D. You should utilize the Merge Join transformation. See the full explanation below for the reasoning.
Question
You are creating a SQL Server 2008 Integration Services (SSIS) data flow which increases information from a source search to a result table for Company.com. In order to increase those rows which could not include the destination table, which is the correct answer? (Select more than one)
Options
- AYou should utilize the Data Conversion Transformation.
- BYou should utilize the Lookup transformation.
- CYou should utilize the Character Map Transformation.
- DYou should utilize the Merge Join transformation.
- EYou should utilize the Data Mining Query Transformation
- FYou should utilize the Term Extraction Transformation
How the community answered
(27 responses)- B85% (23)
- C4% (1)
- E4% (1)
- F7% (2)
Community Discussion
No community discussion yet for this question.