• Description: Microsoft SQL Server 2005 - Implementation
• Passing Score: 0%
• Practice Test - Number of questions: 98 questions
• Simulation Test - Number of questions: 98 questions
• Simulation Test Duration: 120 minutes
• Has explanations: Yes

You work as the database administrator at IT department .com. The IT department .com network consists of a single Active Directory domain named IT department .com. You need to import data from several comma-delimited lists into a SQL Server 2005 database server named IT department -DB02. You need to use a SQL Server Integration Services (SSIS) package to accomplish this task. To this end you are designing the Data Flow elements that will define the importing of data from comma-delimited lists. You need to make a choice regarding the Data Flow elements that should be used in the Destination - Data Flow step. What should you do?

Answer(s)

1. Use the Raw File Data Flow element.
2. Use the DataReader Data Flow element.
3. Use the Bulk Insert Data Flow element.
4. Use the Flat File Data Flow element.
5. Use the SQL Server Data Flow element.

Use the SQL Server Data Flow element.