Explanation: BIDS is available with SQL Server as an interface which provides the developers to work on the work flow of the process that can be made step by step. 3. 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
Answer:A
Explanation: BIDS is available with SQL Server as an interface which provides the developers to work on the work flow of the process that can be made step by step. 3. 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
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. 4. If SSIS is not able to drive close to 100% CPU load, this may be indicative of: