SAP SAP BO C_BOWI_41 Questions & Answers

• Question 1:

  In what application mode can you freeze column headers?

  A. Data

  B. Design, With Data

  C. Reading

  D. Design, Structure Only

  Correct Answer: C

• Question 2:

  Which statement is true of the Where operator when used within a variable?

  A. It instructs the variable to calculate only where certain values are true.

  B. It modifies the HAVING clause of the SQL generated to calculate the measure expression.

  C. It modifies the WHERE clause of the SQL generated to calculate the measure expression.

  D. It is not necessary to place parentheses around the values listed after the Where operator.

  Correct Answer: A

• Question 3:

  You need to create a report that compares data to a reference data set. You create the report and activate the track data option. The report correctly indicates the changes in the data; however when you make another change to the report, the display no longer indicates any data tracking.

  What actions could have caused this behavior?

  A. You drilled outside the scope of analysis.

  B. You activated query drill mode.

  C. You added a report break.

  D. You added a chart to the report

  Correct Answer: AB

• Question 4:

  Which method can you use to build a custom sort?

  A. Right-click the table, select "Custom Sort"

  B. Right-click the table, select "Sort" and select "Custom Sort"

  C. Select a column; on the toolbar, click the "Custom Sort" button

  D. Select a column; on the toolbar, click the "Apply Sort" button and select "Custom Sort"

  Correct Answer: D

• Question 5:

  Which three are prerequisites for combining data from multiple data providers?

  A. There are two or more queries in your document.

  B. Both data providers must have the same dimension values.

  C. Data values from each linked dimension must have a common format.

  D. Object name from different universes in both data providers must be the same.

  Correct Answer: ABC

• Question 6:

  Which three data sources can you synchronize in a Web Intelligence 4.0 document (WID)?

  A. Personal data files

  B. Stored procedure data source

  C. Queries from the same universe

  D. Queries from different universes

  Correct Answer: ACD

• Question 7:

  Which tab should you use to change the page orientation of a report?

  A. Click File > Page Setup and select "Page Orientation"

  B. In InfoView Preferences, change the default page orientation

  C. Select the report tab; in Report Manager, select the "Properties" tab and select the "Page Orientation"

  D. Select the report page; in Report Manager, select the "Properties" tab and select the "Page Orientation"

  Correct Answer: D

• Question 8:

  Which three object types can you use in a Web Intelligence universe query?

  A. Class

  B. Detail

  C. Measure

  D. Dimension

  E. User Defined

  Correct Answer: BCD

• Question 9:

  You are reviewing a report with the following statement in a variable:

  =If([Sales revenue] > 750000) Then "Top Performer" Else If([Sales revenue] Between (200000;650000)) Then "Average Performer" Else If ([Sales revenue] < 200000) Then "Low Performer"

  Which statement is true of the results produced by the statement for sales representatives with sales between 650,000 and 750,000?

  A. They will be Top Performers.

  B. They will be Average Performers.

  C. They will not be included in the report.

  D. They will not have a performance value assigned.

  Correct Answer: D

• Question 10:

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

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

  Correct Answer: C