Google News
logo
SQL Server - Quiz(MCQ)
Which of the following is the best practice related to SSIS?
A)
Baseline source system extract speed
B)
SSIS is an in-memory pipeline, so ensure that all transformations occur in memory
C)
Plan for capacity by understanding resource utilization
D)
All of the above

Correct Answer :   Plan for capacity by understanding resource utilization


Explanation : SQL Server Integration Services is designed to process large amounts of data row by row in memory with high speed. Because of this, it is important to understand resource utilization, i.e., the CPU, memory, I/O, and network utilization of your packages.

Advertisement