SAP C_BOWI_4302 Exam Practice Test Instant Access

Question 1

Which three statements about the If() function are correct?

There are 3 correct answers to this question.

Response:

AValues within the function must be in quotes.

BThe function can be used to create a variable.

CThe function can contain an aggregate function.

DThen and Else keywords can be used within the function instead of the semicolon.

Answer : B, C, D

Question 2

Explain the different types of data changes that Web Intelligence can highlight with the data tracking feature?

There are 2 correct answers to this question

Response:

AMultiple data

BDuplicate data

CRemoved data

DModified data

Answer : C, D

Question 3

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?

Please choose the correct answer.

Response:

A=[Revenue]/RefValue([Revenue])

B=[Revenue]/PreValue([Revenue])

C=[Revenue]/HistValue([Revenue])

D=[Revenue]/BaseValue([Revenue])

Answer : A

Question 4

You are reviewing a report with the following statement in a variable:

=If([Sales revenue] > 750000) Then "Top Performer" Else If([Sales revenue] Between (200000;650000)) Then "Average Performer" Else If ([Sales revenue] < 200000) Then "Low Performer"

Which statement is true of the results produced by the statement for sales representatives with sales between 650,000 and 750,000?

Please choose the correct answer.

Response:

AThey will be Top Performers.

BThey will be Average Performers.

CThey will not be included in the report.

DThey will not have a performance value assigned.

Answer : D

Question 5

Mention the five types of column charts for presenting DATA?

There are 3 correct answers to this question

Response:

A4D column chart

BColumn chart with dual values

CCombined column and line chart

DStacked column chart

EColumn charts with fixed contents

Answer : B, C, D

Question 6

Which message appears when you select "Use query drill" while Scope of Analysis is set in a BusinessObjects Web Intelligence 4.0 report?

Please choose the correct answer.

Response:

AThe Scope of Analysis is empty.

BThe Scope of Analysis is not empty.

CThe query drill mode option is enabled.

DThe query drill mode option is not enabled.

Answer : B

Question 7

What all changes you can define and make with the LAYOUT option, to format a Table?

There are 2 correct answers to this question

Response:

ATo define relative pattern of the table on the page

BTo define horizontal and vertical start on new page

CTo define rows and columns and background image

DAvoid page break and repeat on every page options

Answer : B, D

SAP C_BOWI_4302 SAP Certified Application Associate - SAP BusinessObjects Web Intelligence 4.3 Exam Practice Test