SAP SAP Certified Application Associate C_BOWI_42 Questions & Answers

• Question 11:

  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 12:

  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 13:

  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 14:

  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 15:

  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 16:

  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 17:

  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 18:

  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

• Question 19:

  Which two statements are true of an ambiguous query? There are 2 correct answers to this question. Response:

  A. It can be resolved with a loop.

  B. It can be resolved with a context.

  C. It contains all possible combinations of rows from the tables inferred by the objects.

  D. It contains one or more objects that can potentially return two different types of information.

  Correct Answer: BD

• Question 20:

  Which tool do you use to edit merged objects in BusinessObjects Web Intelligence 4.0?

  Please choose the correct answer.

  Response:

  A. The Data tab of the Document Properties

  B. The Edit Dimensions button on the Reporting toolbar

  C. The Merge Dimensions button on the Reporting toolbar

  D. The Object Properties in the Data tab of the Report Manager

  Correct Answer: C