You maintain a SQL server 2008 Analysis Services (SSAS) data warehouse for a school district. All tests are administered via a third-party application. Results are collected in your SSAS data warehouse and moved to a Scores fact table for analysis. This warehouse also includes a Student Dimension which contains attributes related to each student.
The school year is starting, and the district administration wants the Student Dimension updated hourly so that new students can be identified and tracked. However, test scores located in the Scores fact table should not be updated as part of this incremental processing strategy.
You need to implement this functionality. Which option should you use?

• A. Process Update
• B. Process Add
• C. Process Index
• D. Process Full

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.
View content, definition, and property for reports.
Which three actions should you perform? (Each correct answer presents part of the solution, Choose
three.)

• A. Assign the Manage All Subscriptions task to the role.
• B. Assign the Manage Reports task to the role.
• C. Assign Set Security Policies for Items task to the role.
• D. Assign the Consume Reports task to the role.
• E. Assign the Manage Resources task to the role.

You create a SQL Server 2008 R2 Analysis Services (SSAS) solution.
You are configuring security settings for a new database role with the following requirements:
Only the West member can be viewed by the database role. All other existing members and any newly
added members of the Region attribute will not be visible. Members in attribute hierarchies that include a
member of the Region attribute remain visible. The members in other attribute hierarchies remain visible.
The state of Washington is visible.
The aggregated totals for the ALL Level and Region attributes include only the values for members that are
visible.
You need to ensure that the database role has these security settings.
What should you do? (Each correct answer presents part of the solution. Choose two.)

• A. Set the State attribute's IsAllowed = True, AllowedSet = "Except(Region..Members,{West} + {Washington})", ApplyDenied = False, and VisualTools = False.
• B. Set the Region attribute's IsAllowed = False, DeniedSet = "Except(Region..Members,{West})", ApplyDenied = False, and VisualTools = False.
• C. Set the State attribute's IsAllowed = True, AllowedSet = "Except(Region..Members,{West})", ApplyDenied = True, and VisualTools = False.
• D. Set the Region attribute's IsAllowed = True, DeniedSet = "Except(Region..Members,{West})", ApplyDenied = False, and VisualTools = True.

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You maintain a SQL Server 2008 Reporting Services (SSRS) instance for a shoe company.
An existing report on shoe sales allows the user to see the company's revenue across many different
attributes.
You need to create a drop down list that filters the report by one or more shoe colors.
You alter the main dataset and configure the report parameter to accept multiple values.
What should you do next?

• A. Configure the Hidden Visibility property.
• B. Create a dynamic dataset that includes a list of the different users.
• C. Create a distinct dataset that includes all possible values and attach it to the parameter.
• D. Create a dynamic dataset that utilizes the WHERE clause to filter by the parameter.
• E. Configure the Internal Visibility option for the parameter.
• F. Create a dynamic data source from a dataset that includes a list of distinct servers.
• G. Create a dynamic data source from a dataset by using the IN operator.
• H. Develop a report for each environment.

You are developing a SQL Server 2008 Integration Services (SSIS) data flow that extracts data from two
sources.
Each source database is located on a different server. Each source is based on a SELECT statement that
uses an ORDER BY clause.
The data flow is as shown in the following diagram.
When the paths from the two sources are connected to a Merge Join component, the following error
message is displayed:
"Data Flow Task: The input is not sorted. The 'input "Merge Join Left Input" (80)' must be sorted."
You need to ensure that data from each query is included in each row in the data flow. You want to achieve
this goal by using minimum amount of execution time.
What should you do?

• A. Replace the Merge Join transformation with a Union All transformation.
• B. Add an OLE DB Command transformation for each data flow.
• C. Add a Sort transformation for each data flow.
• D. Update the sorting properties in each source component.