SAP SAP Certifications C_BOWI_42 Questions & Answers

• Question 211:

  Which of the following make up a semantic layer for a rational data source? (3 answers)

  A. Measure

  B. Dimension

  C. Section

  D. Universe

  E. Block

  Correct Answer: ABD

• Question 212:

  What operator do you select to use a wildcard character in a Web Intelligence query?

  A. Equal to

  B. In list

  C. Matches pattern

  D. Except

  Correct Answer: C

• Question 213:

  What is the output of the following expression when the CurrentDate is January 31, 2014?

  If (MonthNumberOfYear(CurrentDate()) = l;

  Year(CurrentDate())-l;

  Year(CurrentDate()))

  A. 01/31/2014

  B. 2014

  C. 01/31/2013

  D. 2013

  Correct Answer: D

• Question 214:

  How do you determine if a formula or a variable is used in a block? (2 answers)

  A. Change the application mode to Reading

  B. Select the block, right click and select Format Table

  C. Change the application mode to Design and select Structure Only

  D. Select the cell and view the formula toolbar

  Correct Answer: CD

• Question 215:

  You have added additional query to a document. What happens when you choose "Include the result objects in the document without generating a table"?

  A. Existing blocks are updated with the new objects.

  B. New result objects are added to the existing query.

  C. New result objects are projected into a new report.

  D. Existing blocks remain intact.

  Correct Answer: D

• Question 216:

  Where can you use a free-standing cell?

  A. In a chart

  B. In a table

  C. In the query panel

  D. In a section

  Correct Answer: D

• Question 217:

  You are asked to create a table to display revenue data in three distinct colors. What must you create in a single conditional formatting rule?

  A. Multiple Else conditions

  B. A single formula using the IF function

  C. Multiple predefined filters

  D. A single formula using the WHERE operator

  Correct Answer: A

• Question 218:

  What is the input context of a calculation?

  A. The dimension used to define the calculation

  B. The prompt values used in query

  C. The aggregate function of the calculation

  D. The measure being calculated

  Correct Answer: A

• Question 219:

  How can you make the pie chart (shown in the attached graphic) display correctly?

  A. Change to the Design - With Data application mode.

  B. Change to the Reading application mode.

  C. Drag a dimension or attribute on to the chart

  D. Drag a measure on to the chart

  Correct Answer: D

• Question 220:

  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.

  Correct Answer: B