Labour Day Special - 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: c4sdisc65

Note! C_BOWI_43 has been withdrawn. The new exam code is C_BOWI_4302

C_BOWI_43 Practice Exam Questions with Answers SAP Certified Application Associate - SAP BusinessObjects Web Intelligence 4.3 Certification

Question # 6

Which two settings can you configure for the Sample option in the Properties tab of the Web Intelligence Query panel?

There are 2 correct answers to this question.

Response:

A.

You can enable the "Fixed" option.

B.

You can set the "Max retrieval time".

C.

You can set the "Max rows retrieved".

D.

You can specify a "Sample Result" set.

Full Access
Question # 7

Which two statements are true about Page Layout of a report?

There are 2 correct answers to this question.

Response:

A.

It displays the definition of the block.

B.

It displays the report page by default.

C.

It defines what the report will look like when printed.

D.

It defines what the report will look like in PDF mode.

Full Access
Question # 8

Which Pos() function syntax should you use to find the location of the space in the Category string "Evening wear"?

Please choose the correct answer.

Response:

A.

Pos([Category] , "" )

B.

Pos((Category) , "" )

C.

Pos([Category] ; " " )

D.

Pos({Category} ; " " )

Full Access
Question # 9

For which tasks do you use an If() function?

There are 2 correct answers to this question.

Response:

A.

To conditionally show rows in a block

B.

To conditionally execute a scheduled report

C.

To display dynamically grouped values

D.

To display a dynamic list of values

Full Access
Question # 10

Which of the following options are use to create a default vertical table?

There are 2 correct answers to this question

Response:

A.

Create a validate query

B.

Create a new query

C.

Run a new query

D.

Run query panel

Full Access
Question # 11

Which of the following option is not a component of Web Intelligence Application Structure?

Please choose the correct answer.

Response:

A.

Toolboxes

B.

The Left Panel

C.

The Expand panel

D.

The Status Bar

Full Access
Question # 12

Which three types of local data files can you use to create a BusinessObjects Web Intelligence 4.0 document (WID)?

There are 3 correct answers to this question.

Response:

A.

TXT

B.

XML

C.

CSV

D.

XLS

Full Access
Question # 13

You are creating a report to summarize the number of cars sold by region. Which object should you use to aggregate the number of cars sold?

Please choose the correct answer.

Response:

A.

Sum

B.

Detail

C.

Measure

D.

Dimension

Full Access
Question # 14

A document displays a data in the format: MM/DD/YY. What option allow you to change the format to DD/MM/YY? (2 answers)

A.

Auto detect

B.

Format number

C.

Product locale

D.

Preferred viewing locale

Full Access
Question # 15

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

Full Access
Question # 16

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

A.

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

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

D.

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

Full Access
Question # 17

Which three calculations can you use in a measure object in Web Intelligence?

There are 3 correct answers to this question.

Response:

A.

Min

B.

Max

C.

Count

D.

Count All

Full Access
Question # 18

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

There are 2 correct answers to this question.

Response:

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.

Full Access
Question # 19

Why should you always log off the BI lunch pad rather than just closing your browser session?

A.

To improve system performance

B.

To clear the browser cache

C.

To protect corporate data

D.

To allow data refreshes

Full Access
Question # 20

What is the correct formula for the RunningSum column (shown in the attached graphic)?

C_BOWI_43 question answer

A.

RunningSum([Sales revenues];([Year];[Quarter]))

B.

RunningSum([Sales revenues];[Year];[Quarter])

C.

RunningSum([Sales revenues];([Year]))

D.

RunningSum([Sales revenues] in [Quarter])

Full Access
Question # 21

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

Please choose the correct answer.

Response:

A.

Crystal Reports

B.

Desktop Intelligence

C.

Web Intelligence in InfoView

D.

Web Intelligence Rich Client

Full Access
Question # 22

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

A.

prompt_string

B.

measure

C.

dimension

D.

report name

Full Access
Question # 23

Which two Web Intelligence Rich Client authentication methods enable you to export Web Intelligence documents (WID) to the Central Management Server (CMS)?

There are 2 correct answers to this question.

Response:

A.

LTM

B.

LDAP

C.

Offline

D.

Enterprise

E.

Standalone

Full Access
Question # 24

Which three are drill options?

There are 3 correct answers to this question.

Response:

A.

Hide drill toolbar

B.

Show drill filters

C.

Prompt if drill requires additional data

D.

Synchronize drill on report blocks

Full Access
Question # 25

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([Birth_date] ; CurrentDate() ) / 365.25

D.

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

Full Access
Question # 26

Where is a predefined query filter created?

A.

In the universe

B.

In the query panel

C.

In the filter bar

D.

In the Input Controls pane

Full Access
Question # 27

You have two columns: order date and ship date. How do you calculate the processing time from the order date to the ship date?

A.

Use the "daynumberofyear" function after subtracting both dates.

B.

Use the "daysbetween" function with order date and ship date.

C.

Use the "currentdate" function and subtract the ship date.

D.

Use the "isdate" function on both dates and subtract the dates.

Full Access
Question # 28

Where can you set the priority options for saving a Web Intelligence document (WID) to Microsoft Excel?

Please choose the correct answer.

Response:

A.

Web Intelligence

B.

InfoView Preferences

C.

Microsoft Excel File Options

D.

Web Intelligence Rich Client

Full Access
Question # 29

Which two statements are true of grouping sets when using smart measures?

Please choose the correct answer.

Response:

A.

It is a set of dimensions that generates a result for a measure.

B.

It is a set of measures that generates a result for a dimension.

C.

The generated SQL includes grouping sets for all the aggregations of that dimension that are included in the report.

D.

The generated SQL includes grouping sets for all the aggregations of that measure that are included in the report.

Full Access
Question # 30

Why would you need to change the data source for your query?

Please choose the correct answer.

Response:

A.

To change the universe connection of your universe

B.

To use the production universe instead of the test universe

C.

To use different objects from the universe

D.

To change the order of execution for existing queries

Full Access
Question # 31

How can you share Web Intelligence documents in your organization?

There are 2 correct answers to this question

Response:

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

Full Access
Question # 32

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

Full Access