SAP SAP BO C_BOWI_41 Questions & Answers

• Question 11:

  Which two statements are true of grouping sets when using smart measures?

  A. It is a set of dimensions that generates a result for a measure.

  B. It is a set of measures that generates a result for a dimension.

  C. The generated SQL includes grouping sets for all the aggregations of that dimension that are included in the report.

  D. The generated SQL includes grouping sets for all the aggregations of that measure that are included in the report.

  Correct Answer: AD

• Question 12:

  Which data sources can you access directly using Web Intelligence?

  A. Relational databases

  B. XML files

  C. Business Explorer (BEx) Queries

  D. OLAP cubes

  Correct Answer: C

• Question 13:

  For which tasks do you use an If() function?

  A. To conditionally show rows in a block

  B. To conditionally execute a scheduled report

  C. To display dynamically grouped values

  D. To display a dynamic list of values

  Correct Answer: AC

• Question 14:

  Which message appears when you select "Use query drill" while Scope of Analysis is set in aBusinessObjects Web Intelligence 4.0 report?

  A. The Scope of Analysis is empty.

  B. The Scope of Analysis is not empty.

  C. The query drill mode option is enabled.

  D. The query drill mode option is not enabled.

  Correct Answer: B

• Question 15:

  How does rearranging the objects in the Result pane after the query has run affect the block display?

  A. The objects are rearranged in the block based on the order in the Results Objects pane.

  B. The reordered objects are removed from the block.

  C. The block is sorted in ascending order based on the first object in the Results Objects pane.

  D. The block remains unchanged.

  Correct Answer: D

• Question 16:

  Which three options appear in the Scope of Analysis pane in the Query panel?

  A. None

  B. Default

  C. Custom

  D. One Level

  Correct Answer: ACD

• Question 17:

  Which two settings can you configure for the Sample option in the Properties tab of the Web Intelligence Query panel?

  A. You can enable the "Fixed" option.

  B. You can set the "Max retrieval time".

  C. You can set the "Max rows retrieved".

  D. You can specify a "Sample Result" set.

  Correct Answer: AD

• Question 18:

  You want to compare the sales revenue performance of the top 20% of your customers to the average of all of your customers. You decide to apply a rank on the table that shows customers and revenue and create a variable to show the average revenue for all customers.

  Which function should you use in the variable?

  A. NoFilter()

  B. NoRank()

  C. AverageAll()

  D. IgnoreFilter()

  Correct Answer: A

• Question 19:

  Which option can you use to convert a table block into a chart in Web Intelligence Rich Client?

  A. Right-click the table block and select "Turn To"

  B. Click Format > Charts and select "Convert to Chart"

  C. Right-click the table block and select "Convert to Chart"

  D. Click Tools > Charts and select "Change Table to Chart"

  Correct Answer: A

• Question 20:

  Which type of relationship links sub-queries by default?

  A. OR

  B. AND

  C. NOR

  D. NAND

  Correct Answer: B