IBM Cognos 10 BI OLAP Developer - COG-635 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

What improves performance in the reporting application by combining records with identical nonmeasure
values?

A. Consolidation B. PC Optimizer C. Partitioning D. Crosstab caching

Discussion 0

Correct Answer: A Vote an answer

Question 2

How does a developer associate a custom view with a PowerCube?

A. Specify the path of the Powercube in the custom view. B. Drag the custom view to the appropriate Powercube. C. Update the Powercube properties. D. Specify the package name in the custom view.

Discussion 0

Correct Answer: B Vote an answer

Question 3

The developer notices a decrease in run-time performance in a model that has calculated
measures (before rollup). Because auto-partitioning is not used, how can the developer increase
performance?

A. Use calculated columns instead of before rollup measures. B. Use an external rollup instead of a before rollup setting. C. Use a duplicates rollup instead of a before rollup setting. D. Use a time state rollup instead of before rollup setting.

Discussion 0

Correct Answer: A Vote an answer

Question 4

What must be done to make the cube data available in Analysis Studio?

A. Use the PowerCube Connection Utility to publish the cube. B. Create a data source connection to the cube in Transformer. C. Generate a package that contains a data source connection to the cube. D. Publish the PowerCube as a data source and a package.

Discussion 0

Correct Answer: D Vote an answer

Question 5

How can a developer best address values that are being rounded excessively?

A. Adjust the number of decimal places. B. Assign scale and precision settings. C. Modify the rollup operations. D. Create a calculated measure.

Discussion 0

Correct Answer: B Vote an answer

Question 6

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 a new cube is defined. D. When the cube connection is updated with pcconn.

Discussion 0

Correct Answer: A Vote an answer

Question 7

To control access to content for users that have similar responsibilities and privileges,where
should security be applied?

A. Namespace B. User C. Data source D. Role

Discussion 0

Correct Answer: D Vote an answer