SAP C_BOWI_42 Online Practice Questions and Exam Preparation

SAP C_BOWI_42 Online Questions & Answers

• Question 221:

  To what can you apply conditional formatting rules (2 answers)

  A. Data in a chart
  B. Data in a section header cell
  C. Data in a table
  D. Data in a query filter
  B. Data in a section header cell
  C. Data in a table

• Question 222:

  You need to create a report displaying a year-to-date aggregation on sales revenue across all months. The report should be sectioned on Region. Additionally, you would like to reset the running aggregation to restart for each Region. Which syntax should you use to accomplish this task?

  A. =RunningTotal([Sales Revenue], Reset[Region])
  B. =RunningTotal([Sales Revenue], Region)
  C. =RunningSum([Sales Revenue] ; ([Region]))
  D. =RunningSum([Sales Revenue], Region)
  C. =RunningSum([Sales Revenue] ; ([Region]))

• Question 223:

  Conditional formatting rules enable you to highlight results that meet or fail specific business targets. Name the elements associated with the Formatting rules?

  There are 3 correct answers to this question

  Response:

  A. An object or cell contents
  B. A modified data formatting
  C. A cell section
  D. An operator
  E. The conditional formatting
  A. An object or cell contents
  D. An operator
  E. The conditional formatting

  ---

  Explanation/Reference:

• Question 224:

  Which method can you use to change the object qualification of an object within Web Intelligence Rich Client?

  Please choose the correct answer.

  Response:

  A. In the Query panel, select the qualification.
  B. In the Document Properties, select the qualification.
  C. In Query View, right-click and select the qualification.
  D. Select the object, right-click and select the qualification.
  A. In the Query panel, select the qualification.

• Question 225:

  Which statement is a benefit of using a Web Intelligence formula?

  Please choose the correct answer.

  Response:

  A. The formula can be reused in a document from the Data tab.
  B. The formula can be reused to create a variable.
  C. The formula can be saved into a new function.
  D. The formula can be saved and reused in a measure object.
  B. The formula can be reused to create a variable.

• Question 226:

  In which two situations should you use sub-queries? There are 2 correct answers to this question. Response:

  A. When the query filter involves values that are known
  B. When the query filter involves values that are not known
  C. When the query filter for the report involves a value that will change over time
  D. When the query filter for the report involves a value that will never change over time
  B. When the query filter involves values that are not known
  C. When the query filter for the report involves a value that will change over time

• Question 227:

  Where do you view merged dimensions? Please choose the correct answer. Response:

  A. In the Report Map pane
  B. In the Available Objects pane
  C. In the Document Structure and Filters pane
  D. In the Query panel
  B. In the Available Objects pane

• Question 228:

  Which three statements are true of contexts? There are 3 correct answers to this question. Response:

  A. Contexts are defined in a report.
  B. Contexts are defined in a universe.
  C. You can combine objects in different contexts.
  D. You can combine any objects within the same context to create a query.
  B. Contexts are defined in a universe.
  C. You can combine objects in different contexts.
  D. You can combine any objects within the same context to create a query.

• Question 229:

  From the following identify which of the option is not a method to copy a chart from Web Intelligence to a target application?

  Please choose the correct answer.

  Response:

  A. Right-click the chart, and, from the contextual menu, select Copy.
  B. In the target document, right-click the section cell and, from the contextual menu, click Copy
  C. In the target document, right-click the area where you want the table to appear and, from the contextual menu, select Paste
  D. Drag and drop the table from Web Intelligence to the target application
  B. In the target document, right-click the section cell and, from the contextual menu, click Copy

• Question 230:

  Which two statements are true about Page Layout of a report?

  There are 2 correct answers to this question.

  Response:

  A. It displays the definition of the block.
  B. It displays the report page by default.
  C. It defines what the report will look like when printed.
  D. It defines what the report will look like in PDF mode.
  C. It defines what the report will look like when printed.
  D. It defines what the report will look like in PDF mode.