March Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

SAP C_BOWI_43 SAP Certified Application Associate - SAP BusinessObjects Web Intelligence 4.3 Exam Practice Test

Demo: 32 questions
Total 1 questions

SAP Certified Application Associate - SAP BusinessObjects Web Intelligence 4.3 Questions and Answers

Question 1

Which three statements about the If() function are correct?

There are 3 correct answers to this question.

Response:

Options:

A.

Values within the function must be in quotes.

B.

The function can be used to create a variable.

C.

The function can contain an aggregate function.

D.

Then and Else keywords can be used within the function instead of the semicolon.

Question 2

Which method can you use to hide data using an alerter?

Please choose the correct answer.

Response:

Options:

A.

Build an alerter that removes the column.

B.

Build an alerter that applies a formula that changes the block value.

C.

Build an alerter with a formula that changes the font color to the background color.

D.

Click anywhere in the document. On the toolbar, click the "Data" button and select "Hide Data".

Question 3

Where is a variable saved?

Options:

A.

In the document

B.

In a category

C.

In a query

D.

In the universe

Question 4

Which message appears when you select "Use query drill" while Scope of Analysis is set in a BusinessObjects Web Intelligence 4.0 report?

Please choose the correct answer.

Response:

Options:

A.

The Scope of Analysis is empty.

B.

The Scope of Analysis is not empty.

C.

The query drill mode option is enabled.

D.

The query drill mode option is not enabled.

Question 5

Which two are limitations of a detail object?

There are 2 correct answers to this question.

Response:

Options:

A.

It cannot be drilled on.

B.

It cannot be used in the report filter.

C.

It cannot be merged in a document.

D.

It cannot be used in the WHERE statement of the query.

Question 6

Which three can you use to start the Web Intelligence Rich Client from?

There are 3 correct answers to this question.

Response:

Options:

A.

InfoView

B.

Command Line

C.

Start > All Programs

D.

Central Management Console

Question 7

Which scenarios should you use breaks for?

There are 2 correct answers to this question.

Response:

Options:

A.

Generating subtotals in one table block

B.

Breaking the table into multiple table blocks

C.

Grouping repeated values in one table block

D.

Generating running sum in multiple table blocks

Question 8

Which three are drill options?

There are 3 correct answers to this question.

Response:

Options:

A.

Hide drill toolbar

B.

Show drill filters

C.

Prompt if drill requires additional data

D.

Synchronize drill on report blocks

Question 9

Build a query using the eFashion universe, and select the following options to create a section?

There are 3 correct answers to this question

Response:

Options:

A.

Year

B.

Quarter

C.

Half-Year

D.

Sales revenue

E.

Monthly Sales revenue

Question 10

Which sort option should you use to add Temporary Values?

Please choose the correct answer.

Response:

Options:

A.

Ascending

B.

Descending

C.

Custom Sort

D.

Adaptive Sort

Question 11

What does the Change Source Wizard use to remap existing objects to a new data source? (2 answers)

Options:

A.

Data type

B.

Object name

C.

Description

D.

Cluster Unique Identifier (CUID)

Question 12

Which three objects represent qualifications from a local data provider?

There are 3 correct answers to this question.

Response:

Options:

A.

BLOB

B.

DATE

C.

TEXT

D.

NUMBER

Question 13

Which data sources can you access directly using Web Intelligence?

Options:

A.

Relational databases

B.

Business Explorer (BEx) Queries

C.

XML files

D.

OLAP cubes

Question 14

To what can you apply a conditional formatting rule? Note: There are 2 correct answers to this question.

Options:

A.

Data in a query filter

B.

Data in a chart

C.

Data in a section cell

D.

Data in a table

Question 15

Which two statements describe reasons for using the FormatDate() function?

There are 2 correct answers to this question.

Response:

Options:

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.

Question 16

What happens when you drop a dimension into a blank part of a report that contains two blocks, without the ALT key selected?

Please choose the correct answer.

Response:

Options:

A.

A new block is created.

B.

A new section is created.

C.

An error message is displayed.

D.

The currently selected cell is displayed.

