Microsoft
70-458 · Question #97
You are developing a SQL Server Integration Services (SSIS) package to load data into a data warehouse. You need to establish the correct order for loading each table to maximize parallel…
The correct answer is A. 1. DimCurrency, DimScenario, DimAccount in parallel. See the full explanation below for the reasoning.
Question
You are developing a SQL Server Integration Services (SSIS) package to load data into a data warehouse. You need to establish the correct order for loading each table to maximize parallel processing. Which order should you use?
Exhibit
Options
- A
- DimCurrency, DimScenario, DimAccount in parallel
- B
- DimCurrency, DimOrganization in parallel
- C
- DimCurrency, FactFinance in parallel
- D
- FactFinance
- E
- DimCurrency
How the community answered
(43 responses)- A77% (33)
- B2% (1)
- D7% (3)
- E14% (6)
Community Discussion
No community discussion yet for this question.