SQL Repository
  • Home
  • Articles
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • Code Snippets
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • Interview Questions
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • How To
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • Contact





SSIS Interview Questions – Part 1

On 03 May, 2015
SSIS
By : Charith Silva
No Comments
Views : 2570

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)

 

 

 

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on Google+ (Opens in new window)

Related



Previous Post Next Post 

About The Author

Charith Silva

Charith Silva is a Microsoft certified SQL Server developer and database administrator who was graduated at Buckinghamshire New university in the UK. His career was started in 1998, primarily into Web application development, and later diversified into database development. He has got a vast experience in SQL Server database development, Database administration and Business Intelligence development. He believes that sharing the knowledge is key to the success.


Number of Posts : 87
All Posts by : Charith Silva

Leave a Comment

Click here to cancel reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">





  • Popular
  • Recent
  • Database stuck in “Restoring” state

    17739 views
  • Find the modified date of SQL Server Agents Jobs

    8530 views
  • Script to Check TempDB Speed

    4693 views
  • PING all the Linked Servers and get a status report

    4364 views
  • Log shipping Alerts failing to send emails

    4229 views
  • Moving the tempdb database

    27 Jan, 2016
  • Script to Check TempDB Speed

    14 Jan, 2016
  • SQL Server buffer pool

    05 Nov, 2015
  • Log shipping Alerts failing to send emails

    04 Nov, 2015
  • View queries waiting for memory grant

    21 Oct, 2015

Useful links

  • Books Online for SQL Server 2012
  • Developer Reference for SQL Server 2014
  • Download SQL Server
  • Installation for SQL Server 2012
  • Microsoft Virtual Academy
  • SQL Server Online Training
  • Transact-SQL Reference
  • Tutorials for SQL Server 2012

Tags

.CSV 70-461 AdventureWorks 2012 ALL ANY CAST Chinook Database Code Snippet CONVERT CTE dataset datasource Dates DATETIME divide by zero Duplicates Exam EXCEPT expressions FORMAT IF Import Indexes INTERSECT Jobs NULLIF REBUILD Recursive CTE REORGANIZE ROW_NUMBER() Schedules Sequence SOME sp_stop_job SQL Server 2012 SQL Server Agent SSIS SSRS T-SQL Tally Table T_SQL UAC Permissions Error UNION UNION ALL

Recent Comments

  • Rudnei Silva on Log shipping Alerts failing to send emails
  • johnson Welch on Database stuck in “Restoring” state
  • Neil on Database stuck in “Restoring” state
  • Mark Gribler on MS SQL Database Administrator Interview Questions – Part 4

Google Analytics Stats

Latest Tweets:

  • 6 years ago Attended @SQLSatMcr yesterday - it was amazing! Roll on @sqlsatcambs! Won some Beats Headphones courtesy of @SQLDBApros - thanks guys! :)
  • 6 years ago Looking forward to attending @SQLSatMcr - its too far off though!!!
  • 6 years ago Simple Post: WhoIsActive SPROC: http://t.co/LZvQUaeapK
  • 6 years ago POST: Index REBUILD or Index REORGANIZE: http://t.co/h3L0N37vw4
  • 6 years ago How to Ping all Linked Servers: http://t.co/Q2QxusrKjO
  • 6 years ago For beginners - T-SQL Divide by Zero Error: http://t.co/BBhgoH5hK9

© Copyright 2015 SQL Repository. All Rights Reserved by SQL Repository