You company network includes a SQL Server 2008 R2 database server with the SQL Server 2008 Analysis Services (SSAS) role enabled.
You design a cube named Materials with a measure group named MaterialsInventory. This group has a measure, QualityOnHand, which shows the total stock in inventory for the company by the time.
You need to determine the inventory at the end of the quarter. What should you do?

• A. Define the QuantityOnHand measure as a semi-additive measure.
• B. Define the MaterialsInventory group as an additive measure group.
• C. Define the MaterialsInventory group as a semi-additive measure group.
• D. Define the QuantityOnHand measure as an additive measure.

You maintain a SQL Server 2008 Analysis Services (SSAS) database.
When you process the Analysis Services database, you discover that a Duplicate Key error occurs.
You need to modify the ErrorConfiguration property so that the error condition is reported and processing
continues.
Which object should you modify?

• A. The dimension
• B. The cube
• C. The partition
• D. The measure group

You are working as reporting administrator for a product development company. The company uses SQL
Server 2008 Reporting Services (SSRS) deployed in a native mode.
You need to deploy multiple reports via InstallShield.
Which three components are you required to use? (Each correct answer presents part of the solution.
Choose three.)

• A. ReportService2005.asmx
• B. RS.exe
• C. Report Builder
• D. .RSS File
• E. Rsconfig utility

You administer a SQL Server 2008 Analysis Services (SSAS) database. A sales manager is responsible for the sales of bikes in the Northeast region. You plan to grant the necessary permissions to the sales manager to access the database. You have two roles named Northeast Region and Bikes. The schemas of the two roles are as shown in the following tablE.Role Allowed set
Northeast Region
{[Sales Territory].[Sales Territory Region].&[Northeast]}
Bikes
{[Product].[Product Category].[Product Category].&[Bikes]}
The Visual Totals property is set to True for both roles.
You need to ensure that the sales manager can view only the members in the Product dimension that relate
to the Bikes category in the Northeast region.
What should you do?

• A. Add the manager to a new role that has the following two components: {[Sales Territory].[Sales Territory Region].&[Northeast]} as the allowed set. {[Product].[Product Category].[Product Category].&[Bikes]} as the allowed set.
• B. Add the manager to a new role that has the following two components: {[Sales Territory].[Sales Territory Region].AllMembers} as the denied set {[Sales Territory].[Sales Territory Region].&[Northeast]} as the allowed set. {[Product].[Product Category].[Product Category].AllMembers} as the denied set. {[Product].[Product Category].[Product Category].&[Bikes]} as the allowed set.
• C. Add the manager to the Bikes role.
• D. Add the manager to the Northeast Region role.

You modify a SQL Server 2008 Integration Services (SSIS) packagE.The package extracts data from a
text file and loads this data to a SQL Server 2008 table as shown in the following two exhibits.
You need to update the package to extract data from multiple text files of the same directory.
Which three actions should you perform? (Each correct answer presents part of the solution. Choose
three.)

• A. Add a For Loop container to the package.
• B. Add a variable to the package.
• C. Add an expression to the Flat File connection manager.
• D. Add a Foreach Loop container to the package.
• E. Add a variable to the data flow task.
• F. Add an expression to the Flat File Source component.