SSIS Software Trivia Quiz
10 Questions
| Total Attempts: 203
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
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: 10871 | Last updated: Mar 22, 2022
-
Sample QuestionWhich SQL function is used to count the number of rows in a SQL query?
Are you learning the Oracle software? Do you want to test your knowledge about Oracle? Try this interesting and well-researched Oracle mock test 2 (SQL + Arch). With this test, you'll get the chance to test your understanding...
Questions: 23 | Attempts: 5683 | Last updated: May 10, 2022
-
Sample QuestionWhich SELECT statement should you use if you want to display unique combinations of thePOSITION and MANAGER values from the EMPLOYEE table?
This is a quiz on the SQL system. needed for learning at school
Questions: 10 | Attempts: 3695 | Last updated: Mar 21, 2022
-
Sample QuestionWhen did SQL appear
Back to top