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

Note! C_BOWI_4302 has been withdrawn.

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

Question # 6

Which keyword is defined as flexible for input contexts?

Please choose the correct answer.

Response:

A.

In

B.

All

C.

ForAll

D.

ForEach

Full Access
Question # 7

Which method should you use to activate "Interactive Viewing"?

Please choose the correct answer.

Response:

A.

Preferences in Web Intelligence

B.

Preferences in InfoView

C.

In the Document Properties

D.

In the Report Properties

Full Access
Question # 8

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

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

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

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

Full Access
Question # 11

You need to create a report that compares data to a reference data set. You create the report and activate the track data option. The report correctly indicates the changes in the data; however when you make another change to the report, the display no longer indicates any data tracking.

What actions could have caused this behavior?

There are 2 correct answers to this question.

Response:

A.

You drilled outside the scope of analysis.

B.

You activated query drill mode.

C.

You added a report break.

D.

You added a chart to the report

Full Access
Question # 12

What is the output of the following expression when the CurrentDate is January 31, 2014?

If (MonthNumberOfYear(CurrentDate())=1;

Year(CurrentDate())-1;

Year(CurrentDateQ))

A.

2014

B.

01/31/2014

C.

01/31/2013

D.

2013

Full Access
Question # 13

Which three options are Web Intelligence drill mode options?

There are 3 correct answers to this question.

Response:

A.

Drill By

B.

Drill Up

C.

Drill Down

D.

Drill Through

Full Access
Question # 14

Which tool do you use to edit merged objects in BusinessObjects Web Intelligence 4.0?

Please choose the correct answer.

Response:

A.

The Data tab of the Document Properties

B.

The Edit Dimensions button on the Reporting toolbar

C.

The Merge Dimensions button on the Reporting toolbar

D.

The Object Properties in the Data tab of the Report Manager

Full Access
Question # 15

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

Full Access
Question # 16

Which scenarios should you use breaks for?

There are 2 correct answers to this question.

Response:

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

Full Access
Question # 17

Which three elements are parts of a query filter?

There are 3 correct answers to this question.

Response:

A.

Class

B.

Object

C.

Operator

D.

Operand

Full Access
Question # 18

Which three output context expressions are valid extended syntax expressions?

There are 3 correct answers to this question.

Response:

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

Full Access
Question # 19

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

The universe is made up of classes and objects; there are three different types of objects. What are they?

There are 3 correct answers to this question

Response:

A.

Analyze – Analysis of data for required result

B.

Dimension -Typically retrieve character-type data

C.

Detail -Provides descriptive data about a dimension

D.

Measure - Retrieves numeric data that is the result of calculations on data in the database

E.

Improve- Selecting and implementation of the best solution

Full Access
Question # 21

Which table type looks most similar to a Microsoft Excel pivot table?

A.

Cross table

B.

Form

C.

Vertical table

D.

Horizontal table

Full Access
Question # 22

How can you see general report information such as the document author and the document creation date?

Please choose the correct answer.

Response:

A.

Select the Query Properties button.

B.

Open the Query panel.

C.

Insert the pre-defined cell Query Summary in the report.

D.

Open the Document Summary panel.

Full Access
Question # 23

Which three layout options can you use when creating sections in a report?

There are 3 correct answers to this question.

Response:

A.

Relative Position

B.

Start on New Page

C.

Keep Blocks Together

D.

Avoid Page Break in Section

Full Access
Question # 24

Which of the following can you use to filter results dynamically? (2 answers)

A.

Element linking

B.

Report map

C.

Results Object pane

D.

Input control

Full Access
Question # 25

Which two statements are true about the AND operator?

There are 2 correct answers to this question.

Response:

A.

Used when any condition is met by two filters

B.

Used when all conditions are met by two filters

C.

Used when all conditions are met by more than two filters

D.

Used when only one condition is met by any of the filters

Full Access
Question # 26

Which is a benefit of using query drill?

Please choose the correct answer.

Response:

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.

Full Access
Question # 27

Which Report Manager tab should you use to add a free-standing cell to a BusinessObjects Web Intelligence 4.0 document (WID)?

Please choose the correct answer.

Response:

A.

Map

B.

Data

C.

Template

D.

Properties

Full Access
Question # 28

Where can you set the default universe when using Web Intelligence within InfoView?

Please choose the correct answer.

Response:

A.

Query Panel

B.

Report Panel

C.

InfoView Options

D.

InfoView Preferences

Full Access
Question # 29

What data source can you select when creating a document using the Web Intelligence Rich Client? (2 answers)

A.

Analysis view

B.

XML files

C.

BEx Query

D.

Lumira Dataset

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

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

Which two personal folders are available by default to Web Intelligence users?

There are 2 correct answers to this question.

Response:

A.

Inbox

B.

My Favorites

C.

My Documents

D.

Personal Documents

Full Access