SAP C_BOWI_42 Online Practice Questions and Exam Preparation

SAP C_BOWI_42 Online Questions & Answers

• Question 91:

  Which two operators are available when using wildcards in a query filter? (Choose two.)

  A. Different from Pattern
  B. Matches Pattern
  C. Not equals Pattern
  D. LIKE
  A. Different from Pattern
  B. Matches Pattern

• Question 92:

  Which two personal folders are available by default to Web Intelligence users?

  There are 2 correct answers to this question.

  Response:

  A. Inbox
  B. My Favorites
  C. My Documents
  D. Personal Documents
  A. Inbox
  B. My Favorites

• Question 93:

  You have two columns: order date and ship date. How do you calculate the processing time from the order date to the ship date?

  A. Use the "daysbetween" function with order date and ship date.
  B. Use the "currentdate" function and subtract the ship date.
  C. Use the "isdate" function on both dates and subtract the dates.
  D. Use the "daynumberofyear" function after subtracting both dates.
  A. Use the "daysbetween" function with order date and ship date.

• Question 94:

  Where can you use a free-standing cell?

  A. In a chart
  B. In a table
  C. In the query panel
  D. In a section
  D. In a section

• Question 95:

  Which two are calculation context types? There are 2 correct answers to this question. Response:

  A. Input
  B. Output
  C. Logical
  D. Conditional
  A. Input
  B. Output

• Question 96:

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

  There are 3 correct answers to this question.

  Response:

  A. Values within the function must be in quotes.
  B. The function can be used to create a variable.
  C. The function can contain an aggregate function.
  D. Then and Else keywords can be used within the function instead of the semicolon.
  B. The function can be used to create a variable.
  C. The function can contain an aggregate function.
  D. Then and Else keywords can be used within the function instead of the semicolon.

• Question 97:

  Which two properties can you set in the hyperlink dialog box when you create a hyperlink to a document?

  There are 2 correct answers to this question.

  Response:

  A. Refresh on open
  B. Color and font style for the link
  C. Drill level for the target document
  D. Link to a specific area in the document
  A. Refresh on open
  D. Link to a specific area in the document

• Question 98:

  You are asked to create a table to display revenue data in three distinct colors. What must you create in a single conditional formatting rule?

  A. Multiple Else conditions
  B. A single formula using the IF function
  C. Multiple predefined filters
  D. A single formula using the WHERE operator
  A. Multiple Else conditions

• Question 99:

  Which two are benefits of creating queries from existing queries?

  There are 2 correct answers to this question.

  Response:

  A. Improved query security
  B. Accurate duplication of query parameters
  C. Improved performance of query execution
  D. Reduced creation time for complex reports
  B. Accurate duplication of query parameters
  D. Reduced creation time for complex reports

• Question 100:

  Where in a Web Intelligence report do you view merged objects in BusinessObjects Web Intelligence XI 4.x?

  Please choose the correct answer.

  Response:

  A. Report Properties tab
  B. Data tab
  C. Navigation tab
  D. Object Properties tab
  B. Data tab