You create a SQL Server 2008 R2 Reporting Services (SSRS) solution. The organization requires a drilldown report that color coordinates the values of the student's' test scores. All average scores 70% or higher should have a green background. All lower average scores should have a red background.
You need to enable this functionality.
Which expression should you use?

• A. =iif(avg(Fields!TestScore.Value) >= .70 THEN "Green","Red"
• B. =iif(Fields!TestScore.Value >= .70 THEN "Green" ELSE "Red")
• C. =iif(Fields!TestScore.Value >= .70,Green","Red")
• D. =iif(avg(Fields!TestScore.Value) >= .70,"Green","Red"

You create a SQL Server 2008 Analysis Services (SSAS) solution.
Your solution contains a cube with a dimension named Factories. The dimension has a property names ProductionLines. This solution also includes data about the suers employed at each factory.
You need to provide a way to browse the data within the dimension.
What should you do?

• A. Configure a drillthrough action on the Factories dimension.
• B. Change the DataSourceFolder properties.
• C. Create a URL action on the User feature.
• D. Set "get values from a query" in the Report Parameters dialog.

You are developing a SQL Server 2008 Integration Services (SSIS) project in Business Intelligence
Development Studio.
You configure the project properties as shown in the following image.
You need to create a deployment manifest for all packages in the project.
What should you do?

• A. Modify the AllowConfigurationChanges property of the project.
• B. Copy each package. Rename each copy with a .SSISDeploymentManifest file extension.
• C. Build the Integration Services project.
• D. View the code of each Data Transformation Services (DTS) package. Copy the first <DTS:Property> xml node to a file with a .SSISDeploymentManifest file extension.

You maintain a SQL Server 2008 Analysis Services (SSAS) database. You create a new measure group
in one of the cubes.
You have a program that maintains partitions on the production copy of the cube.
You need to update the cube definition on the production server without overwriting any existing partitions.
What should you do?

• A. Execute an UPDATE CUBE statement in Microsoft SQL Server Management Studio (SSMS).
• B. Use the Business Intelligence Development Studio (BIDS) and set the processing option to Do Not Process.
• C. Use the Deployment Wizard along with the appropriate options.
• D. Use the Analysis Services Destination component in Microsoft SQL Server Integration Services (SSIS).

You design a report by using SQL Server 2008 Reporting Services (SSRS).
Detail information is displayed each time the users render the report.
You need to ensure that the following requirements are met:
Summary information is displayed when the report is initially rendered.
Detail information is displayed only when the users click a column header.
What should you do?

• A. On the column that contains detail information, set the hidden property to FalsE. Set the Visibility can be toggled by another report item property to True.
• B. On the column that contains detail information, set the hidden property to FalsE. Set the Visibility can be toggled by another report item property to False.
• C. On the column that contains detail information, set the hidden property to TruE. Set the Visibility can be toggled by another report item property to True.
• D. On the column that contains detail information, set the hidden property to TruE. Set the Visibility can be toggled by another report item property to False.