SAP C_BOWI_42 Online Practice Questions and Exam Preparation

SAP C_BOWI_42 Online Questions & Answers

• Question 61:

  Where is a Web Intelligence variable stored? Please choose the correct answer. Response:

  A. In the cell
  B. In the document
  C. In the Metadata Cube
  D. In the Central Management Server (CMS)
  B. In the document

• Question 62:

  Which character should you use to reset the result of the RunningSum( ) function for either a break or a section?

  Please choose the correct answer.

  Response:

  A. Semicolon (;)
  B. Percent (%)
  C. Underscore (_)
  D. Comma (,)
  A. Semicolon (;)

• Question 63:

  A variable in your report contains the statement:

  =If[State] = "California" Then [Sales revenue] * 1.05 Else If[State] = "Colorado" Then [Sales revenue] *

  1.1 Else If[State] InList ("DC";"Texas ") Then [Sales revenue] * 1.15 Else If[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue]

  Sales revenue for Florida is $1,879,159. Which rate is applied to the Florida revenue by the formula?

  Please choose the correct answer.

  Response:

  A. 1.00
  B. 1.05
  C. 1.10
  D. 1.15
  E. 1.18
  A. 1.00

• Question 64:

  Which panel should you use to view a Document Summary of a BusinessObjects Web Intelligence 4.0 document (WID)?

  Please choose the correct answer.

  Response:

  A. Advanced
  B. Query
  C. Active X
  D. Interactive
  D. Interactive

  ---

  Explanation/Reference:

• Question 65:

  What does the ranking calculation mode Cumulative Percentage keep in the block?

  A. The top/bottom values until the sum reaches a specified percentage of the total.
  B. The top/bottom number of rows based on the measure.
  C. The top/bottom percentage of the number of rows based on the dimension.
  D. The top/bottom values until the sum reaches a specified value.
  A. The top/bottom values until the sum reaches a specified percentage of the total.

• Question 66:

  Which of these actions clear stored data when tracking data changes? (3 answers)

  A. Enable query stripping
  B. Use the query drill
  C. Drill out of scope
  D. Start the drill on a duplicate report
  E. Modify SQL
  B. Use the query drill
  C. Drill out of scope
  E. Modify SQL

• Question 67:

  What actions can you perform in the Web Intelligence query panel? (3 answers)

  A. Publish as a web service.
  B. Remove objects from the query.
  C. Change custom filters.
  D. Change table to chart.
  E. Rearrange objects in the query.
  B. Remove objects from the query.
  C. Change custom filters.
  E. Rearrange objects in the query.

• Question 68:

  Which two options can you change when using Quick Display Mode?

  There are 2 correct answers to this question.

  Response:

  A. Limit Query Results
  B. Sample Query Results
  C. Vertical Records Per Page
  D. Horizontal Records Per Page
  C. Vertical Records Per Page
  D. Horizontal Records Per Page

• Question 69:

  Which methods can you use to apply report filters to a BusinessObjects Web Intelligence XI 4.x document (WID)?

  There are 2 correct answers to this question.

  Response:

  A. Global
  B. Block
  C. Dynamic
  D. Custom
  A. Global
  B. Block

• Question 70:

  Which of the following option is not a part of The Web Intelligence Query Process?

  Please choose the correct answer.

  Response:

  A. Run the query
  B. Launch panel to generate data
  C. SQL is executed to extract data
  D. Report is displayed
  B. Launch panel to generate data