Questions

Q1. Which transformation type can be used to Combines one or more similar inputs ?

Q2. Name five SSIS Connection Manager Types ?

Q3.Which transformation can you use if you would like to filters data based on a Boolean expression?

Q4. If you need to extract data from MS Access Database. What connection manager type would you choose?

Q5. Which Workflow Task allows send email messages from SSIS packages ?

Q6. SSIS supports three types of containers, name those containers ?

Q7. Which data flow source adapters can you use if you would like to read data from XML File?

Q8. Which transformation can you use if you would like to convert data from one data type to another?

Q9. If you need to extract data from remote file store via the File Transfer Protocol (FTP). What connection manager type would you choose?

Q10. Which data flow source adapters can you use to read data from Excel File?

Answers

Q1. Correct Answer : Union All

Q2. Correct Answers :

ADO connection manager

ADO.NET connection manager

Analysis Services connection manager

Excel connection manager

File connection manager

Flat File connection manager

FTP connection manager

HTTP connection manager

ODBC connection manager

OLE DB connection manager

MSMQ connection manager

SMO connection manager

SMTP connection manager

SQL Server Compact Edition connection manager

WMI connection manager

Q3. Correct Answer : Conditional Split

Q4. Correct Answers :

ODBC connection manager

OLE DB connection manager

ADO.NET connection manager

Q5. Correct Answer : Send Mail task

Q6. Correct Answers :

For Loop container

Foreach Loop container

Sequence container

Q7. Correct Answer : XML  source

Q8. Correct Answer : Data Conversion

Q9. Correct Answer : FTP connection manager

Q10. Correct Answer : Excel source