C_BOWI_42 Online Practice Questions and Answers

Select the correct sequence To Format a Bar Chart?

Please choose the correct answer.

Response:

A. Report Element>Chart>Insert Column Chart

B. Chart> Report Element >Insert Column Chart

C. Chart> Insert Column Chart >Report Element

D. Insert Column Chart>Chart>Report Element

Which three data sources can you synchronize in a Web Intelligence 4.0 document (WID)?

There are 3 correct answers to this question.

Response:

A. Personal data files

B. Stored procedure data source

C. Queries from the same universe

D. Queries from different universes

Which two are running aggregate functions in Web Intelligence?

There are 2 correct answers to this question.

Response:

A. RunningMax()

B. RunningSum()

C. RunningTotal()

D. RunningMean()

Which type of relationship links sub-queries by default?

Please choose the correct answer.

Response:

A.OR

B. AND

C. NOR

D. NAND

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])

To produce a report that focuses more precisely on certain data, you may need to apply more than one filter, and these filter must use Logical Operators.

What are these Logical operators?

There are 2 correct answers to this question

Response:

A. The AND operator

B. The OR operator

C. The ONE operator

D. The PLUS operator

Which three rules apply when you manually synchronize queries?

There are 3 correct answers to this question.

Response:

A. Dimension value formats must be the same.

B. Dimensions with different names can be merged.

C. Dimensions with different data types can be merged.

D. Dimensions from multiple data sources can be merged.

Which of the following options are use to create a default vertical table?

There are 2 correct answers to this question

Response:

A. Create a validate query

B. Create a new query

C. Run a new query

D. Run query panel

Which two locations can you use to set the drill options? There are 2 correct answers to this question. Response:

A. Report Properties

B. Query Panel Properties

C. Preferences in InfoView

D. Scope of Analysis Properties

E. Tools/Options in Web Intelligence Rich Client

Which of the following option is not a component of Web Intelligence Application Structure?

Please choose the correct answer.

Response:

A. Toolboxes

B. The Left Panel

C. The Expand panel

D. The Status Bar

After starting a drill, where are the objects that were selected in the drill interaction shown?

A. In the Report Map pane

B. In the Document Structure and Filters pane

C. In the formula bar

D. In the filter bar

What chart elements can use a formula? (2 answers)

A. Axis titles

B. Data labels

C. Chart title

D. Legend labels

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

A. Change to the Design - With Data application mode.

B. Change to the Reading application mode.

C. Drag a dimension or attribute on to the chart

D. Drag a measure on to the chart

In the Annual Revenue column, what formula calculates the total annual revenue in each row (shown in the attached graphic)?

A. =sum([Sales revenues] In([Year])) In ([Quarter])

B. =sum([Sales revenues] In([Year];[Quarter])) In ([Quarter])

C. =sum([Sales revenues] In([Year];[Quarter]))

D. =sum([Sales revenues] In([Year];[Quarter])) In ([Year])

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

A. Bar charts

B. Vertical tables

C. Last refresh date

D. Page numbers