Achieve New Updated (September) SAP C_BOWI_41 Examination Questions 81-90

Ensurepass

 

QUESTION 81

You want to compare the sales revenue performance of the top 20% of your customers to the average of all of your customers. You decide to apply a rank on the table that shows customers and revenue and create a variable to show the average revenue for all customers. Which function should you use in the variable?

 

A.

NoFilter()

 

 

 

 

B.

NoRank()

C.

AverageAll()

D.

IgnoreFilter()

 

Answer: A

 

 

QUESTION 82

Which is a benefit of using query drill?

 

A.

Data is pre-fetched and stored for all levels prior to drill.

B.

Data is pre-formatted and stored for all levels prior to drill.

C.

Dedicated SQL statements are generated for each drill.

D.

Levels you can drill through are based on your security profile.

 

Answer: C

 

 

QUESTION 83

Which two operators are available when using wildcards in a query filter?

 

A.

LIKE

B.

Matches Pattern

C.

Not equals Pattern

D.

Different from Pattern

 

Answer: BD

 

 

QUESTION 84

Where in a Web Intelligence report do you view merged objects in BusinessObjects Web Intelligence XI 4.x?

 

A.

Report Properties tab

B.

Data tab

C.

Navigation tab

D.

Object Properties tab

 

 

 

 

 

Answer: B

 

 

QUESTION 85

Which keyword is defined as flexible for input contexts?

 

A.

In

B.

All

C.

ForAll

D.

ForEach

 

Answer: D

 

 

QUESTION 86

Which two are benefits of using breaks?

 

A.

Creates a navigation map

B.

Makes the table block easier to read

C.

Splits the block into smaller table blocks

D.

Enables the use of subtotals in one block

 

Answer: BD

 

 

QUESTION 87

Which Web Intelligence component should you use to list the existing variables in a report?

 

A.

Report Manager

B.

Formula Editor

C.

Variable Editor

D.

Slice and Dice Panel

 

Answer: A

 

 

 

QUESTION 88

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

 

A.

Can contain a SQL statement

B.

Can contain a Case expression

C.

Contains a Boolean expression

D.

Can contain nested If() statements

 

Answer: CD

 

 

QUESTION 89

What happens when you drop a dimension into a blank part of a report that contains two blocks, without the ALT key selected?

 

A.

A new block is created.

B.

A new section is created.

C.

An error message is displayed.

D.

The currently selected cell is displayed.

 

Answer: B

 

 

QUESTION 90

Which two statements are true of contexts?

 

A.

You can combine objects in different contexts.

B.

You cannot combine objects in different contexts.

C.

You can combine any object within the same context to create a query.

D.

You can combine only measures within the same context to create a query.

 

Answer: AC

Free VCE & PDF File for SAP C_BOWI_41 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …

This entry was posted in C_BOWI_41 Examination questions (September) and tagged , , , , , , . Bookmark the permalink.