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 a semi-additive measure group.
• C. Define the QuantityOnHand measure as an additive measure.
• D. Define the MaterialsInventory group as an additive measure group.

You create a SQL Server 2008 Analysis Services (SSAS) solution. You enable proactive caching for a partition.
You need maintain SSAS performance by preventing the partition from entering ROLAP mode. What should you do?

• A. Set the ProcessingMode property for the partition to Regular.
• B. Set the ProcessingMode property for the partition to LazyAggregations.
• C. Set the OnlineMode property for thepartition to OncacheComplete.
• D. Set the OnlineMode property for the partition to Immediate.

You are developing a SQL Server 2008 Integration Services (SSIS) package.
The package uses an OLE DB connection manager to connect to a third-party database server. The
database does not support Integrated Windows authentication.
You create an XML configuration file that provides configuration for the connection manager. You add the
configuration file to the package.
When the package executes, you receive an error message which indicates that login failure occurred.
You need to execute the package successfully.
What should you do?

• A. Edit the XML configuration file.
• B. Run the package on the same server as the third-party database server.
• C. Use a Microsoft ADO.NET connection manager instead of an OLE DB connection manager.
• D. Use an indirect XML configuration.

You maintain a SQL Server 2008 Analysis Services (SSAS) instance. The instance contains a database.
You change the DataDir property of the instance to a new folder.
You need to ensure that the instance uses the new folder in the minimum amount of downtime.
What should you do?

• A. Delete the files in the original folder, and then restart the Analysis Services service.
• B. Synchronize the database.
• C. Process the database.
• D. Restart the Analysis Services service.

You create a SQL Server 2008 Analysis Services (SSAS) solution. You have a table named Orders that contains the following columns: OrderKey Shipper OrderAmount You create a dimension named DimOrders from the Orders table. You set the OrderKey as a key column and the Shipper column as an attribute. You create a measure group named FactOrders from the Orders table. You need to create a dimension relationship to ensure that the OrderAmount column can be aggregated by the Shipper column. What should you do?

• A. Create a fact dimension relationship between the DimOrders dimension and the FactOrders measure group.
• B. Create a regular dimension relationship between the DimOrders dimension and the FactOrders measure group. Set the Granularity attribute to Shipper and the measure group columns to OrderAmount.
• C. Create a regular dimension relationship between the DimOrders dimension and the FactOrders measure group. Set the Granularity attribute to OrderKey and the measure group columns to OrderAmount.
• D. Set the relationship between the DimOrders dimension and the FactOrders measure group to No Relationship.