SAP SAP Certifications C_BOWI_41 Questions & Answers

• Question 51:

  Which options can you select when you save a Web Intelligence document (WID)?

  A. Refresh on open

  B. Associate universe

  C. Permanent regional formatting

  D. Send to users

  Correct Answer: AC

• Question 52:

  You are working with a previously saved document and you have deleted a logical operator. Which two methods can you use to recover the logical operator?

  A. Rebuild the filters.

  B. Click the Undo button in the Query panel.

  C. From the Tools menu, select Recover Operator.

  D. Close the Query panel without executing and then open the query.

  Correct Answer: AD

• Question 53:

  Which three features can you use in Interactive View mode of BusinessObjects Web Intelligence 4.0?

  A. Sort

  B. Filters

  C. Format Cell

  D. Merge Dimensions

  Correct Answer: ABC

• Question 54:

  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.00

  B. 1.05

  C. 1.10

  D. 1.15

  E. 1.18

  Correct Answer: A

• Question 55:

  Where should you configure the regional settings of a Web Intelligence document (WID) within InfoView?

  A. Local Settings

  B. Browser Preferences

  C. User Machine Settings

  D. InfoView Preferences

  Correct Answer: D

• Question 56:

  What happens when you drop a dimension into a blank part of a report that contains two blocks, without the ALT key selected?

  A. A new block is created.

  B. A new section is created.

  C. An error message is displayed.

  D. The currently selected cell is displayed.

  Correct Answer: B

• Question 57:

  Which two methods can you use to aggregate measures at the section level in BusinessObjects Web Intelligence 4.0?

  A. Drag the measure from the Data tab into the section header.

  B. Copy the measure from the Data tab into the section header.

  C. While pressing the ALT key, drag the measure from the table to the section header.

  D. While pressing the CTRL key, drag the measure from the table to the section header.

  Correct Answer: AD

• Question 58:

  Which DaysBetween() function syntax should you use to calculate the number of years since your birth, assuming the date object is Birth_date?

  A. =DaysBetween([Birth_date] ; CurrentDate ) / 365.25

  B. =DaysBetween([Birth_date] , CurrentDate() ) / 365.25

  C. =DaysBetween([Birth_date] ; CurrentDate() ) / 365.25

  D. =DaysBetween(CurrentDate() ; [Birth_date] ) / 365.25

  Correct Answer: C

• Question 59:

  You are creating a "Target Revenue Based on Required % Growth" variable that is represented by 5% revenue growth for California and 18% for Massachusetts.

  Which If() function statement is valid?

  A. =If[State] = "California" Then [Sales revenue] * 1.05 Else[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue]

  B. =If[State] = "California" Then [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue]

  C. =If[State] = "California" ; [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue]

  D. =If[State] = "California" Then [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue] End

  Correct Answer: B

• Question 60:

  Which method should you use to view alerts in a report?

  A. Open "Query View"

  B. Click Tools > Alerters and select "View Alerters"

  C. Right-click anywhere in the report, select "Alerters"

  D. Select a block; on the toolbar, click the "Alerters" button

  Correct Answer: D