Microsoft
70-448 · Question #277
70-448 Question #277: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #277. The question stem and answer options stay visible for context.
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
Unlock 70-448 to see the answer
You've previewed enough free 70-448 questions. Unlock 70-448 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.