C2020-625 Exam - Free IBM Questions and Answers

Question #1 (Topic: )

Which would be reasons for modifying a hierarchy that was previously created using the
Hierarchy wizard? (Choose two)

A. To add an attribute to a hierarchy level. B. To add a measure element to the hierarchy. C. To specify a fact build for the hierarchy. D. To add a level to the hierarchy. E. To specify a metadata dimension for the hierarchy. F. To add a derived dimension element to the hierarchy.

Answer: A,D

Question #2 (Topic: )

What can be done to minimize memory consumption?

A. Disable dimension breaking on the fact build. B. Disable fact build logging. C. Enable dimension breaking on the fact build. D. Enable auditing on the fact build.

Answer: C

Question #3 (Topic: )

A developer has created a derivation in a data source. When will this derivation be
calculated?

A. As each row is retrieved from the data source. B. After the source data is pivoted, but before it is merged and aggregated. C. After each row has been moved into the DataStream. D. Before the source data is pivoted, but after it is merged and aggregated.

Answer: A

Question #4 (Topic: )

Which of the following is true of pivoting?

A. Each data source column in the array must be mapped to a corresponding pivot value. B. It increases the number of output columns. C. It decreases the number of output rows. D. Each data source column in the array must be mapped to a pivot derivation element.

Answer: A

Question #5 (Topic: )

Below, what does Unknown Class (?Class) represent?

A. Manual level B. Literal C. Foster parent D. Recursive level

Answer: C

IBM C2020-625 - IBM Cognos 10 BI Data Warehouse Developer Exam