SAP SAP Certifications C_BOWI_42 Questions & Answers

• Question 141:

  From the following identify which of the option is not a method to copy a chart from Web Intelligence to a target application?

  Please choose the correct answer.

  Response:

  A. Right-click the chart, and, from the contextual menu, select Copy.

  B. In the target document, right-click the section cell and, from the contextual menu, click Copy

  C. In the target document, right-click the area where you want the table to appear and, from the contextual menu, select Paste

  D. Drag and drop the table from Web Intelligence to the target application

  Correct Answer: B

• Question 142:

  Which three elements are parts of a query filter? There are 3 correct answers to this question. Response:

  A. Class

  B. Object

  C. Operator

  D. Operand

  Correct Answer: BCD

• Question 143:

  Why would you need to change the data source for your query?

  Please choose the correct answer.

  Response:

  A. To change the universe connection of your universe

  B. To use the production universe instead of the test universe

  C. To use different objects from the universe

  D. To change the order of execution for existing queries

  Correct Answer: B

• Question 144:

  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?

  Response:

  A. NoFilter()

  B. NoRank()

  C. AverageAll()

  D. IgnoreFilter()

  Correct Answer: A

• Question 145:

  For what purposes can you use the Page Layout of a report?

  There are 2 correct answers to this question.

  Response:

  A. To display the definition of the block.

  B. To define how the report will look like in PDF mode.

  C. To define how the report will look like when printed.

  D. To display the report page by default.

  Correct Answer: BC

• Question 146:

  Which method should you use to group query filters together to form one AND statement? Please choose the correct answer.

  Response:

  A. Drag the queries together

  B. Drag the query filters to the Group panel

  C. Select the filters, right-click and select Group

  D. Select the filters, then click the Group Filters button on the toolbar

  Correct Answer: A

• Question 147:

  Which function would you use to extract the word "casual" from the product name "casual pants" of the Product Name field?

  Please choose the correct answer.

  Response:

  A. Left(5; [Product Name])

  B. Left([Product Name]; 5)

  C. Right((Product Name), 5)

  D. Right(5, [Product Name])

  Correct Answer: B

• Question 148:

  Your report contains a table. What happens when you drop a dimension object into a blank part of this report?

  Please choose the correct answer.

  Response:

  A. A new group is created.

  B. A new block is created.

  C. A new free-standing cell is created.

  D. A new section is created.

  Correct Answer: B

• Question 149:

  You have a regional sales report with State, City and Sales Revenue dimensions. You want to create a variable that excludes State from the output context. Which output statement should you use?

  Please choose the correct answer.

  Response:

  A. In([State])

  B. Out([State])

  C. ForAll([State])

  D. ForEach([State])

  Correct Answer: C

• Question 150:

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

  There are 2 correct answers to this question.

  Response:

  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