SAP c-bowi-43 practice test

Question 1

A document displays a data in the format: MM/DD/YY. What option allow you to change the format
to DD/MM/YY? (2 answers)

• A. Auto detect
• B. Format number
• C. Product locale
• D. Preferred viewing locale

Answer:

B, D

Question 2

Why do you use the "Turn into" functionality?

• A. To change the data source of a document
• B. To change the table into a chart
• C. To change the object of a section
• D. To change the data type of an object

Answer:

B

Question 3

What is the output of the following expression when the CurrentDate is January 31, 2014?
If (MonthNumberOfYear(CurrentDate())=1;
Year(CurrentDate())-1;
Year(CurrentDateQ))

• A. 2014
• B. 01/31/2014
• C. 01/31/2013
• D. 2013

Answer:

D

Question 4

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 prompt values in free-standing cells.
• B. Display the Report filters in free-standing cells.
• C. Display predefined filters in free-standing cells.
• D. Display the Query Summery in a free-standing cell.

Answer:

B

Question 5

What do you use to search for content in multiple documents?

• A. Central Configuration Manager (CCM)
• B. Central Management Console (CMC)
• C. Report map
• D. BI launch pad

Answer:

D

Question 6

What option do you select to change the Total Revenue to a currency (shown in the attached
graphic)?

A.
1. Right click a number in the Total Revenue column.
2. Select Format Number.
B.
1. Right click the Total Revenue column name.
2. Select Format Number.
C.
1. Right click on the edge of the table.
2. Select Format Table.
D.
1. Right click a number in the Total Revenue column.
2. Select Format Cell.

Answer:

D

Question 7

Which data sources can you access directly using Web Intelligence?

• A. Relational databases
• B. Business Explorer (BEx) Queries
• C. XML files
• D. OLAP cubes

Answer:

B

Question 8

What is the correct formula for the RunningSum column (shown in the attached graphic)?

• A. RunningSum([Sales revenues];([Year];[Quarter]))
• B. RunningSum([Sales revenues];[Year];[Quarter])
• C. RunningSum([Sales revenues];([Year]))
• D. RunningSum([Sales revenues] in [Quarter])

Answer:

C

Question 9

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. NoFilter(Sum([measure]))
• B. Sum([measure) For Each [dimension])
• C. Sum([measure]) In Block
• D. RefValue(Sum([measure]))

Answer:

A

Question 10

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

• A. Analysis view
• B. XML files
• C. BEx Query
• D. Lumira Dataset

Answer:

A, C