SSIS Software Trivia Quiz

10 Questions | Total Attempts: 169

SettingsSettingsSettings
Please wait...
SSIS Software Trivia Quiz

SSIS is a component of SQL, a data to import/export wizard, an ETL tool, and lots more. How much do you know about SSIS, its history, and the tool it contains? What developer created SSIS and in what year was it developed? Take this quiz to find out.


Questions and Answers
  • 1. 
    SSIS is a platform for _____
    • A. 

      Data integration

    • B. 

      Workflow integration

    • C. 

      Media integration

    • D. 

      Visual integration

  • 2. 
    In what year was SSIS first released? 
    • A. 

      2010

    • B. 

      2002

    • C. 

      2005

    • D. 

      2003

  • 3. 
    SSIS was introduced to replace _____
    • A. 

      Visual Studio Essentials

    • B. 

      Warehouse transformation services

    • C. 

      Data transformation services

    • D. 

      Extraction studio services

  • 4. 
    Which of these is a visual development tool used to create or maintain SSIS packages?
    • A. 

      SIDS

    • B. 

      BIDS

    • C. 

      LIDS

    • D. 

      MIDS

  • 5. 
    SSIS can be used on all SQL server editions except _____
    • A. 

      Express

    • B. 

      2014

    • C. 

      2008R2

    • D. 

      2016

  • 6. 
    Who is the main developer of SSIS?
    • A. 

      Linux

    • B. 

      Apple

    • C. 

      Google

    • D. 

      Microsoft

  • 7. 
    Which of the following is not a tool in SSIS?
    • A. 

      DTEXEC

    • B. 

      DTUTIL

    • C. 

      DLE DB Command

    • D. 

      SETDU

  • 8. 
    What does the ETL in ETL tool stand for?
    • A. 

      Extract, Task and Location

    • B. 

      Extract Transfer and Lode

    • C. 

      Extract, Transform and Load

    • D. 

      Export, Transform and Load

  • 9. 
    The upgrade wizard for SSIS is called _____
    • A. 

      SSISUW

    • B. 

      SSISDD

    • C. 

      SSISDB

    • D. 

      SSISWD

  • 10. 
    The package content on the SQL server is persisted in _____
    • A. 

      XML

    • B. 

      XNL

    • C. 

      XOL

    • D. 

      XPL

Related Topics
Back to Top Back to top