SAP Certified Application Associate - SAP BusinessObjects Web Intelligence 4.1

QUESTION NO: 1
Which three are drill options?

A. Prompt if drill requires additional data B. Hide drill toolbar C. Synchronize drill on report blocks D. Show drill filters

Correct Answer: A,B,C

QUESTION NO: 2
Which two statements are true of grouping sets when using smart measures?

A. The generated SQL includes grouping sets for all the aggregations of that dimension that are included in the report. B. It is a set of measures that generates a result for a dimension. C. It is a set of dimensions that generates a result for a measure. D. The generated SQL includes grouping sets for all the aggregations of that measure that are included in the report.

Correct Answer: C,D

QUESTION NO: 3
Which two personal folders are available by default to Web Intelligence users?

A. My Favorites B. Personal Documents C. Inbox D. My Documents

Correct Answer: A,C

QUESTION NO: 4
Which four Report Elements can you select from the Templates tab of Web Intelligence? There are 4 correct answers to this question.

A. Free-standing cells B. Tables C. Report D. Charts E. Data

Correct Answer: A,B,C,D

QUESTION NO: 5
Which three layout options can you use when creating sections in a report?

A. Start on New Page B. Keep Blocks Together C. Avoid Page Break in Section D. Relative Position

Correct Answer: A,C,D

QUESTION NO: 6
Which two are benefits of using breaks?

A. Makes the table block easier to read B. Splits the block into smaller table blocks C. Enables the use of subtotals in one block D. Creates a navigation map

Correct Answer: A,C

QUESTION NO: 7
Which Pos() function syntax should you use to find the location of the space in the Category string "Evening wear"?

A. Pos([Category] , "" ) B. Pos({Category} ; " " ) C. Pos([Category] ; " " ) D. Pos((Category) , "" )

Correct Answer: C

QUESTION NO: 8
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 exclude the dimension using the input context. B. You exclude the dimension using the output context. C. You include the dimension using the output context. D. You include the dimension using the input context.

Correct Answer: B

QUESTION NO: 9
A variable in your report contains the statement: =If[State] = "California" Then [Sales revenue] * 1.05 Else If[State] = "Colorado" Then [Sales revenue] *
1.1 Else If[State] InList ("DC";"Texas ") Then [Sales revenue] * 1.15 Else If[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue]
Sales revenue for Florida is $1,879,159. Which rate is applied to the Florida revenue by the formula?

A. 1.05 B. 1.18 C. 1.15 D. 1.10 E. 1.00

Correct Answer: E

SAP Certified Application Associate - SAP BusinessObjects Web Intelligence 4.1 - C_BOWI_41 Exam Questions