MCQOPTIONS
Saved Bookmarks
| 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. The SSIS data flow will transfer data to a SQL Server 2008 database named CKProducts. You want to ensure that the data flow refreshes the existing data in CKProducts with the data in the data flow. What should you do? |
| A. | You should use the OLE DB Destination. |
| B. | You should use the SQL Server Destination. |
| C. | You should use a Data Conversion Transformation. |
| D. | You should use the Fuzzy Grouping Transformation. |
| Answer» C. You should use a Data Conversion Transformation. | |