SAP C_BOWI_42 Online Practice Questions and Exam Preparation

SAP C_BOWI_42 Online Questions & Answers

• Question 181:

  What data source can you select when creating a document using the Web Intelligence Rich Client? (2 answers)

  A. BEx Query
  B. XML files
  C. Lumira Dataset
  D. Analysis view
  A. BEx Query
  D. Analysis view

• Question 182:

  How does WHERE operator affect a formula?

  A. It determines the order of the results.
  B. It adds the dimension to the default context.
  C. It restricts the dimension used to calculate a measure.
  D. It removes the dimension from the default context.
  C. It restricts the dimension used to calculate a measure.

• Question 183:

  Which combination of functions should you use to convert the string "13/11/46 12:00:00 AM" to "Wednesday 13 Nov 1946"?

  A. Right() using Pos, ToDate(), FormatDate()
  B. SubStr() using Pos, ToDate(), FormatDate()
  C. Right() using Pos, CurrentDate(), FormatDate()
  D. SubStr() using Pos, CurrentDate(), FormatDate()
  B. SubStr() using Pos, ToDate(), FormatDate()

• Question 184:

  Which Report Manager tab should you use to add a free-standing cell to a BusinessObjects Web Intelligence 4.0 document (WID)?

  Please choose the correct answer.

  Response:

  A. Map
  B. Data
  C. Template
  D. Properties
  C. Template

• Question 185:

  You want to subtotal the data by year in a table but you do not have a location for the subtotal in the table. What must you do to create the location for the subtotal in the table?

  A. Section the report
  B. Apply a break.
  C. Format the table
  D. Insert a blank cell.
  B. Apply a break.

• Question 186:

  You have a regional sales report with State, City and Sales Revenue dimensions. You want to create a variable that excludes State from the output context. Which output statement should you use?

  Please choose the correct answer.

  Response:

  A. In([State])
  B. Out([State])
  C. ForAll([State])
  D. ForEach([State])
  C. ForAll([State])

• Question 187:

  When scheduling Web Intelligence document, what output formats are available? (2 answers)

  A. Adobe Acrobat (PDF)
  B. Microsoft PowerPoint (PPT)
  C. HyperText Markup Language (HTML)
  D. Plain Text (TXT)
  A. Adobe Acrobat (PDF)
  D. Plain Text (TXT)

• Question 188:

  Which tasks can you accomplish using breaks? There are 2 correct answers to this question. Response:

  A. Generate a running sum in multiple table blocks.
  B. Remove repeated values in one table block.
  C. Break the table into multiple table blocks.
  D. Generate subtotals in one table block.
  B. Remove repeated values in one table block.
  D. Generate subtotals in one table block.

• Question 189:

  Mention the five types of column charts for presenting DATA?

  There are 3 correct answers to this question

  Response:

  A. 4D column chart
  B. Column chart with dual values
  C. Combined column and line chart
  D. Stacked column chart
  E. Column charts with fixed contents
  B. Column chart with dual values
  C. Combined column and line chart
  D. Stacked column chart

• Question 190:

  You are reviewing a report with the following statement in a variable:

  =If([Sales revenue] > 750000) Then "Top Performer" Else If([Sales revenue] Between (200000;650000)) Then "Average Performer" Else If ([Sales revenue] < 200000) Then "Low Performer"

  Which statement is true of the results produced by the statement for sales representatives with sales between 650,000 and 750,000?

  Please choose the correct answer.

  Response:

  A. They will be Top Performers.
  B. They will be Average Performers.
  C. They will not be included in the report.
  D. They will not have a performance value assigned.
  D. They will not have a performance value assigned.