C_BOWI_41 Online Practice Questions and Answers

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.

Which reporting tool should you use to create a Web Intelligence document (WID) directly from an Excel data source?

A. Crystal Reports

B. Desktop Intelligence

C. Web Intelligence in InfoView

D. Web Intelligence Rich Client

Which operators can be used in an Input calculation context?

A. Input

B. ForAll

C. ForEach

D. In

Which three methods can you use to combine queries using the Web Intelligence Rich Client?

A. UNION

B. MINUS

C. UNION ALL

D. INTERSECT

You have a regional sales report with State, City and Sales Revenue dimensions. You want to create a variable that excludes State from the output context.

Which output statement should you use?

A. In([State])

B. Out([State])

C. ForAll([State])

D. ForEach([State])

Which options can you select when you save a Web Intelligence document (WID)?

A. Refresh on open

B. Associate universe

C. Permanent regional formatting

D. Send to users

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

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 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.

Which keyword is defined as flexible for input contexts?

A. In

B. All

C. ForAll

D. ForEach

Which method can you use to build a custom sort?

A. Right-click the table, select "Custom Sort"

B. Right-click the table, select "Sort" and select "Custom Sort"

C. Select a column; on the toolbar, click the "Custom Sort" button

D. Select a column; on the toolbar, click the "Apply Sort" button and select "Custom Sort"