SAP C_BOWI_42 Online Practice Questions and Exam Preparation

SAP C_BOWI_42 Online Questions & Answers

• Question 1:

  Which operator should you use to control the output context of a calculation that is relevant to the different environment levels within your document?

  Please choose the correct answer.

  Response:

  A. In
  B. Out
  C. ForAll
  D. ForEach
  A. In

• Question 2:

  Where are formulas stored when created in Web Intelligence?

  A. In the Central Management Server (CMS) database
  B. In the metadata of the Cube
  C. On the report page
  D. In the universe
  C. On the report page

• Question 3:

  What can you use to create hyperlinks between Web Intelligence documents?

  A. OpenDocument
  B. The report map
  C. The document summery
  D. Element linking
  A. OpenDocument

• Question 4:

  Which DaysBetween() function syntax should you use to calculate the number of years since your birth, assuming the date object is Birth_date?

  Please choose the correct answer.

  Response:

  A. =DaysBetween([Birth_date] ; CurrentDate ) / 365.25
  B. =DaysBetween([Birth_date] , CurrentDate() ) / 365.25
  C. =DaysBetween([Birth_date] ; CurrentDate() ) / 365.25
  D. =DaysBetween(CurrentDate() ; [Birth_date] ) / 365.25
  C. =DaysBetween([Birth_date] ; CurrentDate() ) / 365.25

• Question 5:

  Elucidate the advantages of saving formulas as variables?

  Please choose the correct answer.

  Response:

  A. Use as options available in the Format and Report Element toolboxes
  B. You can reuse the formula without having to enter it each time
  C. Create the formulas and feed it with all its dimensions
  D. Use variables in any report within the document
  C. Create the formulas and feed it with all its dimensions

• Question 6:

  What option do you select to change the Total Revenue to a currency (shown in the attached graphic)?

  A. Right click on the edge of the table. U 2. Select Format Table.
  B. Right click the Total Revenue column name. 2. Select Format Number.
  C. Right click a number in the Total Revenue column. ^ ^ 2. Select Format Cell.
  D. Right click a number in the Total Revenue column. 2. Select Format Number.
  C. Right click a number in the Total Revenue column. ^ ^ 2. Select Format Cell.

• Question 7:

  Which Web Intelligence component should you use to list the existing variables in a report?

  Please choose the correct answer.

  Response:

  A. Report Manager
  B. Formula Editor
  C. Variable Editor
  D. Slice and Dice Panel
  A. Report Manager

• Question 8:

  Why purge data in a document before saving to the BI platform? (2 answers)

  A. To ensure that data security restrictions are applied when the document is viewed.
  B. To enable data tracking on a subsequent refresh.
  C. To reduce document file size.
  D. To allow other users to view the document in their preferred viewing locale.
  A. To ensure that data security restrictions are applied when the document is viewed.
  B. To enable data tracking on a subsequent refresh.

• Question 9:

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

  Please choose the correct answer.

  Response:

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

• Question 10:

  Which three can you use to start the Web Intelligence Rich Client from?

  There are 3 correct answers to this question.

  Response:

  A. InfoView
  B. Command Line
  C. Start > All Programs
  D. Central Management Console
  A. InfoView
  B. Command Line
  C. Start > All Programs