IBM C2020-645 Online Practice Questions and Exam Preparation

IBM C2020-645 Online Questions & Answers

• Question 1:

  Which of the following are dimensional objects?

  A. Sets and query calculation
  B. Query subject andrelationship cardinality
  C. Slicer and string function
  D. Level and member
  B. Query subject andrelationship cardinality

• Question 2:

  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
  C. Descendants

• Question 3:

  A report author is working with an OLAP data source. The reportauthor creates a query that uses a caption function on a member and applies a string function. What is a possible consequence of this action?

  A. Using these dimensional methods will not work with an OLAP data source.
  B. The mapped string values willnot pass through to the target report.
  C. There is nothing wrong with this approach.
  D. Mixing dimensional styles and relational styles in a single query can create unexpected results.
  D. Mixing dimensional styles and relational styles in a single query can create unexpected results.

• Question 4:

  A report author can use a slicer to dowhat?

  A. Make the report database smaller and efficient
  B. Provide context to intersection values
  C. Reduce the number of members on the edge of the crosstab.
  D. Generate a zero suppression filter in the rows
  B. Provide context to intersection values

• Question 5:

  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.
  B. 500,382,422.83

• Question 6:

  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.
  B. Create a new column as a query calculation, and create the expression [2006]-[2005].

• Question 7:

  What is true about MUNs?

  A. A MUN is abusiness key that allows drill through between packages.
  B. A MUN is a key with a unique value at each level.
  C. A MUN contains the fully qualified path to a member.
  D. A MUN is a category code that is generated when the cube is built.
  C. A MUN contains the fully qualified path to a member.

• Question 8:

  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.
  A. Yes, if the correct syntax is used.

• Question 9:

  A reportauthor creates a crosstab as shown.

  

  What is the default measure of the report?

  A. Mountaineering Equipment
  B. Camping Equipment
  C. Gross profit
  D. Revenue
  D. Revenue

• Question 10:

  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.
  C. Use it to determine the current quarter: parent([Current Month]).