SSIS Software Trivia Quiz
10 Questions
| Total Attempts: 169
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 _____ - ProProfs]( "SSIS is a platform for _____")
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? - ProProfs]( "In what year was SSIS first released?")
In what year was SSIS first released?- A.
2010
- B.
2002
- C.
2005
- D.
2003
- 3.
![SSIS was introduced to replace _____ - ProProfs]( "SSIS was introduced to replace _____")
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? - ProProfs]( "Which of these is a visual development tool used to create or maintain SSIS packages?")
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 _____ - ProProfs]( "SSIS can be used on all SQL server editions except _____")
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? - ProProfs]( "Who is the main developer of SSIS?")
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? - ProProfs]( "Which of the following is not a tool in SSIS?")
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? - ProProfs]( "What does the ETL in ETL tool stand for?")
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 _____ - ProProfs]( "The upgrade wizard for SSIS is called _____")
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 _____ - ProProfs]( "The package content on the SQL server is persisted in _____")
The package content on the SQL server is persisted in _____- A.
XML
- B.
XNL
- C.
XOL
- D.
XPL
A server query language is designed so that users can retrieve specific information from a database. As a software developer, you should have some knowledge of the use of such languages. Do you believe you understand SQL...
Questions: 42 | Attempts: 9018 | Last updated: Mar 19, 2021
-
Sample QuestionWhich SQL function is used to count the number of rows in a SQL query?
This is a quiz on the SQL system. needed for learning at school
Questions: 10 | Attempts: 3515 | Last updated: Mar 2, 2019
-
Sample QuestionWhen did SQL appear
Questions: 26 | Attempts: 2578 | Last updated: Jan 24, 2013
-
Sample QuestionWhich SELECT statement should you use if you want to display unique combinations of the POSITION and MANAGER values from the EMPLOYEE table?
What Dog Breed Does Your Personality Match With Quiz
What Dog Breed Does Your Personality Match With Quiz
Hunter x Hunter Nen Test: What is Your Nen Personality?
Hunter x Hunter Nen Test: What is Your Nen Personality?
Back to top