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

Page:    1 / 17   
Total 84 questions

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

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

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

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

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

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


Answer : C

Page:    1 / 17   
Total 84 questions