SAP Certified Application Associate - SAP Business Objects Web Intelligence 4.2 (C_BOWI_42) Free Practice Test

Question 1

In the query panel, you modify the script and no errors occur. You remove an object and add a different object to the Result Object pane. What happens to the script?

A. The script is regenerated because the result object list is changed.

B. The script includes both the manual change and the new result objects.

C. The script fails to parse.

D. The script remains unchanged because the script was changed manually.

Correct Answer: A

Question 2

When using the ranking feature on a table, which expression allows you to display the total of all values (both ranked and unranked) in the footer of the block?

A. Sum([measure]) In Block

B. Sum([measure) For Each [dimension])

C. NoFilter(Sum([measure]))

D. RefValue(Sum([measure]))

Correct Answer: C

Question 3

To what can you apply conditional formatting rules (2 answers)

A. Data in a table

B. Data in a query filter

C. Data in a chart

D. Data in a section header cell

Correct Answer: A,D

Question 4

Why should you always log off the BI lunch pad rather than just closing your browser session?

A. To improve system performance

B. To protect corporate data

C. To allow data refreshes

D. To clear the browser cache

Correct Answer: D

Question 5

Where is a variable saved?

A. In a query

B. In a category

C. In the document

D. In the universe

Correct Answer: C

Question 6

How do you determine if a formula or a variable is used in a block? (2 answers)

A. Change the application mode to Design and select Structure Only

B. Change the application mode to Reading

C. Select the cell and view the formula toolbar

D. Select the block, right click and select Format Table

Correct Answer: A,C

Question 7

You have applied report filters to your document. How do you ensure that end users are aware of this when viewing a document in Reading mode?

A. Display the Report filters in free-standing cells.

B. Display prompt values in free-standing cells.

C. Display the Query Summery in a free-standing cell.

D. Display predefined filters in free-standing cells.

Correct Answer: A

Question 8

What is the input context of a calculation?

A. The aggregate function of the calculation

B. The dimension used to define the calculation

C. The prompt values used in query

D. The measure being calculated

Correct Answer: B

Question 9

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 a number in the Total Revenue column. ^ ^ 2. Select Format Cell.

C. Right click the Total Revenue column name. 2. Select Format Number.

D. Right click a number in the Total Revenue column. 2. Select Format Number.

Correct Answer: B

Welcome to TestSimulate

SAP Certified Application Associate - SAP Business Objects Web Intelligence 4.2 (C_BOWI_42) Free Practice Test