SAP C_BOWI_4302 Exam Practice Test Instant Access

Question 1

You want to know which other stores' revenues match or exceed your store's revenue. You build a query using the sales revenue. What is the next step?

AAdd a combined query, displaying all stores and revenues, using the intersection operator.

BAdd a subquery, displaying all stores and revenues with the operator 'Greater than or equal to' your store's revenue.

CAdd a combined query, displaying all stores and revenues, using the union operator.

DAdd a second query, displaying all stores and revenues and merge the store name dimensions.

Answer : B

Question 2

What data source can you select when creating a document using the Web Intelligence Rich Client? (2 answers)

AAnalysis view

BXML files

CBEx Query

DLumira Dataset

Answer : A, C

Question 3

How does WHERE operator affect a formula?

AIt adds the dimension to the default context.

BIt removes the dimension from the default context.

CIt determines the order of the results.

DIt restricts the dimension used to calculate a measure.

Answer : D

Question 4

You have two columns: order date and ship date. How do you calculate the processing time from the order date to the ship date?

AUse the 'daynumberofyear' function after subtracting both dates.

BUse the 'daysbetween' function with order date and ship date.

CUse the 'currentdate' function and subtract the ship date.

DUse the 'isdate' function on both dates and subtract the dates.

Answer : B

Question 5

How can you make the pie chart (shown in the attached graphic) display correctly?

AChange to the Design - With Data application mode.

BDrag a measure on to the chart

CChange to the Reading application mode.

DDrag a dimension or attribute on to the chart

Answer : B

Question 6

What happens if an operational prompt is blank when you execute a query?

AThe query filter is ignored.

BThe query returns an empty record set.

CThe query is filtered by the default value of the prompt.

DThe query is filtered by the last value selected.

Answer : A

Question 7

What items can be presented in a free-standing cell? (2 answers)

APage numbers

BLast refresh date

CBar charts

DVertical tables

Answer : A, B

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