IBM IBM Cogno C2090-645 Questions & Answers

• Question 11:

  A report author creates the following nestedreport using 2 adjacent levels of the same hierachy. Users should be able to drill down on the inner nesting with the outer nesting remaining unchanged.

  

  What advanced drilling behavior should the report author use to achieve this?

  A. Replace Expression

  B. Depth Based Expression

  C. Preserve

  D. Replace Item

  Correct Answer: C

• Question 12:

  Which of the following is true if a report author nests members in a crosstab report?

  A. Nested members are also known as complex members.

  B. The inner membermust be on the level immediately below the outer member.

  C. Nested members must be members of hierarchies, not of the Measures folder.

  D. It is possible to nest members from different dimensions.

  Correct Answer: D

• Question 13:

  The report author wants tocreate 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. Relational authoring style, except function

  B. Dimensional authoring style, filter function

  C. Dimensional authoring style, except function

  D. Relational authoring style, filter function

  Correct Answer: C

• Question 14:

  Which of the following statements is true about a slicer?

  A. It keeps the summary column in the report, and removes the detail columns.

  B. It affects the values of the cells of the report but not the rows or columns.

  C. It determines which set of members are displayed onthe edges of the report.

  D. It removes all blank rows in the report to make it more focused.

  Correct Answer: B

• Question 15:

  A report author creates a revenue report from an OLAP data source. On the rows, there are nested levels, each from different dimensions having a large number of members. The report author filters out empty rows using the expression "[Revenue] > 0".

  When running this report, there is poor performance. What could cause this?

  A. There are too many members or levels nested on the rowedge.

  B. Filtering on measure values is incompatible with an OLAP data source.

  C. Limiting the crosstab measures with a filter function.

  D. A relational filter was applied.

  Correct Answer: D

• Question 16:

  Which of the following statements is correct about the order function?

  A. The currentMeasure function must be used with the orderfunction as the sort by criterion.

  B. It arranges members of all sets in the report by ascending or descending values.

  C. Optional parameters allow the author to order the members of a hierarchy without regard of their level.

  D. It arranges members of a set alphabetically by ascending or descending captions.

  Correct Answer: C

• Question 17:

  What dimensional function is used to return the members on the level below the Product line level?

  A. Set

  B. Children

  C. Descendants

  D. members

  Correct Answer: C

• Question 18:

  A report author uses an OLAP cube to create a crosstab with Revenue as a measure, the Product linelevel in the rows, and the year members (2004-2007) in the columns.

  How can the report author efficiently determine the difference in revenue between the years 2005 and 2006?

  A. Determine MUNs for the years 2005 and 2006, and then create an expressionusing the MUNs.

  B. Create a new column as a query calculation, and create the expression [2006]-[2005].

  C. Create a set of the 2005 and 2006 members and aggregate it.

  D. Ask the modeler to create a calculated category in Transformer and then use it directly.

  Correct Answer: B

• Question 19:

  What type of prompt would a report author use to return a set of members from a hierarchy?

  A. Select and Search Prompt

  B. Value prompt

  C. Tree prompt

  D. Prompt Page

  Correct Answer: C

• Question 20:

  If the syntax for thehead function is head(set_exp[,index_exp]),then which of the following expressions is correct?

  A. head(members([sales_and_marketing].[Products].[Products].[Product line]),2)

  B. head(([sales_and_marketing].[Products].[Products].[Product line])[,2])

  C. head(order([sales_and_marketing].[Products].[Products].[Product line])2)

  D. head(members([sales_and_marketing].[Products].[Products].[Product line],2))

  Correct Answer: A