You have a SQL server integration Services (SSIS) package named package1.
You discover that the Data Flow task for Package1 runs slower than expected.
You need to reduce the amount of time required to run the Data Flow task.
Which two actions should you perform? (Select Two)
A.
Configure the package to run by using the CallerInfo option.
B.
Modify the DefaultBufferSize package setting.
C.
Modify the ForceExecutionResult Package setting.
D.
Modify the DefaultBufferMaxRows package setting.
E.
Configure the package to run by using MaxConcurrent option.
shouldn`t it be B and D?
Based on this one you might be correct:
https://msdn.microsoft.com/en-us/library/ms141031.aspx
Adjust the Sizing of Buffers
B is not correct. There are no such option.
SSIS applies the size of the buffers based on these input parameters:
■■ Estimated Row Size
■■ DefaultMaxBufferRows
■■ DefaultMaxBufferSize
■■ MinBufferSize
Nice. Thanks
Of course B and D is correct…
“Define the default size of the buffer that the task uses, by setting the DefaultBufferSize property, and define the maximum number of rows in each buffer, by setting the DefaultBufferMaxRows property.”
https://docs.microsoft.com/en-us/sql/integration-services/data-flow/data-flow-performance-features