Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan : 70-448 Exam Questions

You administer a SQL Server 2008 Analysis Services (SSAS) database. A sales manager is responsible for the sales of bikes in the Northeast region. You plan to grant the necessary permissions to the sales manager to access the database. You have two roles named Northeast Region and Bikes. The schemas of the two roles are as shown in the following tablE.Role Allowed set
Northeast Region
{[Sales Territory].[Sales Territory Region].&[Northeast]}
Bikes
{[Product].[Product Category].[Product Category].&[Bikes]}
The Visual Totals property is set to True for both roles.
You need to ensure that the sales manager can view only the members in the Product dimension that relate
to the Bikes category in the Northeast region.
What should you do?

• A. Add the manager to a new role that has the following two components: {[Sales Territory].[Sales Territory Region].&[Northeast]} as the allowed set. {[Product].[Product Category].[Product Category].&[Bikes]} as the allowed set.
• B. Add the manager to the Northeast Region role.
• C. Add the manager to a new role that has the following two components: {[Sales Territory].[Sales Territory Region].AllMembers} as the denied set {[Sales Territory].[Sales Territory Region].&[Northeast]} as the allowed set. {[Product].[Product Category].[Product Category].AllMembers} as the denied set. {[Product].[Product Category].[Product Category].&[Bikes]} as the allowed set.
• D. Add the manager to the Bikes role.

You create a SQL Server 2008 Analysis Services (SSAS) solution.
The cube structure is as shown in the following exhibit. (Click the Exhibit button.)
You need to ensure that the Amount measure can be aggregated for the DimCustomer dimension.
What should you do?

• A. Create a regular relationship between DimCustomer and FactTransaction.
• B. Create a referenced relationship between DimCustomer and FactCustomerAccount. Set DimAccount as an intermediate dimension.
• C. Create a many-to-many relationship between DimCustomer and FactCustomerAccount. Set FactTransaction as an intermediate measure group.
• D. Create a many-to-many relationship between DimCustomer and FactTransaction. Set FactCustomerAccount as an intermediate measure group.

You build and deploy a SQL Server 2008 Integration Services (SSIS) package.
During package development, the XML configuration is not specified.
You need to apply the configuration to the deployed package.
What should you do?

• A. Use the DTUTIL command line utility.
• B. Use the Deployment utility.
• C. Use the SETX command line utility.
• D. Use the DTEXEC command line utility.

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. Set the relationship between the DimOrders dimension and the FactOrders measure group to No Relationship.
• 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. 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.

You create a report in SQL Server 2008 Reporting Services (SSRS) solution.
You write the following code segment in the report.
Private Shared Function GetCmFromInches(ByVal InchValue As Decimal) As Decimal
If IsNothing(InchValue) Then Return Nothing Else Return InchValue * 2.54 End If End Function The code segment generates errors when compiled. You need to ensure that the following requirements are met: The code segment compiles successfully. The GetCmFromInches function can be called from other reports. What should you do?

• A. Create a custom assembly by using Microsoft Visual Basic .NET. Declare the function as Public Shared.
• B. Remove the Private keyword from the function definition.
• C. Remove the Shared keyword from the function definition.
• D. Declare the function as Public Shared instead of Private Shared.