SAP C_BOWI_41 Online Practice Questions and Exam Preparation

SAP C_BOWI_41 Online Questions & Answers

• Question 91:

  Which reporting tool should you use to create a Web Intelligence document (WID) directly from an Excel data source?

  A. Crystal Reports
  B. Desktop Intelligence
  C. Web Intelligence in InfoView
  D. Web Intelligence Rich Client
  D. Web Intelligence Rich Client

• Question 92:

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

  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.

• Question 93:

  What is the maximum number of sub-alerts that an alerter can contain?

  A. 1
  B. 8
  C. 16
  D. 32
  B. 8

• Question 94:

  Which method should you use to store a Web Intelligence Rich Client document in an enterprise secured location?

  A. Save the document to the Enterprise directories
  B. Save the document to the Enterprise documents.
  C. Export the document to the Central Management Server (CMS).
  D. Export the document to the Central Configuration Manager (CCM).
  C. Export the document to the Central Management Server (CMS).

• Question 95:

  You open a Web Intelligence document (WID) with tracked data changes. You wish to change the color of the tracked data. You however cannot change the format of the tracked data. What should you do to enable formatting of the tracked data?

  A. Contact the system administrator.
  B. Edit the document in tracking mode.
  C. Open the document in tracking mode.
  D. Resave the document with data tracking formats enabled.
  A. Contact the system administrator.

• Question 96:

  You need to create a report displaying a year-to-date aggregation on sales revenue across all months. The report should be sectioned on Region. Additionally, you would like to reset the running aggregation to restart for each Region. Which syntax should you use to accomplish this task?

  A. =RunningSum([Sales Revenue], Region)
  B. =RunningTotal([Sales Revenue], Region)
  C. =RunningSum([Sales Revenue] ; ([Region]))
  D. =RunningTotal([Sales Revenue], Reset[Region])
  C. =RunningSum([Sales Revenue] ; ([Region]))

• Question 97:

  Which two functions can you use to concatenate the strings "England" and "New" to create the string "New England"?

  A. Left()
  B. LeftPad()
  C. LeftTrim()
  D. Concatenate()
  B. LeftPad()
  D. Concatenate()

• Question 98:

  Which three options appear in the Scope of Analysis pane in the Query panel?

  A. None
  B. Default
  C. Custom
  D. One Level
  A. None
  C. Custom
  D. One Level

• Question 99:

  You have created a BusinessObjects Web Intelligence 4.0 document (WID) within InfoView that has a single table block on a single report page. Where will a new object be displayed when you add it to the query?

  A. In a block
  B. In a new report
  C. In Query Panel
  D. In Report Manager
  E. In a new report page
  D. In Report Manager

• Question 100:

  You are working with a set of store revenues. All stores have positive revenue values.

  Which formula should you use to display the variance value of the Revenue measure in your document when data tracking is active?

  A. =[Revenue]/RefValue([Revenue])
  B. =[Revenue]/PreValue([Revenue])
  C. =[Revenue]/HistValue([Revenue])
  D. =[Revenue]/BaseValue([Revenue])
  A. =[Revenue]/RefValue([Revenue])