IBM C2020-645 Online Practice Questions and Exam Preparation

IBM C2020-645 Online Questions & Answers

• Question 11:

  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
  A. 1 and 4

• Question 12:

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

• Question 13:

  Which of the following statements is true about explicitly defined member sets?

  A. They must have drill behavior defined manually.
  B. They assume the drill behavior from the top member setin the same branch.
  C. They are automatically configured for default drill behavior.
  D. They are too complex to enable drilling.
  A. They must have drill behavior defined manually.

• Question 14:

  A report author uses the following expression: lastPeriods(3,[2007/Mar]). What data will be returned when the report is run?

  A. The last 3 months before 2007/Mar
  B. 3 months, including 2007/Mar and the preceeding 2 months
  C. The total of currentMeasure for 3 months including 2007/Mar and the preceeding 2 months
  D. The month March of each of the 3 years 2005, 2006, and 2007
  B. 3 months, including 2007/Mar and the preceeding 2 months

• Question 15:

  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])
  C. [Revenue]/tuple([Revenue],[Products])

• Question 16:

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

  A. The report author has implicitly set the default measure for the crosstab report to be Revenue.
  B. The report author must verify the aggregation properties of Revenue to make sure it will display correctly.
  C. Thereport author has declared a currentMember function to return the Revenue data.
  D. The report author must validate the expression for Revenue to ensure there are no crosstab errors.
  A. The report author has implicitly set the default measure for the crosstab report to be Revenue.

• Question 17:

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

  A. Cousin
  B. PrevMember
  C. Siblings
  D. OpeningPeriod
  A. Cousin

• Question 18:

  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.
  B. It affects the values of the cells of the report but not the rows or columns.

• Question 19:

  When the report consumer drills through from a dimensional member to a relational data item, what data type is passed?

  A. Category code
  B. Caption value
  C. Member unique name
  D. Business key
  D. Business key

• Question 20:

  A report runs, and is 433pages long, with 19,010 rows. Many of the rows are blank. The report author uses a filter function to filter nulls, and runs the report again. The result is 143 pages, with 6273 rows, and none of the rows are blank. What filtering style did the report author decide to use?

  A. Conventional
  B. Dimensional
  C. Relational
  D. Functional
  B. Dimensional