IBM IBM Cogno C2090-645 Questions & Answers

• Question 21:

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

  A. Cousin

  B. PrevMember

  C. Siblings

  D. OpeningPeriod

  Correct Answer: A

• Question 22:

  What does the following expression do:

  "generate([Productline],topCount(descendants(currentMember([sales_and_marketing].[Pro ducts].[Products]),[sales_and_marketing].[Products].[Products].[Product]),2,[Revenue]))"?

  A. Returns the top two products by revenue for each product line.

  B. Finds the top two members by revenue at the product level and returns their respective ancestors at the product line level.

  C. Calculates the top two product lines for each product.

  D. Goes two levels up from products and returns the top members by revenue at that level.

  Correct Answer: A

• Question 23:

  What is a key difference between the total function and the aggregate function?

  A. The aggregate function can only summarize within a set, and the total function can accept separate members.

  B. The aggregate function isdimensional, and the total function is relational.

  C. The aggregate function will summarize only the currentMeasure, and the total function will summarize any specified measure.

  D. The aggregate function follows the rollup rules of the measure defined in the data source, and the total function adds the total of the specified measure.

  Correct Answer: D

• Question 24:

  The dialog box shown appears when a report is run.

  

  What should the report author do to correct the situation?

  A. Ask the modeler to rename the hierarchy to '[sales_and_marketing].[Products].[Products].[Products]', and to republish the package.

  B. Modify the expression to change the 'currentMember' function to 'currentLevel'.

  C. Modify the expression to change the 'currentMember' function to 'currentHierarchy'.

  D. Modify the expression to 'currentMember([sales_and_marketing].[Products].[Products])'.

  Correct Answer: D

• Question 25:

  Based on the crosstab displayed, the report author creates a singleton using the tuple function as follows: tuple([Camping Equipment],[Revenue],[2006]).

  

  Which of the following will appear in the singleton when the report is run?

  A. Camping Equipment, 500,382,422.83, 2006

  B. 500,382,422.83

  C. Camping Equipment, Revenue, 2006

  D. Nothing, singletons are notdimensional objects.

  Correct Answer: B

• Question 26:

  In a crosstab report, the report author wants a column to display a percentage of overall revenue that a particular product contributed to.

  

  Which of the following is a valid dimensional expression forthis purpose?

  A. tuple([Revenue]/[Products]*[Revenue])

  B. [Revenue]/([Revenue]*[Products])

  C. [Revenue]/tuple([Revenue],[Products])

  D. [Revenue]/total([Revenue]for[Products])

  Correct Answer: C

• Question 27:

  A report author creates an expression usingthe closingPeriod function to return the latest month found in the data source, and names the expression "Current Month".

  What can the report author do with "Current Month"?

  A. Use it to replace the lastPeriods(1,[Month]) expression currently in the report.

  B. Add it to an expression to find the current member for the Month level.

  C. Use it to determine the current quarter: parent([Current Month]).

  D. Use it as a report expression to display the current month in the page header of the report.

  Correct Answer: C

• Question 28:

  Can a prompt be used in the expression of a slicer?

  A. Yes, if the correct syntax is used.

  B. No, the slicer syntax is not compatible with prompt syntax.

  C. Yes, if the slicer is a hierarchy.

  D. No, the slicer must be manually created by the report author.

  Correct Answer: A

• Question 29:

  Of the following prompt syntax expressions, which two are considered to be dimensional?

  1) -> ??

  2) in (??)

  3) = ??

  4) set( -> ??)

  A. 1 and 4

  B. 1 and 2

  C. 2 and 3

  D. 3 and 4

  Correct Answer: A

• Question 30:

  Consumers want a report to compare the revenue and quantity sold for all product lines in a selected quarter, to the same quarter for the previousyear. They also want to see the total for periods, up to and including the quarter selected.

  

  Which of the following dimensional functions could the report author use to create this report?

  A. Ancestor, currentMember, lead, total

  B. OpeningPeriod, order, quarter, Firstsibling

  C. Cousin, tuple, closingPeriod, aggregate

  D. ParallelPeriod, tuple, periodsToDate, aggregate

  Correct Answer: D