Microsoft
70-463 · Question #224
70-463 Question #224: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #224. The question stem and answer options stay visible for context.
Question
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 on Windows Azure SQL Database. The package contains a data flow task that has seven source-to-destination execution trees. Only three 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?
Options
- ASet the EngineThreads property of the data flow task to 7.
- BSet the MaxConcurrentExcecutables property of the package to 7.
- CCreate seven data flow tasks that contain one source-to-destination execution tree each.
- DPlace the data flow task in a For Loop container that is configured to execute seven times.
Unlock 70-463 to see the answer
You've previewed enough free 70-463 questions. Unlock 70-463 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.