Skip to main content

C2090-645 Real Exam Questions

IBM Cognos 10 BI Multidimensional Author

56 questions available · Page 1 of 6

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

Which term below best describes the selected cell in the crosstab?

  1. A

    Level

  2. B

    member

  3. C

    Tuple

  4. D

    Revenue

Show answer and explanation

Correct answer: C

Question 2 Single choice

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?

  1. A

    Ancestor, currentMember, lead, total

  2. B

    OpeningPeriod, order, quarter, Firstsibling

  3. C

    Cousin, tuple, closingPeriod, aggregate

  4. D

    ParallelPeriod, tuple, periodsToDate, aggregate

Show answer and explanation

Correct answer: D

Question 3 Single choice

To display all individual campaigns in a crosstabreport, a report author could use the expression set ([TrailChef Campaign],[EverGlow Campaign],[Course Pro Campaign]). Instead, the report author decides to use the parent member of the campaigns in the set expression "children([All Campaigns])".

Which statement is true about the method that was used?

  1. A

    In the future, when a campaign is deleted or new ones are added, the report author must modify the expression.

  2. B

    In the future, when a campaign is deleted or new ones are added, the unmodified expression will be valid.

  3. C

    The report author should not have used the method chosen, as the first method is best in this situation.

  4. D

    To be accurate, the report author should avoid using a set expression.

Show answer and explanation

Correct answer: B

Question 4 Single choice

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?

  1. A

    Relational authoring style, except function

  2. B

    Dimensional authoring style, filter function

  3. C

    Dimensional authoring style, except function

  4. D

    Relational authoring style, filter function

Show answer and explanation

Correct answer: C

Question 5 Single choice

When a report author inserts Revenue into the Measures area of a blank crosstab report, which of thefollowing statements is correct?

  1. A

    The report author has implicitly set the default measure for the crosstab report to be Revenue.

  2. B

    The report author must verify the aggregation properties of Revenue to make sure it will display correctly.

  3. C

    Thereport author has declared a currentMember function to return the Revenue data.

  4. D

    The report author must validate the expression for Revenue to ensure there are no crosstab errors.

Show answer and explanation

Correct answer: A

Question 6 Single choice

The "Sales" and "Inventory" data stores each have "Products" and "Time"dimensions.
For drill-through between the data stores on the "Products" and "Time" dimensions to work, which items in the structures must be identical in the data stores?

  1. A

    Hierarchy names, member values

  2. B

    Level order, level names

  3. C

    Hierarchy names, snowflake schema

  4. D

    Role value, internal keys

Show answer and explanation

Correct answer: B

Question 7 Single choice

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?

  1. A

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

  2. B

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

  3. C

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

  4. D

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

Show answer and explanation

Correct answer: C

Question 8 Single choice

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

  1. A

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

  2. B

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

  3. C

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

  4. D

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

Show answer and explanation

Correct answer: A

Question 9 Single choice

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?

  1. A

    Replace Expression

  2. B

    Depth Based Expression

  3. C

    Preserve

  4. D

    Replace Item

Show answer and explanation

Correct answer: C

Question 10 Single choice

The following expression is used to focus OLAP data in the rows of a report:
filter([sales_and_marketing].[Order method].[Order method].[Order method type], [Revenue]>150000000).

Which of the following statements describes the purpose of the expression?

  1. A

    To return the set of members whose revenue is less than150000000 for any year.

  2. B

    To return the set of members whose revenue is greater than 150000000 for the sum of the opposite edge.

  3. C

    To filter the cell values by subtracting 150000000 from the revenue for each year and order method type.

  4. D

    To filter the years to show those having revenues greater than 150000000 by order method type.

Show answer and explanation

Correct answer: B