Which of the following is the best practice related to SSIS ? Options: A . &nbspPlan for capacity by understanding resource utilization. B . &nbspSSIS is an in-memory pipeline, so ensure that all transformations occur in memory C . &nbspBaseline source system extract speed D . &nbspAll of the mentioned

Which of the following is the best practice related to SSIS ?

Question

Which of the following is the best practice related to SSIS ?

Options:

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

Answer: Option A

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.

Was this answer helpful ?

Next Question