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. Add a Script task to the OnPostExecute event handler of the Foreach Loop container.
• B. 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 ))
• 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. Set the RaiseChangedEvent property of the User::FileName variable to True.

You develop a SQL Server 2008 Integration Services (SSIS) package. The package downloads several
files from a remote FTP server by using multiple FTP tasks, and then processes data by using multiple
Execute SQL tasks.
You need to configure the package to restart at the point of failure after the package downloads the files.
What should you do?

• A. Configure the Execute SQL tasks to support transactions.
• B. Configure the package to use a checkpoint.
• C. Configure the FTP tasks to support transactions.
• D. Move all the FTP tasks to a sequence container.

You develop a SQL Server 2008 Reporting Services (SSRS) report.
A Multidimensional Expressions (MDX) query used in the report contains a parameter to display sales data
for various product categories. You write the following query.
SELECT NON EMPTY {[Measures].[Reseller Sales-Order Quantity] } ON COLUMNS,
NON EMPTY
{([Date].[Calendar Year].[Calendar Year].ALLMEMBERS *
[Product].[Category].[Category].ALLMEMBERS ) }
ON CHAPTERS
FROM
(SELECT (STRTOSET(@ProductCategory,CONSTRAINED))
ON COLUMNS FROM [Adventure Works Cube])
You discover that the query generates an error when executed.
You need to ensure that the query executes successfully.
What should you do?

• A. Rewrite the query to display the Order Quantity on the COLUMNS axis, the Calendar Year on the ROWS axis, and the Category data on the PAGES axis.
• B. Replace the CHAPTERS axis with the SECTIONS axis.
• C. Replace the CHAPTERS axis with the ROWS axis.
• D. Remove the NON EMPTY clauses.

You are developing a SQL Server 2008 Integration Services (SSIS) package.
The package performs the following tasks:
Processes multiple files by using a ForEach Loop container.
Imports the contents of the files to a table by using a Data Flow task.
Logs the results of the status into a table by using an Execute SQL task.
You need to ensure that all the tasks of the package except the Execute SQL task execute within a single
transaction.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. In the package, configure the TransactionOption property to Required.
• B. In the Execute SQL task, configure the TransactionOption property to Supported.
• C. In the package, configure the TransactionOption property to NotSupported.
• D. In the Execute SQL task, configure the TransactionOption property to NotSupported.
• E. In the Data Flow task, configure the TransactionOption property to Required.
• F. In the Foreach Loop container, configure the TransactionOption property to NotSupported.

You maintain a SQL Server 2008 Analysis Services (SSAS) database that contains a dimension named
Customer.
You need to configure the Dimension Data settings to meet the following requirements:
Deny access to the {[Customer].[Country].&[Germany],[Customer].[Country].&[France]} set of attribute
members.
New members added to the attribute are visible by default.
What should you do?

• A. Add the following set to the Denied Set property. {[Customer].[Country].&[Germany] ,[Customer].[Country].&[France]}
• B. Add all the country members except those of France and Germany to the Allowed Set property.
• C. Add the following set to the Allowed Set property. Extract({[Customer].[Country].&[Germany] ,[Customer].[Country].&[France]} ,[Customer].[Country])
• D. Add the following set to the Denied Set property. Except([Customer].[Country].[Country] ,{[Customer].[Country].&[Germany] ,[Customer].[Country].&[France]})