SAP C_BOWI_42 Online Practice Questions and Exam Preparation

SAP C_BOWI_42 Online Questions & Answers

• Question 41:

  What happens when you create a section in a report? (2 answers)

  A. Blocks in the report are repeated for each section value.
  B. Header and footer cells are created for each section value.
  C. Free-standing cells are created to label each section value.
  D. Page breaks are created to divide each section value.
  A. Blocks in the report are repeated for each section value.
  C. Free-standing cells are created to label each section value.

• Question 42:

  Which two statements are correct about saving documents?

  There are 2 correct answers to this question.

  Response:

  A. They are stored in folders.
  B. They are stored in categories.
  C. They can be assigned to a folder.
  D. They can be assigned to a category.
  A. They are stored in folders.
  D. They can be assigned to a category.

• Question 43:

  What is the required argument of the UserResponse( ) function?

  A. Report name
  B. Dimension
  C. Prompt_string
  D. Measure
  C. Prompt_string

• Question 44:

  How does the ForEach operator affect the default calculation context?

  A. Filters dimension(s).
  B. Add dimension(s).
  C. Replaces dimension(s).
  D. Removes dimension(s).
  B. Add dimension(s).

• Question 45:

  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])
  B. Right([Product Name]; 5)

• Question 46:

  Which two search criteria are valid when using Delegated List of Values?

  There are 2 correct answers to this question.

  Response:

  A. a*
  B. *a
  C. a%
  D. %a
  A. a*
  B. *a

• Question 47:

  Which of the following is not a step of demonstration, to display an aggregate within a sectioned report.

  Please choose the correct answer.

  Response:

  A. Click a detail row in the Sales revenue column
  B. Click the Table, Chart or Others tab
  C. Click the Analysis Toolbox
  D. Click the Functions Tab
  B. Click the Table, Chart or Others tab

• Question 48:

  Name the types of query filters that you can use in Web Intelligence?

  There are 3 correct answers to this question

  Response:

  A. Validate query filter
  B. Designer query filters
  C. Predefined query filters
  D. Single and multi-value filters
  E. Prompted filters
  C. Predefined query filters
  D. Single and multi-value filters
  E. Prompted filters

• Question 49:

  What happens if an operational prompt is blank when you execute a query?

  A. The query is filtered by the default value of the prompt.
  B. The query returns an empty record set.
  C. The query filter is ignored.
  D. The query is filtered by the last value selected.
  C. The query filter is ignored.

• Question 50:

  Which two statements are true of the Web Intelligence default behavior when performing a UNION combined query method?

  There are 2 correct answers to this question.

  Response:

  A. It performs a UNION.
  B. It performs a UNION ALL.
  C. It returns all values less the duplicates.
  D. It returns all values including the duplicates.
  A. It performs a UNION.
  C. It returns all values less the duplicates.