Questions

Q1. When SSIS packages are saved to DTSX files, what format is used to store the SSIS

Package definitions?

A. SQL files

B. Text files

C. Bat files

D. XML files

Q2. What are the three essential elements of every SSIS package has?

Q3. If you want to extract data from delimited text files. What connection manager type would you choose in the Data Flow task?

A. Excel connection manager

B. Flat File connection manager

C. OLE DB connection manager

D. ADO.NET connection manager

Q4. You need to extract data from a table in a SQL Server database. What connection manager type can you use?

A. Excel connection manager

B. Flat File connection manager

C. OLE DB connection manager

D. File connection manager

Q4. What are the three types of precedence constraint used in SSIS Packages?

Q5.There are three types of data flow task components in the SSIS Toolbox, name those components?

Q6. Define the Data Flow Source Adapters inside a Data flow task?

Q7. Name five SSIS Data Flow Source Adapters?

Q8. Define the Data Flow Destination Adapters inside a Data flow task?

Q9. Name five SSIS Data Flow Destination Adapters?

Q10. Which data flow source adapters can you use if you would like to read data from SQL Server?

A. Flat File Source

B. OLD DB Source

C. Row File Source

D. XML Source

Answers

Q1. Correct Answer : D (XML files)

Q2. Correct Answers

Connection managers

Control flow

Data flow

Q3.Correct Answer : B (Flat File connection manager)

Q3.Correct Answer : C (OLE DB connection manager)

Q4. Correct Answers

Success constraint

Failure constraint

Completion constraint

Q5. Correct Answers

Data flow sources

Data flow transformations

Data flow destinations

Q6.Correct Answer

Data flow source adapters are used to extract data from various different sources and make it available to other components inside a data flow.

Q7. Correct answer

DataReader  Source

Excel Source

Flat File Source

OLD DB Source

Row File Source

XML Source

ADO.NET source

ODBC source

CDC source

Q8.Correct Answer

Data Flow Destination Adapters are the endpoints in a data flow task, defining the location to which the data should be pushed.

Q9. Correct Answers

ADO.NET destination

DataReader destination

Excel destination

Flat File destination

ODBC destination

OLE DB destination

Raw File destination

Recordset destination

SQL Server Compact destination

Data Mining Model Training

Dimension Processing

SQL Server destination

Q10. Correct Answer : B (OLD DB Source)