IBM Cognos 10 BI OLAP Developer (COG-635) Free Practice Test

Question 1

What does a unique move ensure when applied to a level in a dimension map?

A. The measure values are not rolled up to the new path of the moved categories.

B. The category can be moved to another level.

C. The category moved within the level has its data history moved with it.

D. The developer must manually restructure the categories in the dimension.

Correct Answer: C

Question 2

A dimension organizes all the regions by Country and City. Disregarding the hierarchical
organization, how can the five best performing regions be grouped?

A. Add an alternate drill-down path.

B. Create a scenario dimension.

C. Add a special category.

D. Create a subdimension.

Correct Answer: C

Question 3

What can be created if the financial analyst wants to look at the data by fiscal year, while the
senior manager wants to analyze the data by calendar year?

A. A subdimension in the time dimension.

B. A special category.

C. A calculated category.

D. An alternate hierarchy in the time dimension.

Correct Answer: D

Question 4

How is the PowerCube updated once changes are made to a custom view?

A. Security objects must be re-assigned.

B. The custom view should be re-defined.

C. The changes are automatically updated.

D. The cube must be rebuilt.

Correct Answer: D

Question 5

What can be done to apply member-based security if the model contains cube groups?

A. Inherit the security that was used in the control cube.

B. Define the security for each member cube.

C. Create a hierarchical custom view.

D. Create a descendant custom view.

Correct Answer: B

Question 6

Which of the following will help improve processing time when Transformer queries the data?

A. Define dimensions within a transactional data source with unique values.

B. Combine structural and transactional information into one data source.

C. Separate structural and transactional information in multiple data sources.

D. Use normalized structural data sources.

Correct Answer: C

Question 7

The model contains a measure named Quantity, and the OLAP reports need to show the Minimum
monthly quantity sold to each store. How would a developer get the correct result?

A. Use a Time state rollup function.

B. Use an External rollup function.

C. Use a Regular rollup function.

D. Use a Non-regular rollup function.

Correct Answer: C

Welcome to TestSimulate

IBM Cognos 10 BI OLAP Developer (COG-635) Free Practice Test