C_BOWI_42 Online Practice Questions and Answers

Which two are benefits of using breaks? There are 2 correct answers to this question. Response:

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

Which three statements are true of contexts? There are 3 correct answers to this question. Response:

A. Contexts are defined in a report.

B. Contexts are defined in a universe.

C. You can combine objects in different contexts.

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

List the different ways you can use to display professional reports by using Web Intelligence document

features?

There are 3 correct answers to this question

Response:

A. As a double-block report containing large amounts of data

B. As a folder containing large amounts of data

C. As a table (horizontal, vertical, form or cross table)

D. As a chart (bar, box, column, line, map, pie, point, radar or tag cloud)

E. As a multiple-block report containing large amounts of data

Which statement is true of an output context operator?

Please choose the correct answer.

Response:

A. It is placed within the brackets of the dimension list.

B. It is placed outside of the brackets of the dimension list.

C. It is placed within the brackets of the aggregation function.

D. It is placed outside of the brackets of the aggregation function.

In which two situations should you use sub-queries? There are 2 correct answers to this question. Response:

A. When the query filter involves values that are known

B. When the query filter involves values that are not known

C. When the query filter for the report involves a value that will change over time

D. When the query filter for the report involves a value that will never change over time

Which two statements are correct about hierarchies in Web Intelligence?

There are 2 correct answers to this question.

Response:

A. They can be created using the Query panel.

B. They can be created in the Scope of Analysis panel.

C. They can be chosen using a custom Scope of Analysis.

D. They are used to define the drill path in the Scope of Analysis.

Which function would you use to extract the word "pants" from the product name "casual pants" of the

Product Name field?

Please choose the correct answer.

Response:

A. Right(5; [Product Name])

B. Right([Product Name]; 5)

C. Right((Product Name), 5)

D. Right(5, [Product Name])

Which two methods can you use to aggregate measures at the section level in BusinessObjects Web

Intelligence 4.0?

There are 2 correct answers to this question.

Response:

A. Drag the measure from the Data tab into the section header.

B. Copy the measure from the Data tab into the section header.

C. While pressing the ALT key, drag the measure from the table to the section header.

D. While pressing the CTRL key, drag the measure from the table to the section header.

Which two personal folders are available by default to Web Intelligence users?

There are 2 correct answers to this question.

Response:

A. Inbox

B. My Favorites

C. My Documents D. Personal Documents

Where should you configure the regional settings of a Web Intelligence document (WID) within InfoView?

Please choose the correct answer.

Response:

A. Local Settings

B. Browser Preferences

C. User Machine Settings

D. InfoView Preferences

Which character should you use to reset the result of the RunningSum( ) function for either a break or a

section?

Please choose the correct answer.

Response:

A. Semicolon (;)

B. Percent (%)

C. Underscore (_)

D. Comma (,)

What automatically happens when you create a chart using the Templates tab in Web Intelligence?

Please choose the correct answer.

Response:

A. Data is filtered using template dimensions.

B. Structure mode is selected.

C. Data is displayed on the report page.

D. Select Objects dialog box opens.

Which method should you use to force each section of a report to start on a new page?

Please choose the correct answer. Response:

A. Select the section, Press CTRL-Enter.

B. Right-click the section, select "Start Section on New Page".

C. Select the section; in the Properties tab, check "Start on New Page".

D. Select the section; click Report > Section and select "Start on New Page".

Mention the five types of column charts for presenting DATA?

There are 3 correct answers to this question

Response:

A. 4D column chart

B. Column chart with dual values

C. Combined column and line chart

D. Stacked column chart

E. Column charts with fixed contents

Where are formulas stored when created in Web Intelligence?

A. In the Central Management Server (CMS) database

B. In the metadata of the Cube

C. On the report page

D. In the universe