SAP C_BOWI_42 Online Practice Questions and Exam Preparation

SAP C_BOWI_42 Online Questions & Answers

• Question 211:

  You have created a BusinessObjects Web Intelligence 4.0 document (WID) within InfoView that has a single table block on a single report page. Where will a new object be displayed when you add it to the query?

  Please choose the correct answer.

  Response:

  A. In a block
  B. In a new report
  C. In Query Panel
  D. In Report Manager
  E. In a new report page
  D. In Report Manager

• Question 212:

  Which tool do you use to edit merged objects in BusinessObjects Web Intelligence 4.0?

  Please choose the correct answer.

  Response:

  A. The Data tab of the Document Properties
  B. The Edit Dimensions button on the Reporting toolbar
  C. The Merge Dimensions button on the Reporting toolbar
  D. The Object Properties in the Data tab of the Report Manager
  C. The Merge Dimensions button on the Reporting toolbar

• Question 213:

  Which of the following options involved to Create Variable from the Formula?

  There are 2 correct answers to this question

  Response:

  A. Select the cell that contains the formula
  B. Double-click Formula bar and click OK
  C. Click the Create Variable and Select the Formula bar
  D. On the Formula bar, click Create Variable
  A. Select the cell that contains the formula
  D. On the Formula bar, click Create Variable

• Question 214:

  To which destinations can you send a Web Intelligence document (WID) through InfoView of BusinessObjects Web Intelligence XI 4.0?

  There are 3 correct answers to this question.

  Response:

  A. Broadcast Agent
  B. Business Objects Inbox
  C. FTP
  D. Email
  E. File Server
  B. Business Objects Inbox
  C. FTP
  D. Email

• Question 215:

  Which method can you use to hide data using an alerter?

  Please choose the correct answer.

  Response:

  A. Build an alerter that removes the column.
  B. Build an alerter that applies a formula that changes the block value.
  C. Build an alerter with a formula that changes the font color to the background color.
  D. Click anywhere in the document. On the toolbar, click the "Data" button and select "Hide Data".
  C. Build an alerter with a formula that changes the font color to the background color.

• Question 216:

  What tasks can you perform in the data application mode? (2 answers)

  A. Add a report filter
  B. Merge objects
  C. Assign chart series data
  D. Create a new data provider
  B. Merge objects
  D. Create a new data provider

• Question 217:

  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?

  Please choose the correct answer.

  Response:

  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
  B. =If[State] = "California" Then [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue]

• Question 218:

  You are creating a report to summarize the number of cars sold by region. Which object should you use to aggregate the number of cars sold?

  Please choose the correct answer.

  Response:

  A. Sum
  B. Detail
  C. Measure
  D. Dimension
  C. Measure

• Question 219:

  What is the default behavior when creating a report from two queries from the same universe?

  Please choose the correct answer.

  Response:

  A. Result produces two table blocks.
  B. Dimension objects are automatically merged.
  C. Results are shown on two different report tabs.
  D. Dimension objects are not automatically merged.
  B. Dimension objects are automatically merged.

• Question 220:

  How do you remove a custom sort that has been applied to an object?

  A. Choose the Remove button in the Manage Sorts dialog.
  B. Choose the Reset button in the Manage Sorts dialog.
  C. Delete the column containing the object.
  D. Right click the object, select Sort and then select None.
  B. Choose the Reset button in the Manage Sorts dialog.