Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Microsoft 70-448
Title
: TS:MS SQL Server
2008.Business Intelligence
Dev & Maintenan
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
1.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?
A.
B.
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
C.
D.
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Answer: A
2.You are developing a SQL Server 2008 Integration Services (SSIS) data flow that loads data to a SQL
Server 2008 database.
You need to ensure that the data flow updates the existing records in the SQL Server database by using
data from the rows in your data flow.
Which data flow component should you use?
A.SQL Server Destination
B.OLE DB Destination
C.OLE DB Command Transformation
D.Data Conversion Transformation
Answer: C
3.You design a SQL Server 2008 Integration Services (SSIS) package that contains several data flows.
You need to monitor the data that passes through each path in the data flow by using the Business
Intelligence Development Studio. You also ne