Updated Nov-2023 Test Engine to Practice C_BOWI_42 Dumps & Practice Exam [Q39-Q62] : Free Exams Dumps Materials : http://exams.dumpsmaterials.com

NO.39 Which method should you use to activate “Interactive Viewing”?
Please choose the correct answer.
Response:

Preferences in Web Intelligence

Preferences in InfoView

In the Document Properties

In the Report Properties

NO.40 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

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

Measure

Dimension

Section

Universe

Block

NO.42 What do you use to search for content in multiple documents?

Central Management Console (CMC)

Central Configuration Manager (CCM)

BI launch pad

Report map

NO.43 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:

Format cell

Hide cell

Align text

Format number

NO.44 In which two situations should you use sub-queries?
There are 2 correct answers to this question.
Response:

When the query filter involves values that are known

When the query filter involves values that are not known

When the query filter for the report involves a value that will change over time

When the query filter for the report involves a value that will never change over time

NO.45 What options are available when linking to another document? (2 answers)

Target an area within the document

Refresh on open

Combine queries

Change data source

NO.46 In which of the following can you use If( ) function in Web Intelligence?

Prompts

Input control

Variables

Drill filters

NO.47 What can you use to create hyperlinks between Web Intelligence documents?

OpenDocument

The report map

The document summery

Element linking

NO.48 You have a regional sales report with State, City and Sales Revenue dimensions. You want to create a variable that excludes State from the output context. Which output statement should you use? Please choose the correct answer.
Response:

In([State])

Out([State])

ForAll([State])

ForEach([State])

NO.49 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()

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

Data type

Cluster Unique Identifier (CUID)

Description

Object name

NO.51 In which application do you schedule documents?

Central Configuration Management (CCM)

BI launch pad

Web Intelligence Desktop

Web Intelligence Applet

NO.52 Elucidate the advantages of saving formulas as variables?
Please choose the correct answer.
Response:

Use as options available in the Format and Report Element toolboxes

You can reuse the formula without having to enter it each time

Create the formulas and feed it with all its dimensions

Use variables in any report within the document

NO.53 Design mode provides access to the following toolboxes and their associated functions.
What are they?
There are 3 correct answers to this question
Response:

Improve function

Matches data task

Report Element

Data Access

Analysis task

NO.54 What object type is found in navigation paths?

Filter

Attribute

Filter

Dimension

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

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

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

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

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

NO.56 Discuss the components of a Web Intelligence Document?
There are 3 correct answers to this question
Response:

One or more reports

One or more blocks

One or more filters

One or more Pattern

NO.57 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.

NO.58 In the Web Intelligence Desktop, when you save a document as an Excel file, you can specify which reports saving; Following are the options available to save and export data? There are 2 correct answers to this question Response:

Prioritize data analysis in the Excel document

Prioritize the format of reports in the Excel document

Prioritize easy data processing in the Excel document

Prioritize the selection of best solution in the Excel document

NO.59 Which two statements are correct about hierarchies in Web Intelligence? There are 2 correct answers to this question.
Response:

They can be created using the Query panel.

They can be created in the Scope of Analysis panel.

They can be chosen using a custom Scope of Analysis.

They are used to define the drill path in the Scope of Analysis.

NO.60 Which type of relationship links sub-queries by default?
Please choose the correct answer.
Response:

AND

NOR

NAND

NO.61 Which two functions can you use to concatenate the strings “England” and “New” to create the string “New England”? There are 2 correct answers to this question.
Response:

Left()

LeftPad()

LeftTrim()

Concatenate()

NO.62 How can you share Web Intelligence documents in your organization?
There are 2 correct answers to this question
Response:

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

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

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

Publish documents to the CMS as a public or personal document