SAP Certified Application Associate - SAP BusinessObjects Web Intelligence 4.3 (C-BOWI-4302) Free Practice Test

Question 1

Which statement is true of an output context operator?
Please choose the correct answer.
Response:

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

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

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

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

Correct Answer: A

Question 2

What automatically happens when you create a chart using the Templates tab in Web Intelligence?
Please choose the correct answer.
Response:

A. Structure mode is selected.

B. Data is displayed on the report page.

C. Select Objects dialog box opens.

D. Data is filtered using template dimensions.

Correct Answer: A

Question 3

What are the steps to define alternate row colors for a table?

A. In Design mode, select a table. Click Side panel. In the Format pane, select the Appearance Settings tab.
In the Background/Alternate Color section, set the frequency of the alternate color to appear for the alternate row color. Select a color from the me

B. In Reading mode, select a section. Click Side panel. In the Format pane, select the Appearance Settings tab. In the Background/Alternate Color section, set the frequency of the alternate color to appear for the alternate row color. Select a color from the

C. In Reading mode, select a table. Click Side panel. In the Build pane, select the Appearance Settings tab.
In the Background/Alternate Color section, set the frequency of the alternate color to appear for the alternate row color. Select a color from the me

D. In Design mode, select a table. Click Side panel. In the My Objects pane, select the Appearance Settings tab. In the Background/Alternate Color section, set the frequency of the alternate color to appear for the alternate row color. Select a color from the

Correct Answer: A

Question 4

You want to force the calculation context of a variable in a table so that its values do not change when a dimension is added to the table. Which of the following statements is correct?
Please choose the correct answer.
Response:

A. You exclude the dimension using the output context.

B. You include the dimension using the output context.

C. You include the dimension using the input context.

D. You exclude the dimension using the input context.

Correct Answer: A

Question 5

In the query panel, you modify the script and no errors occur. You remove an object and add a different object to the Result Object pane. What happens to the script?

A. The script is regenerated because the result object list is changed.

B. The script includes both the manual change and the new result objects.

C. The script fails to parse.

D. The script remains unchanged because the script was changed manually.

Correct Answer: A

Question 6

Which DaysBetween() function syntax should you use to calculate the number of years since your birth, assuming the date object is Birth_date?
Please choose the correct answer.
Response:

A. =DaysBetween([Birth_date] , CurrentDate() ) / 365.25

B. =DaysBetween([Birth_date] ; CurrentDate() ) / 365.25

C. =DaysBetween(CurrentDate() ; [Birth_date] ) / 365.25

D. =DaysBetween([Birth_date] ; CurrentDate ) / 365.25

Correct Answer: B

Question 7

Discuss the instructions appropriate for how you want the data in a table and manipulate the data within the table There are 2 correct answers to this question Response:

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

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

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

D. Right-click the table and, from the contextual menu, select Copy

Correct Answer: B,D

Question 8

Which of the following is not a step of demonstration, to display an aggregate within a sectioned report.
Please choose the correct answer.
Response:

A. Click the Analysis Toolbox

B. Click a detail row in the Sales revenue column

C. Click the Table, Chart or Others tab

D. Click the Functions Tab

Correct Answer: C

Question 9

Which of the following options involved to Create Variable from the Formula?
There are 2 correct answers to this question
Response:

A. Double-click Formula bar and click OK

B. On the Formula bar, click Create Variable

C. Select the cell that contains the formula

D. Click the Create Variable and Select the Formula bar

Correct Answer: B,C

Question 10

How do you access the Format Table option?

A. Right click the footer of the table

B. Right click the border of the table

C. Right click the column header of the table

D. Right click the data of the table

Correct Answer: B

Question 11

Which three are drill options?
There are 3 correct answers to this question.
Response:

A. Show drill filters

B. Hide drill toolbar

C. Prompt if drill requires additional data

D. Synchronize drill on report blocks

Correct Answer: B,C,D

Question 12

Discuss all the advantages link to organizing a report in the section
There are 2 correct answers to this question
Response:

A. You can insert subtotal cells, repeated in each section, which are created by the simple process of drag and drop

B. You can have single block projected from the same microcube within a single report, all grouped to the sectioned level

C. You can insert tables, different in each section, which are created by the simple process of drag and drop

D. You can have multiple blocks projected from the same microcube within a single report, all sub-grouped to the sectioned level

Correct Answer: A,D

Question 13

The side panel can group several panes. Which ones? Note: There are 3 correct answers to this question.

A. Display

B. Insert

C. My Objects

D. Report Structure

E. Build

Correct Answer: C,D,E

Question 14

Which of the following make up a semantic layer for a rational data source? (3 answers)

A. Universe

B. Measure

C. Dimension

D. Section

E. Block

Correct Answer: A,B,C

Question 15

Which two statements describe reasons for using the FormatDate() function?
There are 2 correct answers to this question.
Response:

A. You want to convert a string object into a date object.

B. You want to convert a date object into a string object.

C. You want to format a date so that it is displayed as a string when it is concatenated with another string.

D. You want to modify the format of a string object into a non-standard date format.

Correct Answer: B,C

Welcome to TestSimulate

SAP Certified Application Associate - SAP BusinessObjects Web Intelligence 4.3 (C-BOWI-4302) Free Practice Test