You need to ensure that the aggregations designed on FactSales always include the Month attribute.

What should you do?

A.

Set the Usage property appropriately.

B.

Set the IsAggregatable property appropriately.

C.

Set the AggregationUsage property appropriately.

D.

Set the AttributeHierarchyEnabled property appropriately.

Correct Answer: C

QUESTION 22

You create a SQL Server 2008 Analysis Services (SSAS) solution. You enable proactive caching for a partition. You need to ensure that SSAS can query relational data when multidimensional storage is being updated. What should you do?

A.

Set the OnlineMode property for the partition to Immediate.

B.

Set the ProcessingMode property for the partition to Regular.

C.

Set the OnlineMode property for the partition to OnCacheComplete.

D.

Set the ProcessingMode property for the partition to LazyAggregations.

Correct Answer: A

QUESTION 23

You create a SQL Server 2008 Analysis Services (SSAS) solution.

You create a dimension named DimCustomer that contains the following three attributes:

Customer

City

Country

The Customer attribute is the key. The DimCustomer dimension is related to a measure group named Sales that has the Granularity property set to City.

You need to ensure that you can retrieve measure values based on the City and Country attributes.

What should you do?

A.

Set the source attribute to Customer and the related attribute to City.Set the source attribute to City and the related attribute to Country.

B.

Set the source attribute to City and the related attribute to Customer.Set the source attribute to Country and the related attribute to City.

C.

Set the source attribute to Customer and the related attribute to City.Set the source attribute to Customer and the related attribute to Country.

D.

Set the source attribute to City and the related attribute to Customer.Set the source attribute to Country and the related attribute to Customer.

Correct Answer: A

QUESTION 24

You create a SQL Server 2008 Analysis Services (SSAS) solution. The cube structure is as shown in the following exhibit. (Click the Exhibit button.)

The Ownership column contains decimal values that represent percentage of ownership. The sum of all the values in the Ownership column for a single DimAccount member is 100%.

You create the following measures:

Ownership

Amount

You need to ensure that when the Amount measure is calculated against the DimCustomer dimension, the weighted value is calculated based on the Ownership measure.

What should you do?

A.

Set the MeasureExpression property of the Amount measure to [Amount]*[Ownership].

B.

Set the FormatString property of the Amount measure to [Amount]*[Ownership].

C.

Set the MeasureExpression property of the Amount measure to [DimCustomer].[Amount]*[Ownership].

D.

Set the FormatString property of the Amount measure to [DimCustomer].[Amount]*[Ownership].

Correct Answer: A

QUESTION 25

You create a SQL Server 2008 Analysis Services (SSAS) solution. The solution includes a table named FactOrders that contains two columns as shown in the following table:

You need to create a measure that returns the number of customers who have placed orders.

What should you do?

A.

Set the Usage property to Count of rows and the Source Column property to OrderKey.

B.

Set the Usage property to Distinct count and the Source Column property to OrderKey.

C.

Set the Usage property to Distinct count and the Source Column property to CustomerKey.

D.

Set the Usage property to Count of rows and the Source Column property to CustomerKey.

Correct Answer: C

QUESTION 26

You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a dimension named DimProduct that contains an attribute named Price. You use the DimProduct dimension in a cube. You need to ensure that aggregations are not associated with the Price attribute. What should you do?

A.

Set the IsAggregatable property of the Price attribute to False.

B.

Set the AttributeHierarchyEnabled property of the Price attribute to False.

C.

Set the MembersWithData property of the Price attribute to NonLeafDataHidden.

D.

Set the GroupingBehavior property of the Price attribute to DiscourageGrouping.

The package contains two Boolean variables named @IsWeekday and @IsHoliday. When the package is executed on week days, the @IsWeekday variable is set to True. When the package is executed on holidays, the @IsHoliday variable is set to True.

You need to implement the following business logic in the control flow of the package:

When the @IsWeekday variable is set to True, the Perform Weekday Processing Data Flow task is executed.

When the @IsWeekday variable is set to False, the Perform Weekend Processing Data Flow task is executed.

When the @IsHoliday variable is set to True, the Perform Holiday Processing Data Flow task is executed.

Which control flow logic should you implement?

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Correct Answer: A

QUESTION 28

You develop a SQL Server 2008 Integration Services (SSIS) package. You need to modify the path where the package writes event data to a text file. What should you do?

A.

Modify the log provider.

B.

Modify the Connection Manager.

C.

Modify the Flat File Destination.

D.

Move the package file to the new path.

Correct Answer: B

QUESTION 29

You are editing a SQL Server 2008 Integration Services (SSIS) package by using Business Intelligence Development Studio. The package uses a custom data flow component. The package runs successfully. You attempt to add another instance of the custom data flow component to the package. The data flow component does not appear in the toolbox or in the Choose Toolbox Items dialog box. You need to add the custom data flow component to the toolbox. What should you do?

A.

Copy the assembly to the appropriate folder.

B.

Add the assembly to the Global Assembly Cache.

C.

Register the assembly by using the REGSVR32 utility.

D.

Register the assembly by using the Assembly Registration utility (REGASM.EXE).

Correct Answer: A

QUESTION 30

You design a SQL Server 2008 Integration Services (SSIS) data flow that inserts data from a source query to a destination table. You need to insert only those rows that do not already exist in the destination table. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)