Câu 46: 70-463: MCSA Implementing a Data Warehouse with Microsoft SQL Server 20122014

You are performance tuning a SQL Server Integration Services (SSIS) package to load sales data from a source system into a data warehouse that is hosted onWindows Azure SQL Database. The package contains a data flow task that has 10 source-to-destination execution trees. Only five of the source-to-destination execution trees are running in parallel. You need to ensure that all the execution trees run in parallel. What should you do?

1. A. Set the EngineThreads property of the data flow task to 10. — đáp án hiện tại
2. B. Set the MaxConcurrentExcecutables property of the package to 10.
3. C. Create 10 data flow tasks that contain one source-to-destination execution tree each.
4. D. Place the data flow task in a For Loop container that is configured to execute 10 times.