IBM C2020-645 Online Practice Questions and Exam Preparation

IBM C2020-645 Online Questions & Answers

• Question 31:

  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?

  A. Hierarchy names, member values
  B. Level order, level names
  C. Hierarchy names, snowflake schema
  D. Role value, internal keys
  B. Level order, level names

• Question 32:

  Assuming that Star products and Husky products are sets,

  

  which statement below is correct about the sets in the graphic?

  A. Each set is a grouping of members from different hierarchies.
  B. The report creates a query for each member ofthe set.
  C. The query displays each set as all the members of the level.
  D. Each set can be sorted and aggregated.
  D. Each set can be sorted and aggregated.

• Question 33:

  A report author creates a revenue report from an OLAP data source. On the rows, there are nested levels, each from different dimensions having a large number of members. The report author filters out empty rows using the expression "[Revenue] > 0".

  When running this report, there is poor performance. What could cause this?

  A. There are too many members or levels nested on the rowedge.
  B. Filtering on measure values is incompatible with an OLAP data source.
  C. Limiting the crosstab measures with a filter function.
  D. A relational filter was applied.
  D. A relational filter was applied.

• Question 34:

  Based on the diagram,

  

  if the expression firstSibling([2006 Q 1]) is used in the report, what item will be returned?

  A. 2005 Q 1
  B. 2006 Q 4
  C. 2006 Q 1
  D. Nothing, because the return value equals the parameter
  C. 2006 Q 1

• Question 35:

  Which of the following statements is correct about the order function?

  A. The currentMeasure function must be used with the orderfunction as the sort by criterion.
  B. It arranges members of all sets in the report by ascending or descending values.
  C. Optional parameters allow the author to order the members of a hierarchy without regard of their level.
  D. It arranges members of a set alphabetically by ascending or descending captions.
  C. Optional parameters allow the author to order the members of a hierarchy without regard of their level.

• Question 36:

  The report author creates a source report that containsvalues from "Products" on which the report consumer will drill through for details. The report author has created a target report which expects a member from the source. Is this a supported drill-through combination?

  A. Yes, this value-to-member drill-through is a supported combination.
  B. No, this value-to-member drill-through is not a supported combination.
  C. No, this member-to-value drill-through is not a supported combination.
  D. Yes, this member-to-value drill-through is a supported combination.
  B. No, this value-to-member drill-through is not a supported combination.

• Question 37:

  A report author creates a report with a drill-through definition. In the target report the parameter expression is "->?P?". What type of data must be passed to the parameter?

  A. A member from the level
  B. Any member from the hierarchy
  C. A value
  D. A business key from the level
  A. A member from the level

• Question 38:

  Why would a report author consider overriding the default drill behavior?

  A. To maintain the behavior of a complex edge expression after drilling, such as one which returns the top 5 members of a set.
  B. To replace all members within a hierarchy when drilling through to a report with more detail.
  C. To drill down to the lowest level of the hierarchy and then drill down again to display only one member.
  D. To drill down on a member and have its children display as details and have the member drilled on display as summary.
  A. To maintain the behavior of a complex edge expression after drilling, such as one which returns the top 5 members of a set.

• Question 39:

  To create a report from the data source shown, what entities will the report author use?

  

  A. Members
  B. Values
  C. Attributes
  D. MUNs
  B. Values

• Question 40:

  When must a report author use the caption function?

  A. As the first parameter of the roleValue function.
  B. To return the display name for thespecified business key.
  C. To see the string display name for the specified element.
  D. To pass the returned value to a drill-through target report, this expects a matching string as a parameter value.
  D. To pass the returned value to a drill-through target report, this expects a matching string as a parameter value.