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?
0
0
Based on this one you might be correct:
https://msdn.microsoft.com/en-us/library/ms141031.aspx
Adjust the Sizing of Buffers
0
0
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
0
0
Nice. Thanks
0
0
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
1
0
Greg is 100% correct.
Additionally, there is no MaxConcurrent option available but MaxConcurrentExecutables. And even assuming that it was referring to this option, this only makes sense if there would be more than one data flow in the package (which is not true). And if there would be more than one data flow task, through this option you could only define the max number of data flow tasks that could run in parallel.
0
0