SAP SAP Certifications C_BOWI_42 Questions & Answers

• Question 161:

  You set the drill option "Prompt when drill requires additional data". Now you drill outside the scope of analysis on your report.

  How does Web Intelligence respond?

  Please choose the correct answer.

  Response:

  A. It prompts you to choose a hierarchy level and waits for your response before retrieving the data.

  B. It notifies you that it needs to retrieve additional data to complete the drill and retrieves the data.

  C. It inserts a prompted query filter in the query and reruns the query.

  D. It inserts a prompted report filter on the report and refreshes the report view.

  Correct Answer: A

• Question 162:

  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.

  Correct Answer: BCD

• Question 163:

  Which Report Manager tab should you use to change report formatting?

  Please choose the correct answer.

  Response:

  A. Map

  B. Data

  C. Properties

  D. Templates

  Correct Answer: C

• Question 164:

  Which three calculations can you use in a measure object in Web Intelligence?

  There are 3 correct answers to this question.

  Response:

  A. Min

  B. Max

  C. Count

  D. Count All

  Correct Answer: ABC

• Question 165:

  Which of the following is not a step of demonstration, to display an aggregate within a sectioned report.

  Please choose the correct answer.

  Response:

  A. Click a detail row in the Sales revenue column

  B. Click the Table, Chart or Others tab

  C. Click the Analysis Toolbox

  D. Click the Functions Tab

  Correct Answer: B

• Question 166:

  Which two are running aggregate functions in Web Intelligence?

  There are 2 correct answers to this question.

  Response:

  A. RunningMax()

  B. RunningSum()

  C. RunningTotal()

  D. RunningMean()

  Correct Answer: AB

• Question 167:

  Discuss all the advantages link to organizing a report in the section There are 2 correct answers to this question Response:

  A. You can have multiple blocks projected from the same microcube within a single report, all sub-grouped to the sectioned level

  B. You can have single block projected from the same microcube within a single report, all grouped to the sectioned level

  C. You can insert subtotal cells, repeated in each section, which are created by the simple process of drag and drop

  D. You can insert tables, different in each section, which are created by the simple process of drag and drop

  Correct Answer: AC

• Question 168:

  Which three data sources can you synchronize in a Web Intelligence 4.0 document (WID)?

  There are 3 correct answers to this question.

  Response:

  A. Personal data files

  B. Stored procedure data source

  C. Queries from the same universe

  D. Queries from different universes

  Correct Answer: ACD

• Question 169:

  What is the default behavior when creating a report from two queries from the same universe?

  Please choose the correct answer.

  Response:

  A. Result produces two table blocks.

  B. Dimension objects are automatically merged.

  C. Results are shown on two different report tabs.

  D. Dimension objects are not automatically merged.

  Correct Answer: B

• Question 170:

  Which two are benefits of using breaks? There are 2 correct answers to this question. Response:

  A. Creates a navigation map

  B. Makes the table block easier to read

  C. Splits the block into smaller table blocks

  D. Enables the use of subtotals in one block

  Correct Answer: BD