You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. The cube must store details of the data in a relational format and the aggregations in a multidimensional format.
Which of the predefined ProactiveCaching values property should you use?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report.
The query that builds the dataset for the report uses a WHERE clause to filter the rows.

The report parameter must perform the following actions:

Use the new parameterized query.Run without any user input.Allow users to change the value that is passed to the query by selecting a value from a drop-down list.

You need to modify the settings of the Report Properties dialog box to meet the outlined requirements.

Which four tasks should you perform? (Each correct answer presents part of the solution. Choose four.)

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS)package.The OLE DB

data source for the package is a database that is updated frequently.You need to create a package that

accomplishes the following tasks:

Implement the IRowsetFastLoad interface.Support various data flow destinations. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. You create a dimension that contains a parent-child hierarchy. The dimension has a key attribute named Employee and a parent attribute named Employees. You need to ensure that the dimension identifies the topmost employee member of the hierarchy as the root member. What should you do?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. You create a cube that uses a dimension named Product. The Product dimension contains an attribute named ProductName. You also create a URL action and set the action expression to “http://mycompany.com/ProductInfo.aspx?Product=”+Product.ProductName.CurrentMember.Na me You need to set the action target properties for the URL action. What should you do?

You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. You want to change the design of the data mining structure to test different data mining theories. You add columns of the Ordered content type in the data mining model and the underlying case table. You need to ensure that Data Mining Viewer reflects the changes in the data mining structure and the data mining model. Which process option should you choose?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report.
The query that builds the dataset for the report uses a WHERE clause to filter the rows.

The report parameter must perform the following actions:

Use the new parameterized query.Run without any user input.Allow users to change the value that is passed to the query by selecting a value from a drop-down list.

You need to modify the settings of the Report Properties dialog box to meet the outlined requirements.

Which four tasks should you perform? (Each correct answer presents part of the solution. Choose four.)

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report that supports drilldown. You need to modify the report so that the detailed data is hidden when the report is initially rendered. What should you do?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report.

You create a report parameter named DisplayCol that contains the following properties:

Data Type: Integer Prompt: Display Column Available Values: Non-queried with the following Label/Value pairs:

oYes/1 oNo/0

Default Values: Null

The report parameter is used to control the visibility of the column.

You need to use the appropriate expression in the Hidden property for the column.

Which expression should you use?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report model. Users must develop their own SSRS reports by using your report model in the Report Builder tool. The data source for the report model is a Microsoft SQL Server 2000 database that contains 900 tables and 700 views. You need to build a report model that allows users access to only the 10 tables that they require for reporting. What should you do?