70-448 · Question #277
You design a SQL Server 2008 Integration Services (SSIS) package. The package extracts data from flat files and loads this data to a SQL Server 2008 database. The package contains two Boolean…
The correct answer is A. Option A. See the full explanation below for the reasoning.
Question
You design a SQL Server 2008 Integration Services (SSIS) package. The package extracts data from flat files and loads this data to a SQL Server 2008 database. The package contains two Boolean variables named @IsWeekday and @IsHoliday. When the package is executed on week days, the @IsWeekday variable is set to True. When the package is executed on holidays, the @IsHoliday variable is set to True. You need to implement the following business logic in the control flow of the package:
- When the ©IsWeekday variable is set to True, the Perform Weekday
Processing Data Flow task is executed.
- When the ©IsWeekday variable is set to False, the Perform Weekend
Processing Data Flow task is executed.
- When the @IsHoliday variable is set to True, the Perform Holiday
Processing Data Flow task is executed. Which control flow logic should you implement?
Exhibits
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(28 responses)- A75% (21)
- B14% (4)
- C7% (2)
- D4% (1)
Community Discussion
No community discussion yet for this question.