SAP C_BOWI_42 Online Practice Questions and Exam Preparation

SAP C_BOWI_42 Online Questions & Answers

• Question 151:

  How does rearranging the objects in the Result pane after the query has run affect the block display?

  Please choose the correct answer.

  Response:

  A. The objects are rearranged in the block based on the order in the Results Objects pane.
  B. The reordered objects are removed from the block.
  C. The block is sorted in ascending order based on the first object in the Results Objects pane.
  D. The block remains unchanged.
  D. The block remains unchanged.

• Question 152:

  How can you change the data source of a document with multiple queries?

  A. Use the Change Source Wizard to change the queries one at a time.
  B. Use the Change Source Wizard to change the queries all at once.
  C. Use the query panel to remap the objects to a new data source.
  D. Use the query panel to duplicate the queries and map them to a new data source.
  A. Use the Change Source Wizard to change the queries one at a time.

• Question 153:

  What does the RefValue() function return if there is no reference data?

  A. A blank
  B. A zero
  C. A null
  D. An error
  C. A null

• Question 154:

  Which three options appear in the Scope of Analysis pane in the Query panel?

  There are 3 correct answers to this question.

  Response:

  A. None
  B. Default
  C. Custom
  D. One Level
  A. None
  C. Custom
  D. One Level

• Question 155:

  Which two are running aggregate functions in Web Intelligence?

  There are 2 correct answers to this question.

  Response:

  A. RunningMax()
  B. RunningSum()
  C. RunningTotal()
  D. RunningMean()
  A. RunningMax()
  B. RunningSum()

• Question 156:

  Which method should you use to force each section of a report to start on a new page?

  Please choose the correct answer.

  Response:

  A. Select the section, Press CTRL-Enter.
  B. Right-click the section, select "Start Section on New Page".
  C. Select the section; in the Properties tab, check "Start on New Page".
  D. Select the section; click Report > Section and select "Start on New Page".
  C. Select the section; in the Properties tab, check "Start on New Page".

  ---

  Explanation/Reference:

• Question 157:

  Which of the following make up a semantic layer for a rational data source? (3 answers)

  A. Measure
  B. Dimension
  C. Section
  D. Universe
  E. Block
  A. Measure
  B. Dimension
  D. Universe

• Question 158:

  What do you use to conditionally hide a report element?

  A. A formula
  B. A formatting rule
  C. A query filter
  D. A report filter
  A. A formula

• Question 159:

  Which three elements are parts of a query filter? There are 3 correct answers to this question. Response:

  A. Class
  B. Object
  C. Operator
  D. Operand
  B. Object
  C. Operator
  D. Operand

• Question 160:

  How can you make the pie chart (shown in the attached graphic) display correctly?

  A. Change to the Design - With Data application mode.
  B. Change to the Reading application mode.
  C. Drag a dimension or attribute on to the chart
  D. Drag a measure on to the chart
  D. Drag a measure on to the chart