C2020-645 Exam - Free IBM Questions and Answers

Question #6 (Topic: )

What is true about MUNs?

A. A MUN is abusiness key that allows drill through between packages. B. A MUN is a key with a unique value at each level. C. A MUN contains the fully qualified path to a member. D. A MUN is a category code that is generated when the cube is built.

Answer: C

Question #7 (Topic: )

Assuming that Star products and Husky products are sets,
which statement below is correct about the sets in the graphic?

A. Each set is a grouping of members from different hierarchies. B. The report creates a query for each member ofthe set. C. The query displays each set as all the members of the level. D. Each set can be sorted and aggregated.

Answer: D

Question #8 (Topic: )

A crosstab report has product lines in the rows, years in the columns, and revenue as the
measure. In Query Explorer, from the source tree, the report author drags the order method
Telephone to the Slicer pane. Why does the report author do this?

A. To help to set the context. B. To create an ordered set. C. To return only one tuple. D. To aggregate the telephone member.

Answer: A

Question #9 (Topic: )

A data source has a Time hierarchy, a Products hierarchy, and a Retailers hierarchy. What
are the preferred techniques the report author would use to focus reports for this type of a
data source?

A. Dimensional functions and slicers B. Use Members directly C. Ancestors and descendants D. Detail filters and summary filters

Answer: A

Question #10 (Topic: )

Which of the following are dimensional objects?

A. Sets and query calculation B. Query subject andrelationship cardinality C. Slicer and string function D. Level and member

Answer: B

IBM C2020-645 - IBM Cognos 10 BI Multidimensional Author Exam