Learn with Microsoft : 70-448 training material for 100% pass

You implement a SQL Server 2008 Integration Services (SSIS) package.
The package contains the following components:
A Foreach Loop container for the Collection property as shown in the following exhibit. (Click the Exhibit
button.)
A Foreach Loop container for the Variable Mappings property as shown in the following exhibit. (Click the
Exhibit button.)
A String variable named FileName.
A String variable named DirectoryPath.
You need to update the package so that the DirectoryPath variable returns the directory path for the file
path stored in the FileName variable.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. Set the Expression property of the User::FileName variable to the following expression. SUBSTRING( @[User::FileName], 1, LEN( @[User::FileName] ) - FINDSTRING( REVERSE( @ [User::FileName] ), "\\", 1 ))
• B. Set the RaiseChangedEvent property of the User::FileName variable to True.
• C. Set the Expression property of the User::DirectoryPath variable to the following expression. SUBSTRING( @[User::FileName], 1, LEN( @[User::FileName] ) - FINDSTRING( REVERSE( @ [User::FileName] ), "\\", 1 ))
• D. Set the EvaluateAsExpression property of the User::DirectoryPath variable to True.
• E. Add a Script task to the OnPostExecute event handler of the Foreach Loop container.

You are working as an ETL developer for a payroll company. You configure a SQL Server 2008 Integration Services (SSIS) package to use checkpoints.
The SSIS package truncates the dbo.Employee_Attendance table, loads the new employees in the dbo.Employee table, and then loads dbo.Employee_Attendance for a particular month.
The control flow for the package is shown in the Control Flow exhibit. (Click the Exhibit button.)
The data flow for the package is shown in the Data Flow exhibit. (Click the Exhibit button.)
The package fails at the Derived Column transformation within the data flow task.
You need to determine where the package execution will begin after you correct the errors and run the package again.
Where does the package execution begin?

• A. Load Emp_Attendance in the Data Flow task.
• B. Load Employee in the Data Flow task.
• C. Derived Column Transformation in the data Flow task
• D. Truncate Employee_ Attendance table in the Execute SQL task

You develop a SQL Server 2008 Reporting Services (SSRS) project.
The report will display data from a SQL Server 2005 Analysis Services databasE.You need to ensure that
the report displays member properties and extended properties.
What should you do?

• A. Use the SQL Server data source.
• B. Use the OLE DB for SQL Server data source.
• C. Use the OLE DB for the Analysis Services 8.0 data source.
• D. Use the SQL Server Analysis Services data source.

You maintain a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to run the Usage-Based Optimization Wizard.
You need to enable query logging.
What should you do?

• A. Set the LogDir server property to a valid path.
• B. Set the QueryLogSampling server property to 10.
• C. Set the AllowedBrowsingFolders server property to include the folder from the LogDir setting.
• D. Set the QueryLogConnectionString server property to a valid connection string.

You create a SQL Server 2008 Analysis Services (SSAS) solution. You have a dimension named Account and a time dimension named Time. You have a fact table that contains a column named CurrentBalance. CurrentBalance contains the current account balance. You need to create a measure named AccountBalance from the CurrentBalance column to display the closing account balance for a time period. What should you do?

• A. Set the AggregationFunction property of AccountBalance to ByAccount.
• B. Set the AggregationFunction property of AccountBalance to Sum.
• C. Set the AggregationFunction property of AccountBalance to FirstNonEmpty.
• D. Set the AggregationFunction property of AccountBalance to LastNonEmpty.