1.

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. The SSIS package must contain a Data Flow task with a Fuzzy Grouping transformation that creates data. You received instructions to debug the SSIS package. To this end you need to browse the output data of the Fuzzy Grouping transformation in order to check on the constraints currently on the Fuzzy Grouping transformation. What should you do?

A. You should consider adding a Data Viewer object to the Data Flow task.
B. You should consider adding a DBCC SHRINKFILE to the Data Flow task.
C. You should consider adding a web service to the Data Flow task.
D. You should consider adding a Transactions log to the Data Flow task.
Answer» B. You should consider adding a DBCC SHRINKFILE to the Data Flow task.


Discussion

No Comment Found