SAP SAP Certifications C_BOWI_41 Questions & Answers

• Question 101:

  You are using calculation contexts within an If() function. Which two are valid contexts for use in an If() function?

  A. In Cell

  B. In Row

  C. In Block

  D. In Report

  Correct Answer: CD

• Question 102:

  Which two functions can you use to concatenate the strings "England" and "New" to create the string "New England"?

  A. Left()

  B. LeftPad()

  C. LeftTrim()

  D. Concatenate()

  Correct Answer: BD

• Question 103:

  Which two are benefits of using breaks?

  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

• Question 104:

  You want to force the calculation context of a variable in a table so thatits values do not change when adimension is added to the table.

  Which of the following statements is correct?

  A. You include the dimension using the input context.

  B. You exclude the dimension using the input context.

  C. You include the dimension using the output context.

  D. You exclude the dimension using the output context.

  Correct Answer: D

• Question 105:

  You insert the function CurrentDate() into a cell. To clarify the date you add a string so that the formula is now: ="Sales Report from "+CurrentDate()

  Which formatting capability is disabled for the cell?

  A. Format cell

  B. Hide cell

  C. Align text

  D. Format number

  Correct Answer: D

• Question 106:

  Which three are drill options?

  A. Hide drill toolbar

  B. Show drill filters

  C. Prompt if drill requires additional data

  D. Synchronize drill on report blocks

  Correct Answer: ACD

• Question 107:

  How much impact does data tracking have on the data size of a Web Intelligence document (WID) Compared to the same document without data tracking?

  A. It will stay the same size.

  B. It will increase two times.

  C. It will increase three times.

  D. It will increase by 50% on each refresh.

  Correct Answer: B

• Question 108:

  Which three methods can you use to combine queries using the Web Intelligence Rich Client?

  A. UNION

  B. MINUS

  C. UNION ALL

  D. INTERSECT

  Correct Answer: ABD

• Question 109:

  Which two search criteria are valid when using Delegated List of Values?

  A. a*

  B. *a

  C. a%

  D. %a

  Correct Answer: AB

• Question 110:

  Which operators can be used in an Input calculation context?

  A. Input

  B. ForAll

  C. ForEach

  D. In

  Correct Answer: CD