C_BOWI_42 questions and answers

Which sort option should you use to add Temporary Values?

Please choose the correct answer.

Response:

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

There are 3 correct answers to this question.

Response:

You add a new object to a query and run the query.

How do you display the new object in the document?

What object type is found in navigation paths?

How much impact does data tracking have on the data size of a Web Intelligence document (WID)
Compared to the same document without data tracking?

Please choose the correct answer.

Response:

Which three options are default page number cells?

There are 3 correct answers to this question.

Response:

Which three are drill options?

There are 3 correct answers to this question.

Response:

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)

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:

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

There are 2 correct answers to this question.

Response:

What are the ways of adding breaks In the Web Intelligence Desktop application?

There are 2 correct answers to this question

Response:

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

Which of the following options involved to Create Variable from the Formula?

There are 2 correct answers to this question

Response:

You set the drill option "Prompt when drill requires additional data". Now you drill outside the scope of analysis on your report.

How does Web Intelligence respond?

Please choose the correct answer.

Response:

In the Annual Revenue column, what formula calculates the total annual revenue in each row (shown in the attached graphic)?

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:

Which property do you enable to keep rows in a break together on the same page?

Please choose the correct answer.

Response:

Which three statements are true about alerters?

There are 3 correct answers to this question.

Response:

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:

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

Please choose the correct answer.

Response:

Your data source has the following values: SMITH, SMYTH, SMALL, SMOOTH, SMART, SMILEY.

What syntax do you use to show only the names SMITH and SMYTH?

What is a Web Intelligence variable?

Identify from the correct option from the following - To Navigate from Section to Section?

Please choose the correct answer.

Response:

What do you use to conditionally hide a report element?

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

Which two are benefits of creating queries from existing queries?

There are 2 correct answers to this question.

Response:

Where should you configure the regional settings of a Web Intelligence document (WID) within InfoView?

Please choose the correct answer.

Response:

Which of the following are extended syntax keywords? (2 answers)

Where do you set the "Optional prompt" option in Web Intelligence Rich Client?

Please choose the correct answer.

Response:

Which two operators are available when using wildcards in a query filter? (Choose two.)

You need to create a report displaying a year-to-date aggregation on sales revenue across all months. The report should be sectioned on Region. Additionally, you would like to reset the running aggregation to restart for each Region.

Which syntax should you use to accomplish this task?

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

A table contains a dimension [CITY] and a measure [SALES]. You insert a column to display the formula AVERAGE([SALES]).

Which operator do you add to the formula so that it displays the average for the table in every row? (2 answers)

Which options can you select when you save a Web Intelligence document (WID)? (Choose two.)

Which is a benefit of using query drill?

Please choose the correct answer.

Response:

Which of the following query types can you use for combined queries? (3 answers)

Which tasks can you accomplish using breaks?

There are 2 correct answers to this question.

Response:

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:

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:

What option do you select to change the Total Revenue to a currency (shown in the attached graphic)?

What can you do with a scope of analysis? (2 answers)