SAP SAP Certifications C_BOWI_42 Questions & Answers

• Question 131:

  Which two statements are correct about saving documents?

  There are 2 correct answers to this question.

  Response:

  A. They are stored in folders.

  B. They are stored in categories.

  C. They can be assigned to a folder.

  D. They can be assigned to a category.

  Correct Answer: AD

• Question 132:

  Elucidate the advantages of saving formulas as variables?

  Please choose the correct answer.

  Response:

  A. Use as options available in the Format and Report Element toolboxes

  B. You can reuse the formula without having to enter it each time

  C. Create the formulas and feed it with all its dimensions

  D. Use variables in any report within the document

  Correct Answer: C

• Question 133:

  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.

  Correct Answer: D

• Question 134:

  Which property do you enable to keep rows in a break together on the same page?

  Please choose the correct answer.

  Response:

  A. The "Start on New Page" property in the Format Section.

  B. The "Start on New Page" property.

  C. The "Avoid page breaks in block" property.

  D. The "Avoid page break" property in the Format Section.

  Correct Answer: C

• Question 135:

  Which operators can be used in an Input calculation context?

  There are 2 correct answers to this question.

  Response:

  A. Input

  B. ForAll

  C. ForEach

  D. In

  Correct Answer: CD

• Question 136:

  Which three features can you use in Interactive View mode of BusinessObjects Web Intelligence 4.0?

  There are 3 correct answers to this question.

  Response:

  A. Sort

  B. Filters

  C. Format Cell

  D. Merge Dimensions

  Correct Answer: ABC

• Question 137:

  List the different ways you can use to display professional reports by using Web Intelligence document features? There are 3 correct answers to this question Response:

  A. As a double-block report containing large amounts of data

  B. As a folder containing large amounts of data

  C. As a table (horizontal, vertical, form or cross table)

  D. As a chart (bar, box, column, line, map, pie, point, radar or tag cloud)

  E. As a multiple-block report containing large amounts of data

  Correct Answer: CDE

• Question 138:

  Which method should you use to view alerts in a report?

  Please choose the correct answer.

  Response:

  A. Open "Query View"

  B. Click Tools > Alerters and select "View Alerters"

  C. Right-click anywhere in the report, select "Alerters"

  D. Select a block; on the toolbar, click the "Alerters" button

  Correct Answer: D

• Question 139:

  How many blocks can you create in a Web Intelligence document (WID)?

  Please choose the correct answer.

  Response:

  A. 1

  B. 2

  C. 4

  D. 8

  E. Unlimited

  Correct Answer: E

• Question 140:

  Which two statements are true about using the Where operator with an output context?

  There are 2 correct answers to this question.

  Response:

  A. It must contain Boolean operators.

  B. It restricts the data used to calculate the measure expression.

  C. It modifies the WHERE clause of the SQL generated to calculate the measure expression.

  D. It is not necessary to place parentheses around the values listed after the Where operator.

  Correct Answer: AB