SAP SAP Certifications C_BOWI_42 Questions & Answers

• Question 11:

  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()

  Correct Answer: A

• Question 12:

  Which two operators are used as calculation context operators? (Choose two.)

  A. Select

  B. Where

  C. In

  D. Having

  Correct Answer: BC

• Question 13:

  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. =RunningTotal([Sales Revenue], Reset[Region])

  B. =RunningTotal([Sales Revenue], Region)

  C. =RunningSum([Sales Revenue] ; ([Region]))

  D. =RunningSum([Sales Revenue], Region)

  Correct Answer: C

• Question 14:

  Which three object types can you use in a Web Intelligence universe query? (Choose three.)

  A. Dimension

  B. Class

  C. Measure

  D. Detail

  Correct Answer: ACD

• Question 15:

  Which combination of functions should you use to convert the string "13/11/46 12:00:00 AM" to "Wednesday 13 Nov 1946"?

  A. Right() using Pos, ToDate(), FormatDate()

  B. SubStr() using Pos, ToDate(), FormatDate()

  C. Right() using Pos, CurrentDate(), FormatDate()

  D. SubStr() using Pos, CurrentDate(), FormatDate()

  Correct Answer: B

• Question 16:

  Which Web Intelligence viewer panel should you use to create links to documents by browsing to the file without typing any syntax?

  A. ActiveX Report Panel

  B. Java Report Panel

  C. Interactive HTML Panel

  D. .NET Interactive Report Panel

  Correct Answer: C

• Question 17:

  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

  Correct Answer: C

• Question 18:

  Which Report Manager tab should you use to add a free-standing cell to a BusinessObjects Web Intelligence 4.0 document (WID)?

  Please choose the correct answer.

  Response:

  A. Map

  B. Data

  C. Template

  D. Properties

  Correct Answer: C

• Question 19:

  Which method should you use to activate data tracking?

  Please choose the correct answer.

  Response:

  A. Select the "Track" button on the toolbar.

  B. In the Query panel, enable "Keep History".

  C. In the InfoView Preferences, enable "Track Data Changes".

  D. Right-click the column in the report and select "Activate Data Tracking".

  Correct Answer: A

• Question 20:

  Identify from the given options the correct sequence of `Web Intelligence Core Functions'?

  Please choose the correct answer.

  Response:

  A. 1. Querying 2. Analyzing 3.Reporting 4.sharing

  B. 1. Querying 2. Reporting 3.Analyzing 4.sharing

  C. 1. Querying 2. Sharing 3. Analyzing 4.Reporting

  D. 1. Querying 2. Reporting 3. Sharing 4.Analyzing

  Correct Answer: B