IBM C2020-645 Online Practice Questions and Exam Preparation

IBM C2020-645 Online Questions & Answers

• Question 51:

  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.
  A. Returns the top two products by revenue for each product line.

• Question 52:

  What functionality will allow the report consumer to focus the report each time it is run?

  A. Filter a MUN
  B. Use a prompt
  C. Build a slicer
  D. Use a dimensional function
  B. Use a prompt

• Question 53:

  Which statement is true about MUNs?

  A. They are used to define roll-up properties in a hierarchy.
  B. They are used to retrieve members from the data source.
  C. They change each time the package is published.
  D. They are used to retrieve levels from the data source.
  B. They are used to retrieve members from the data source.

• Question 54:

  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
  D. ParallelPeriod, tuple, periodsToDate, aggregate

• Question 55:

  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))
  A. head(members([sales_and_marketing].[Products].[Products].[Product line]),2)

• Question 56:

  In the data source shown,

  

  what dimensional component is selected?

  A. Dimension
  B. Hierarchy
  C. Namespace
  D. Level
  B. Hierarchy