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

There are 3 correct answers to this question.

Response:

A. UNION

B. MINUS

C. UNION ALL

D. INTERSECT

Where do you view merged dimensions?

Please choose the correct answer.

Response:

A. In the Report Map pane

B. In the Available Objects pane

C. In the Document Structure and Filters pane

D. In the Query panel

From the following identify which of the option is not a method to copy a chart from Web Intelligence to a

target application?

Please choose the correct answer.

Response:

A. Right-click the chart, and, from the contextual menu, select Copy.

B. In the target document, right-click the section cell and, from the contextual menu, click Copy

C. In the target document, right-click the area where you want the table to appear and, from the contextual menu, select Paste

D. Drag and drop the table from Web Intelligence to the target application

Elucidate the advantages of saving formulas as variables?

Please choose the correct answer.

Response:

A. Use as options available in the Format and Report Element toolboxes

B. You can reuse the formula without having to enter it each time

C. Create the formulas and feed it with all its dimensions

D. Use variables in any report within the document

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 four authentication methods are available for Web intelligence Rich Client?

There are 4 correct answers to this question.

Response:

A. AD

B. NT

C. LDAP

D. Vintella

E. Kerberos

F. Enterprise

Which two search criteria are valid when using Delegated List of Values?

There are 2 correct answers to this question.

Response:

A. a*

B. *a

C. a%

D. %a

Which four Report Elements can you select from the Templates tab of Web Intelligence?

There are 4 correct answers to this question.

Response:

A. Data

B. Report

C. Tables

D. Charts

E. Free-standing cells

Which option can you use to convert a table block into a chart in Web Intelligence Rich Client?

A. Click Format > Charts and select "Convert to Chart"

B. Click Tools > Charts and select "Change Table to Chart"

C. Right-click the table block and select "Turn To"

D. Right-click the table block and select "Convert to Chart"

Which two operators are available when using wildcards in a query filter? (Choose two.)

A. Different from Pattern

B. Matches Pattern

C. Not equals Pattern

D. LIKE