IBM C2020-645 Online Practice Questions and Exam Preparation

IBM C2020-645 Online Questions & Answers

• Question 21:

  A crosstab report has product lines in the rows, years in the columns, and revenue as the measure. In Query Explorer, from the source tree, the report author drags the order method Telephone to the Slicer pane. Why does the report author do this?

  A. To help to set the context.
  B. To create an ordered set.
  C. To return only one tuple.
  D. To aggregate the telephone member.
  A. To help to set the context.

• Question 22:

  What type of prompt would a report author use to return a set of members from a hierarchy?

  A. Select and Search Prompt
  B. Value prompt
  C. Tree prompt
  D. Prompt Page
  C. Tree prompt

• Question 23:

  A data source has a Time hierarchy, a Products hierarchy, and a Retailers hierarchy. What are the preferred techniques the report author would use to focus reports for this type of a data source?

  A. Dimensional functions and slicers
  B. Use Members directly
  C. Ancestors and descendants
  D. Detail filters and summary filters
  A. Dimensional functions and slicers

• Question 24:

  Instead of prompting the user to select any countries in Europe, the report author wants to constrain the user to select one or more countries from the Northern Europe region. What kind of prompt should be used and how can this be achieved?

  A. This is not possible because a prompt must always be populated with all members of a level.
  B. Create a multi-select value prompt. Populate it using an expression on the [Northern Europe] member to retrieve its children on the country level.
  C. Generate a prompt by creating an expression with a parameter on the crosstab edge: children([Northern Europe]->?Country?
  D. Create a tree prompt, and populate it using an expression on the[Northern Europe] member to retrieve its children at the country level.
  B. Create a multi-select value prompt. Populate it using an expression on the [Northern Europe] member to retrieve its children on the country level.

• Question 25:

  What kind of authoring style uses the filter function?

  A. Relational
  B. Conformed
  C. Dimensional
  D. DMR
  C. Dimensional

• Question 26:

  What is the default behavior when drilling down on an edge in a crosstab report?

  A. The level drilled on is replaced with the entire level below it.
  B. The edge expression is replaced with the children of the item drilled on.
  C. All edge expressions of the crosstab are replaced with their children.
  D. The edge expression is changed to another item in the query.
  B. The edge expression is replaced with the children of the item drilled on.

• Question 27:

  The report author creates a query where two items (TopThree and Retailer country) exist in the same member set. The expression for TopThree is: topCount([Retailer country],3,[Revenue]).

  

  What drill behavior should the report author set in order to display the top three children instead of all children on drill down?

  A. Configure TopThree to Change Expression, and configureRetailer country to Preserve.
  B. Configure TopThree to Preserve, and configure Retailer country to Preserve.
  C. Configure TopThree to Preserve, and configure Retailer country to Replace Expression.
  D. Configure TopThree to Ancestor, and configure Retailercountry to Change Expression.
  C. Configure TopThree to Preserve, and configure Retailer country to Replace Expression.

• Question 28:

  The following expression is used in a crosstab report: filter([sales_and_marketing]. [Product brand].[Product brand].[Product brand type],[Revenue]<100000000). There are 26 product brand types in the OLAP data source.

  

  Why does the report only return 11 product brand type rows?

  A. A relational function was used to filter on the measure values, not the members.
  B. A dimensional functionwas used to filter on each column.
  C. A relational function was used to filter on the members, not the measure values.
  D. A dimensional function was used to filter on the total of the opposite edge.
  D. A dimensional function was used to filter on the total of the opposite edge.

• Question 29:

  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?

  A. To return the set of members whose revenue is less than150000000 for any year.
  B. To return the set of members whose revenue is greater than 150000000 for the sum of the opposite edge.
  C. To filter the cell values by subtracting 150000000 from the revenue for each year and order method type.
  D. To filter the years to show those having revenues greater than 150000000 by order method type.
  B. To return the set of members whose revenue is greater than 150000000 for the sum of the opposite edge.

• Question 30:

  When would a report author define a set?

  A. To create a slicer to focus on a specific number of years of data in a report.
  B. To change the crosstab node member properties for a level.
  C. To use as a summaryfunction to return the total of the specified members.
  D. To return members from different hierarchies of the same dimension.
  A. To create a slicer to focus on a specific number of years of data in a report.