Online Access Free C_BOWI_43 Practice Test

Which method should you use to group query filters together to form one AND statement?
Please choose the correct answer.
Response:

• A.Drag the queries together
• B.Select the filters, then click the Group Filters button on the toolbar
• C.Select the filters, right-click and select Group
• D.Drag the query filters to the Group panel

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:

• A.It inserts a prompted report filter on the report and refreshes the report view.
• B.It prompts you to choose a hierarchy level and waits for your response before retrieving the data.
• C.It notifies you that it needs to retrieve additional data to complete the drill and retrieves the data.
• D.It inserts a prompted query filter in the query and reruns the query.

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:

• A.1.00
• B.1.15
• C.1.18
• D.1.05
• E.1.10

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

• A.When the query filter for the report involves a value that will change over time
• B.When the query filter involves values that are not known
• C.When the query filter for the report involves a value that will never change over time
• D.When the query filter involves values that are known

Which statement describes the performance impact that data tracking has on report refresh times, assuming that the data changes but the number of rows retrieved and the data volume stays the same?
Please choose the correct answer.
Response:

• A.It will refresh faster each time the report is refreshed.
• B.It will refresh up to three times faster.
• C.It will refresh slower each time the report is refreshed.
• D.It will refresh up to three times slower.