COG-635 by IBM Valid Free Exam Practice Test

Question 1

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

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

Correct Answer: B

Question 2

How can a developer define a specific view of the data and restrict access to it?

A. Set package-based security. B. Apply namespace-level security. C. Apply cube-based security. D. Set member-based security.

Correct Answer: D

Question 3

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

A. The custom view should be re-defined. B. Security objects must be re-assigned. C. The changes are automatically updated. D. The cube must be rebuilt.

Correct Answer: D

Question 4

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

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

Correct Answer: A

Question 5

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

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

Correct Answer: B

Question 6

What can be created to provide new insight into the data if Margin Ranges are defined as Low,
Medium, and High, based on a calculated column using the revenue and cost columns?

A. Calculated category B. Special category C. Exception dimension D. Scenario dimension

Correct Answer: C

Question 7

A Cognos 10 report with prompts is used as a data source. What must be done to create a second
query that is based on the same report but provides different values for mandatory prompts?

A. Refresh the source when adding the second query. B. Add the same report as another Transformer report data source. C. Add the second query to the report data source. D. Add prompt values to the cache in the Transformer data source.

Correct Answer: B

IBM Cognos 10 BI OLAP Developer - COG-635 Exam Practice Test