You develop a report by using SQL Server 2008 Reporting Services (SSRS).
The report has a dataset that contains 25 columns of data. You plan to render the dataset to
a Microsoft Office Excel worksheet.
You need to ensure that the report columns are properly aligned when rendering to Excel.
Which type of data region should you use?

You administer an instance of a SQL Server 2008 server.
The server is used to execute SQL Server 2008 Integration Services (SSIS) packages.
You need to ensure that the server executes only correctly signed packages.
What should you do?

You manage the security in SQL Server 2008 R2 Reporting Services (SSRS).
You create a new role.
You need to grant the following permissions to the role:
View and modify security settings for reports, folders, resources, and shared data sources.
Create and delete reports.
Modify report properties.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)

You are designing a SQL Server 2008 Integration Services (SSIS) package. The package
will be used to extract data from a SQL Server 2008 database and load data to a Microsoft
Office Excel workbook. You need to ensure that the package creates a new worksheet in an
existing Excel workbook during execution. Which control flow component should you use to
create the worksheet?

You maintain a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to process the aggregations of a cube by using an XML for Analysts (XMLA) script.
You need to ensure that only the aggregations are updated.
What should you do?

You administer an instance of SQL Server Analysis Services (SSAS).
To troubleshoot access rights issues, you need to find out which roles are applied to a user.
Which event should you trace in Microsoft SQL Profiler?

You are developing a SQL Server 2008 Reporting Services (SSRS) report.
The organization requires a drilldown report that color coordinates the values of students’
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?

You create a SQL Server 2008 Reporting Services (SSRS) report for a school district.
The school district needs to be able to retrieve the median value of all test scores.
You build a custom function named Median that accepts the test scores and returns the
median test score.
You need to run this custom function.
Which expression should you use?

You have a SQL Server 2008 R2 Analysis Services (SSAS) solution.
You add a new Data Source View (DSV) to the solution. The DSV includes a SalesOrder
table with columns for OrderTotal and CostTotal.
You need to derive the profit for each order without modifying the underlying data.
What should you do?

You maintain a SQL Server 2008 Analysis Services (SSAS) instance.
You are developing a new data mining structure.
You need to set the Microsoft Clustering Algorithm to meet the following requirements:
Allow data points to be assigned to two clusters.
Generate a probability for each combination of data point and cluster.
Provide the fastest results on large datasets (greater than one million records).
Which clustering method should you use?