Multiple choice technology databases

Uses of SSIS

  1. to move data from one data source to another

  2. powerful ETL tool

  3. To design various kind of reports

  4. to provide business information to a wider audience within an organization
Reveal answer Fill a bubble to check yourself
A,B,D Correct answer
Explanation

SQL Server Integration Services (SSIS) is primarily designed as an ETL (Extract, Transform, Load) tool used to move and transform data between various data sources. Designing and presenting reports to a wider audience is the primary function of SQL Server Reporting Services (SSRS), not SSIS.

Keep practicing — related questions