IBM C2020-645 Online Practice Questions and Exam Preparation

IBM C2020-645 Online Questions & Answers

• Question 41:

  The report author wants tocreate a report to compare the sales of product types for special sales promotions in 2005 and 2006, but the report will exclude regular sales. Which style of authoring and which function will the report author use to create this report from a cube data source?

  A. Relational authoring style, except function
  B. Dimensional authoring style, filter function
  C. Dimensional authoring style, except function
  D. Relational authoring style, filter function
  C. Dimensional authoring style, except function

• Question 42:

  Which term below best describes the selected cell in the crosstab?

  

  A. Level
  B. member
  C. Tuple
  D. Revenue
  C. Tuple

• Question 43:

  The dialog box shown appears when a report is run.

  

  What should the report author do to correct the situation?

  A. Ask the modeler to rename the hierarchy to '[sales_and_marketing].[Products].[Products].[Products]', and to republish the package.
  B. Modify the expression to change the 'currentMember' function to 'currentLevel'.
  C. Modify the expression to change the 'currentMember' function to 'currentHierarchy'.
  D. Modify the expression to 'currentMember([sales_and_marketing].[Products].[Products])'.
  D. Modify the expression to 'currentMember([sales_and_marketing].[Products].[Products])'.

• Question 44:

  The sales manager requires a crosstab report to display the top 3 sales people for the month. Considering that an OLAP data source is used, what will the report author use when creating this report?

  A. A set expression
  B. An axis title
  C. A percent of base calculation
  D. The hierarchize function
  A. A set expression

• Question 45:

  A report author creates the following nestedreport using 2 adjacent levels of the same hierachy. Users should be able to drill down on the inner nesting with the outer nesting remaining unchanged.

  

  What advanced drilling behavior should the report author use to achieve this?

  A. Replace Expression
  B. Depth Based Expression
  C. Preserve
  D. Replace Item
  C. Preserve

• Question 46:

  The report author uses the filter function to focus data in areport, but the results are unexpected. What did the report author overlook when filtering the data?

  A. Relational detail
  B. Products hierarchy
  C. Report context
  D. Root levels
  C. Report context

• Question 47:

  A report authorhas created a crosstab report from the data source shown. The Retailer name level has been dragged to the rows and default drilling up and down has been activated.

  

  What will be displayed in the report if the consumer drills up on one of the members of Retailer name?

  A. The parent member of the member drilled on.
  B. The ancestors of the member drilled on from the whole Retailers hierarchy.
  C. The members from the Region level.
  D. The members from the Retailer country level.
  D. The members from the Retailer country level.

• Question 48:

  Which of the following is true if a report author nests members in a crosstab report?

  A. Nested members are also known as complex members.
  B. The inner membermust be on the level immediately below the outer member.
  C. Nested members must be members of hierarchies, not of the Measures folder.
  D. It is possible to nest members from different dimensions.
  D. It is possible to nest members from different dimensions.

• Question 49:

  To display all individual campaigns in a crosstabreport, a report author could use the expression set([TrailChef Campaign],[EverGlow Campaign],[Course Pro Campaign]). Instead, the report author decides to use the parent member of the campaigns in the set expression "children([All Campaigns])".

  Which statement is true about the method that was used?

  A. In the future, when a campaign is deleted or new ones are added, the report author must modify the expression.
  B. In the future, when a campaign is deleted or new ones are added, the unmodified expression will be valid.
  C. The report author should not have used the method chosen, as the first method is best in this situation.
  D. To be accurate, the report author should avoid using a set expression.
  B. In the future, when a campaign is deleted or new ones are added, the unmodified expression will be valid.

• Question 50:

  In a crosstab, Campaign is in the rows area, Order method type is in the columns area, and Quantity is the measure. Campaign and Order method type are specified in the query. The report runs, displaying quantity valuesfor all years. Why does this happen?

  A. The dimension member from that dimension is implied.
  B. The order method member from that dimension is implied.
  C. The aggregate member from that dimension is implied.
  D. The default member from that dimensionis implied.
  D. The default member from that dimensionis implied.