SAP SAP Certifications C_BOWI_42 Questions & Answers

• Question 121:

  Which panel should you use to view a Document Summary of a BusinessObjects Web Intelligence 4.0 document (WID)?

  Please choose the correct answer.

  Response:

  A. Advanced

  B. Query

  C. Active X

  D. Interactive

  Correct Answer: D

• Question 122:

  Discuss the components of a Web Intelligence Document?

  There are 2 correct answers to this question

  Response:

  A. One or more reports

  B. One or more blocks

  C. One or more filters

  D. One or more Pattern

  Correct Answer: AB

• Question 123:

  You use the Last Refresh Date cell from the Templates in the Report Manager on your report page. You then reformat the cell as Tuesday, January 22, 2014. What is the result when you edit the formula, using the Formula toolbar, to

  concatenate the string "Last Refresh Date: " and the LastExecutiondate() function?

  Please choose the correct answer.

  Response:

  A. The cell reads "Last Refresh Date: 1/22/14".

  B. The "Computation Error" error message is displayed.

  C. The "Incompatible Data Types" error message is displayed.

  D. The cell reads "Last Refresh Date: {Tuesday, January 22, 2014}".

  Correct Answer: A

• Question 124:

  You are working with a set of store revenues. All stores have positive revenue values. Which formula should you use to display the variance value of the Revenue measure in your document when data tracking is active?

  Please choose the correct answer.

  Response:

  A. =[Revenue]/RefValue([Revenue])

  B. =[Revenue]/PreValue([Revenue])

  C. =[Revenue]/HistValue([Revenue])

  D. =[Revenue]/BaseValue([Revenue])

  Correct Answer: A

• Question 125:

  Where is a Web Intelligence variable stored? Please choose the correct answer. Response:

  A. In the cell

  B. In the document

  C. In the Metadata Cube

  D. In the Central Management Server (CMS)

  Correct Answer: B

• Question 126:

  What are the terms you need to be familiar with to understand how semantic layer functions for relational databases?

  There are 3 correct answers to this question

  Response:

  A. Units

  B. Object

  C. Class

  D. Universe

  E. Code

  Correct Answer: BCD

• Question 127:

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

  There are 2 correct answers to this question.

  Response:

  A. Left()

  B. LeftPad()

  C. LeftTrim()

  D. Concatenate()

  Correct Answer: BD

• Question 128:

  Which two break properties can you use when setting Break Priority?

  There are 2 correct answers to this question.

  Response:

  A. Order Breaks

  B. Vertical Breaks

  C. Crosstab Breaks

  D. Horizontal Breaks

  Correct Answer: BD

• Question 129:

  Which statement is a benefit of using a Web Intelligence formula?

  Please choose the correct answer.

  Response:

  A. The formula can be reused in a document from the Data tab.

  B. The formula can be reused to create a variable.

  C. The formula can be saved into a new function.

  D. The formula can be saved and reused in a measure object.

  Correct Answer: B

• Question 130:

  Which statement is true of an output context operator?

  Please choose the correct answer.

  Response:

  A. It is placed within the brackets of the dimension list.

  B. It is placed outside of the brackets of the dimension list.

  C. It is placed within the brackets of the aggregation function.

  D. It is placed outside of the brackets of the aggregation function.

  Correct Answer: D