Discussion :: SQL Server MCQs
- Which of the following is the best practice related to SSIS ?
|
A.
Plan for capacity by understanding resource utilization.
|
|
B.
SSIS is an in-memory pipeline, so ensure that all transformations occur in memory
|
|
C.
Baseline source system extract speed
|
|
D.
All of the mentioned
|
Whatsapp
Facebook
Answer : Option A
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.
Be The First To Comment