SAP C_BOWI_42 Online Practice Questions and Exam Preparation

SAP C_BOWI_42 Online Questions & Answers

• Question 171:

  A document displays a data in the format: MM/DD/YY. What option allow you to change the format to DD/MM/YY? (2 answers)

  A. Format number
  B. Preferred viewing locale
  C. Auto detect
  D. Product locale
  A. Format number
  B. Preferred viewing locale

• Question 172:

  In what application mode can you freeze column headers?

  Please choose the correct answer.

  Response:

  A. Data
  B. Design, With Data
  C. Reading
  D. Design, Structure Only
  C. Reading

• Question 173:

  What can you do with a scope of analysis? (2 answers)

  A. Restrict the data retrieved from the database only to the objects on the report.
  B. Perform calculation.
  C. Request the data from the database for drilling.
  D. Provide further detail on data.
  C. Request the data from the database for drilling.
  D. Provide further detail on data.

• Question 174:

  Which two statements about the If() function are correct?

  There are 2 correct answers to this question.

  Response:

  A. Can contain a SQL statement
  B. Can contain a Case expression
  C. Contains a Boolean expression
  D. Can contain nested If() statements
  C. Contains a Boolean expression
  D. Can contain nested If() statements

• Question 175:

  You insert the function CurrentDate() into a cell. To clarify the date you add a string so that the formula is now:

  ="Sales Report from "+CurrentDate()

  Which formatting capability is disabled for the cell?

  Please choose the correct answer.

  Response:

  A. Format cell
  B. Hide cell
  C. Align text
  D. Format number
  D. Format number

• Question 176:

  Which statement is true about calculation contexts?

  Please choose the correct answer.

  Response:

  A. They allow manipulation of reports to change the way the data is displayed.
  B. They allow manipulation of variables to change the way the data is aggregated.
  C. They allow manipulation of universe objects to change the way the data is displayed.
  D. They allow manipulation of universe contexts to change the way the data is aggregated.
  B. They allow manipulation of variables to change the way the data is aggregated.

• Question 177:

  Which of the following filter components are used to restrict data? (3 answers)

  A. An operator
  B. A universe connection
  C. A SELECT statement
  D. An object
  E. An operand
  A. An operator
  D. An object
  E. An operand

• Question 178:

  How can you see general report information such as the document author and the document creation date?

  Please choose the correct answer.

  Response:

  A. Select the Query Properties button.
  B. Open the Query panel.
  C. Insert the pre-defined cell Query Summary in the report.
  D. Open the Document Summary panel.
  D. Open the Document Summary panel.

• Question 179:

  What property prevents free-form entry in response of a prompt?

  A. Keep last value selected
  B. Optional prompt
  C. Select only from list
  D. Set default values
  C. Select only from list

• Question 180:

  How do you determine if a formula or a variable is used in a block? (2 answers)

  A. Change the application mode to Reading
  B. Select the block, right click and select Format Table
  C. Change the application mode to Design and select Structure Only
  D. Select the cell and view the formula toolbar
  C. Change the application mode to Design and select Structure Only
  D. Select the cell and view the formula toolbar