SAP SAP Certifications C_BOWI_42 Questions & Answers

• Question 101:

  Which methods can you use to apply report filters to a BusinessObjects Web Intelligence XI 4.x document (WID)?

  There are 2 correct answers to this question.

  Response:

  A. Global

  B. Block

  C. Dynamic

  D. Custom

  Correct Answer: AB

• Question 102:

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

  Please choose the correct answer.

  Response:

  A. Right(5; [Product Name])

  B. Right([Product Name]; 5)

  C. Right((Product Name), 5)

  D. Right(5, [Product Name])

  Correct Answer: B

• Question 103:

  Which of the following is not a rule to apply on the report elements?

  Please choose the correct answer.

  Response:

  A. Columns in vertical tables

  B. Rows in horizontal tables

  C. Cells in conditional tables

  D. Cells in forms and cross tables

  Correct Answer: C

• Question 104:

  What is the purpose of Demonstration: To Create a Simple Web Intelligence Document?

  Please choose the correct answer.

  Response:

  A. To give the learner a quick overview of the process

  B. Explain that learners can choose single data source, but that you are using a class for this demonstration

  C. To give the learner an opportunity to practice these texts

  D. Launch the Web Intelligence work application, and briefly, explain the different codes

  Correct Answer: A

• Question 105:

  Which two statements are correct about hierarchies in Web Intelligence?

  There are 2 correct answers to this question.

  Response:

  A. They can be created using the Query panel.

  B. They can be created in the Scope of Analysis panel.

  C. They can be chosen using a custom Scope of Analysis.

  D. They are used to define the drill path in the Scope of Analysis.

  Correct Answer: CD

• Question 106:

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

  There are 3 correct answers to this question.

  Response:

  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 107:

  Which statement describes the performance impact that data tracking has on report refresh times, assuming that the data changes but the number of rows retrieved and the data volume stays the same?

  Please choose the correct answer.

  Response:

  A. It will refresh up to three times faster.

  B. It will refresh up to three times slower.

  C. It will refresh faster each time the report is refreshed.

  D. It will refresh slower each time the report is refreshed.

  Correct Answer: B

• Question 108:

  For which tasks do you use an If() function? There are 2 correct answers to this question. Response:

  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 109:

  Which two statements about the If() function are correct?

  There are 2 correct answers to this question.

  Response:

  A. Can contain a SQL statement

  B. Can contain a Case expression

  C. Contains a Boolean expression

  D. Can contain nested If() statements

  Correct Answer: CD

• Question 110:

  Which three options are Web Intelligence drill mode options?

  There are 3 correct answers to this question.

  Response:

  A. Drill By

  B. Drill Up

  C. Drill Down

  D. Drill Through

  Correct Answer: ABC