Question 17

How can you share Web Intelligence documents in your organization?

There are 2 correct answers to this question

Response:

Options:

A.

From within the BI launch pad, and sent automatically by using the sharing option to group of users

B.

From within the BI launch pad, save a document as a personal document in the BIP

C.

From within the BI launch pad, send a document to another user or group of users

D.

Publish documents to the CMS as a public or personal document

Question 18

Which Report Manager tab should you use to change report formatting?

Please choose the correct answer.

Response:

Options:

A.

Map

B.

Data

C.

Properties

D.

Templates

Question 19

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

Options:

A.

Section

B.

Universe

C.

Block

D.

Dimension

E.

Measure

Question 20

Where in a Web Intelligence report do you view merged objects in BusinessObjects Web Intelligence XI 4.x?

Please choose the correct answer.

Response:

Options:

A.

Report Properties tab

B.

Data tab

C.

Navigation tab

D.

Object Properties tab

Question 21

What is the required argument of the UserResponse( ) function?

Options:

A.

prompt_string

B.

measure

C.

dimension

D.

report name

Question 22

What is the maximum number of sub-alerts that an alerter can contain?

Please choose the correct answer.

Response:

Options:

A.

1

B.

8

C.

16

D.

32

Question 23

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:

Options:

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

Question 24

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:

Options:

A.

You include the dimension using the input context.

B.

You exclude the dimension using the input context.

C.

You include the dimension using the output context.

D.

You exclude the dimension using the output context.

Question 25

Where do you view merged dimensions?

Please choose the correct answer.

Response:

Options:

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

Question 26

Conditional formatting rules enable you to highlight results that meet or fail specific business targets. Name the elements associated with the Formatting rules?

There are 3 correct answers to this question

Response:

Options:

A.

An object or cell contents

B.

A modified data formatting

C.

A cell section

D.

An operator

E.

The conditional formatting

Question 27

You insert the function CurrentDate() into a cell. To clarify the date you add a string so that the formula is now:

="Sales Report from "+CurrentDate()

Which formatting capability is disabled for the cell?

Please choose the correct answer.

Response:

Options:

A.

Format cell

B.

Hide cell

C.

Align text

D.

Format number

Question 28

A variable in your report contains the statement:

=If[State] = "California" Then [Sales revenue] * 1.05 Else If[State] = "Colorado" Then [Sales revenue] *

1.1 Else If[State] InList ("DC";"Texas ") Then [Sales revenue] * 1.15 Else If[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue]

Sales revenue for Florida is $1,879,159. Which rate is applied to the Florida revenue by the formula?

Please choose the correct answer.

Response:

Options:

A.

1.00

B.

1.05

C.

1.10

D.

1.15

E.

1.18

Question 29

How does SAP recommend you print a Web Intelligence document to ensure the document layout is preserved?

Options:

A.

Export the document to a PDF file and print the PDF file.

B.

Export data to a CSV file and print the CSV file.

C.

Use the print option in the browser

D.

Use the Print Screen button on your keyboard

Question 30

Which three output context expressions are valid extended syntax expressions?

There are 3 correct answers to this question.

Response:

Options:

A.

Where ([State] = "CA")

B.

Where Section In [State]

C.

In Block Where Section = [State]

D.

In Section Where ([State] = "CA")

E.

Where ([State]="CA" And [Year] ="2006")

Question 31

Which two statements are true of an ambiguous query?

There are 2 correct answers to this question.

Response:

Options:

A.

It can be resolved with a loop.

B.

It can be resolved with a context.

C.

It contains all possible combinations of rows from the tables inferred by the objects.

D.

It contains one or more objects that can potentially return two different types of information.

Question 32

Which two statements are true about using the Where operator with an output context?

There are 2 correct answers to this question.

Response:

Options:

A.

It must contain Boolean operators.

B.

It restricts the data used to calculate the measure expression.

C.

It modifies the WHERE clause of the SQL generated to calculate the measure expression.

D.

It is not necessary to place parentheses around the values listed after the Where operator.

Demo: 32 questions
Total 1 questions