Updated Aug-2023 Exam Engine for C-BOWI-42 Exam Free Demo & 365 Day Updates [Q36-Q57] : IT Certification Exam Braindumps : http://blog.braindumpsit.com

NEW QUESTION 36
List the different ways you can use to display professional reports by using Web Intelligence document features? There are 3 correct answers to this question Response:

As a double-block report containing large amounts of data

As a folder containing large amounts of data

As a table (horizontal, vertical, form or cross table)

As a chart (bar, box, column, line, map, pie, point, radar or tag cloud)

As a multiple-block report containing large amounts of data

NEW QUESTION 37
Where can you set the priority options for saving a Web Intelligence document (WID) to Microsoft Excel? Please choose the correct answer.
Response:

Web Intelligence

InfoView Preferences

Microsoft Excel File Options

Web Intelligence Rich Client

NEW QUESTION 38
You want to compare the sales revenue performance of the top 20% of your customers to the average of all of your customers.
You decide to apply a rank on the table that shows customers and revenue and create a variable to show the average revenue for all customers.
Which function should you use in the variable?
Response:

NoFilter()

NoRank()

AverageAll()

IgnoreFilter()

NEW QUESTION 39
You are reviewing a report with the following statement in a variable:
= If([Sales revenue] > 750000) Then “Top Performer” Else If([Sales revenue] Between (200000;650000)) Then “Average Performer” Else If ([Sales revenue] < 200000) Then “Low Performer” Which statement is true of the results produced by the statement for sales representatives with sales between 650,000 and 750,000? Please choose the correct answer.
Response:

They will be Top Performers.

They will be Average Performers.

They will not be included in the report.

They will not have a performance value assigned.

NEW QUESTION 40
What happens if an operational prompt is blank when you execute a query?

The query is filtered by the default value of the prompt.

The query returns an empty record set.

The query filter is ignored.

The query is filtered by the last value selected.

NEW QUESTION 41
What is the default behavior when creating a report from two queries from the same universe? Please choose the correct answer.
Response:

Result produces two table blocks.

Dimension objects are automatically merged.

Results are shown on two different report tabs.

Dimension objects are not automatically merged.

NEW QUESTION 42
What are the benefits of using SAP Business Objects Web Intelligence? (2 answers)

You can drill, slice-and-dice, format information based on business needs.

You can use simple drag-and-drop features to create interactive reports.

You can dynamically refresh and update information directly in your MS Office documents.

You can centrally manage, control and configure your BI deployment.

NEW QUESTION 43
What is the input context of a calculation?

The measure being calculated

The aggregate function of the calculation

The dimension used to define the calculation

The prompt values used in query

NEW QUESTION 44
Where are contexts created?
Please choose the correct answer.
Response:

In a report

In a universe

In a derived table

At the database level

NEW QUESTION 45
Which two statements are true about using the Where operator with an output context? There are 2 correct answers to this question.
Response:

It must contain Boolean operators.

It restricts the data used to calculate the measure expression.

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

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

NEW QUESTION 46
Which three options are Web Intelligence drill mode options?
There are 3 correct answers to this question.
Response:

Drill By

Drill Up

Drill Down

Drill Through

NEW QUESTION 47
How do you share a Web Intelligence document with another user in the BI launch pad? (2 answers)

Save it to the user’s “My Favorites” folder

Save it to your “My Favorite” folder

Send it to the user’s inbox

Schedule it to a public folder

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

Use the “daysbetween” function with order date and ship date.

Use the “currentdate” function and subtract the ship date.

Use the “isdate” function on both dates and subtract the dates.

Use the “daynumberofyear” function after subtracting both dates.

NEW QUESTION 49
Which three methods can you use to apply a section in the Web Intelligence Rich Client? There are 3 correct answers to this question.
Response:

Click the “Set Master” button in the toolbar.

Drag the column to be sectioned outside the block.

Select the column; select Reporting Menu Option and then select “Set As Section”.

Right-click the column on which you want to create a section. From the drop-down menu, select “Set As Section”.

NEW QUESTION 50
Which two are running aggregate functions in Web Intelligence?
There are 2 correct answers to this question.
Response:

RunningMax()

RunningSum()

RunningTotal()

RunningMean()

NEW QUESTION 51
What tasks can you perform in the data application mode? (2 answers)

Add a report filter

Merge objects

Assign chart series data

Create a new data provider

NEW QUESTION 52
To which destinations can you send a Web Intelligence document (WID) through InfoView of BusinessObjects Web Intelligence XI 4.0? There are 3 correct answers to this question.
Response:

Broadcast Agent

Business Objects Inbox

FTP

File Server

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

RunningSum([Sales revenues] in [Quarter])

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

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

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

NEW QUESTION 54
To what can you apply conditional formatting rules (2 answers)

Data in a chart

Data in a section header cell

Data in a table

Data in a query filter

NEW QUESTION 55
Which two methods can you use to aggregate measures at the section level in BusinessObjects Web Intelligence 4.0? There are 2 correct answers to this question.
Response:

Drag the measure from the Data tab into the section header.

Copy the measure from the Data tab into the section header.

While pressing the ALT key, drag the measure from the table to the section header.

While pressing the CTRL key, drag the measure from the table to the section header.

NEW QUESTION 56
Which three statements about the If() function are correct?
There are 3 correct answers to this question.
Response:

Values within the function must be in quotes.

The function can be used to create a variable.

The function can contain an aggregate function.

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

NEW QUESTION 57
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:

=DaysBetween([Birth_date] ; CurrentDate ) / 365.25

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

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

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