SAP C_BOWI_42 Online Practice Questions and Exam Preparation

SAP C_BOWI_42 Online Questions & Answers

• Question 71:

  What do you use to search for content in multiple documents?

  A. Central Management Console (CMC)
  B. Central Configuration Manager (CCM)
  C. BI launch pad
  D. Report map
  C. BI launch pad

• Question 72:

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

  Please choose the correct answer.

  Response:

  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.
  A. It instructs the variable to calculate only where certain values are true.

• Question 73:

  Discuss the components of a Web Intelligence Document?

  There are 2 correct answers to this question

  Response:

  A. One or more reports
  B. One or more blocks
  C. One or more filters
  D. One or more Pattern
  A. One or more reports
  B. One or more blocks

  ---

  Explanation/Reference:

• Question 74:

  Which wildcards can you use in a query filter? There are 2 correct answers to this question. Response:

  A. ?
  B. %
  D. *
  B. %

• Question 75:

  In which of the following can you use If( ) function in Web Intelligence?

  A. Prompts
  B. Input control
  C. Variables
  D. Drill filters
  C. Variables

• Question 76:

  Which panel should you use to create sub-queries?

  A. Query Panel
  B. Report Panel
  C. Data Panel
  D. Slice and Dice Panel
  A. Query Panel

• Question 77:

  Which of the following option is not a component of Web Intelligence Application Structure?

  Please choose the correct answer.

  Response:

  A. Toolboxes
  B. The Left Panel
  C. The Expand panel
  D. The Status Bar
  C. The Expand panel

• Question 78:

  Which two data sources can you directly access from a Web Intelligence document (WID) using the Web Intelligence Rich Client?

  There are 2 correct answers to this question.

  Response:

  A. Universe
  B. Text File
  C. Web Service
  D. OLAP Cube
  A. Universe
  B. Text File

• Question 79:

  In the Annual Revenue column, what formula calculates the total annual revenue in each row (shown in the attached graphic)?

  A. =sum([Sales revenues] In([Year])) In ([Quarter])
  B. =sum([Sales revenues] In([Year];[Quarter])) In ([Quarter])
  C. =sum([Sales revenues] In([Year];[Quarter]))
  D. =sum([Sales revenues] In([Year];[Quarter])) In ([Year])
  D. =sum([Sales revenues] In([Year];[Quarter])) In ([Year])

• Question 80:

  In the creation of a document, you have to import a personal data file. The data file contains date information, but when the file is imported, the dates are imported as character strings. Which function should you use to change the format from string to date?

  A. ToDate()
  B. Date()
  C. ToChar()
  D. Char()
  A. ToDate()