IBM Cognos 10 BI Multidimensional Author (C2020-645) Free Practice Test

Question 1

Which of the following family functions is most similar to the relative time function parallelPeriod?

A. Siblings

B. OpeningPeriod

C. PrevMember

D. Cousin

Correct Answer: D

Question 2

Which of the following are dimensional objects?

A. Query subject and relationship cardinality

B. Sets and query calculation

C. Slicer and string function

D. Level and member

Correct Answer: A

Question 3

A report author creates a report with a drill-through definition. In the target report the parameter expression is "<Level expression> ->?P?". What type of data must be passed to the parameter?

A. Any member from the hierarchy

B. A member from the level

C. A value

D. A business key from the level

Correct Answer: B

Question 4

What is true about MUNs?

A. A MUN contains the fully qualified path to a member.

B. A MUN is a business key that allows drill through between packages.

C. A MUN is a category code that is generated when the cube is built.

D. A MUN is a key with a unique value at each level.

Correct Answer: A

Question 5

The report author wants to create a report to compare the sales of product types for special sales promotions in 2005 and 2006, but the report will exclude regular sales. Which style of authoring and which function will the report author use to create this report from a cube data source?

A. Dimensional authoring style, filter function

B. Dimensional authoring style, except function

C. Relational authoring style, except function

D. Relational authoring style, filter function

Correct Answer: B

Question 6

A report author uses the following expression: lastPeriods(3,[2007/Mar]). What data will be returned when the report is run?

A. 3 months, including 2007/Mar and the preceeding 2 months

B. The total of currentMeasure for 3 months including 2007/Mar and the preceeding 2 months

C. The month March of each of the 3 years 2005, 2006, and 2007

D. The last 3 months before 2007/Mar

Correct Answer: A

Welcome to TestSimulate

IBM Cognos 10 BI Multidimensional Author (C2020-645) Free Practice Test