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

Question 1

To add dimensional data to an existing model, how can metadata be leveraged from other
published OLAP packages?

A. Add a data source query using a Cognos 10 OLAP report.

B. Add dimensions from an OLAP package in the dimension map.

C. Insert an OLAP package in the data source list.

D. Import a PowerCube as a data source.

Correct Answer: B

Question 2

How can the parent-child relationship for each category be established?

A. Show category counts.

B. Insert manual levels.

C. Verify the model.

D. Generate the categories.

Correct Answer: D

Question 3

Senior Managers need to see total and regional sales figures, but Regional Managers should see
relevant figures for only their regions. Where can the developer specify the degree of detail to be
included?

A. In a cube group

B. In a manual level

C. In a scenario dimension

D. In the PowerCube

Correct Answer: A

Question 4

When can Transformer category codes change?

A. When a Clean House is performed before a cube is rebuilt.

B. When a reset partition is applied.

C. When the cube connection is updated with pcconn.

D. When a new cube is defined.

Correct Answer: A

Question 5

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 6

A developer created a cube for each regional Sales Manager. Each cube should contain only the
transactional details for each Sales Manager's region, as well as the summarized values for other
regions. What should be created?

A. Cube group

B. Custom view

C. Apexed view

D. Suppressed view

Correct Answer: A

Question 7

How can a cube be built with data volumes that result in a .mdc file larger than 2 GB?

A. Enable the creation of multiple local PowerCube files.

B. Remove the auto-partitioning scheme.

C. Use multiple checkpoint files.

D. Set the MultiFileCubeThreshold value to zero.

Correct Answer: A

Welcome to TestSimulate

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