SAP SAP Certifications C_BOWI_42 Questions & Answers

• Question 241:

  Which analysis function adds a column to a vertical table?

  A. Percentage

  B. Count

  C. Sum

  D. Default aggregation

  Correct Answer: A

• Question 242:

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

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

  B. The query returns an empty record set.

  C. The query filter is ignored.

  D. The query is filtered by the last value selected.

  Correct Answer: C

• Question 243:

  You want to know which other stores' revenues match to exceed your store's revenue. You build a query using the sales revenue. What is the next step?

  A. Add a subquery displaying all stores and revenues with the operator "Greater than or equal to your store's revenue.

  B. Add a second query displaying all stores and revenues and merge the store name dimensions.

  C. Add a combine query displaying all stores and revenues using the union operator.

  D. Add a combine query displaying all stores and revenues using intersection operator.

  Correct Answer: A

• Question 244:

  Which operator allows you to select exactly one value as the operand for a query filter?

  A. Between

  B. Is null

  C. Equal to

  D. Different from pattern

  Correct Answer: C

• Question 245:

  In the query panel, you modify the script and no errors occur. You remove an object and add a different object to the Result Object pane. What happens to the script?

  A. The script remains unchanged because the script was changed manually.

  B. The script is regenerated because the result object list is changed.

  C. The script fails to parse.

  D. The script includes both the manual change and the new result objects.

  Correct Answer: B

• Question 246:

  What is a Web Intelligence variable?

  A. A formula that is saved with a name.

  B. A property that allows the user to change application mode.

  C. A function that merges multiples queries.

  D. An option that enhances performance when a query is refreshed.

  Correct Answer: A

• Question 247:

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

  A. Prompts

  B. Input control

  C. Variables

  D. Drill filters

  Correct Answer: C

• Question 248:

  When creating a hyperlink, what BI Launchpad Preferences view includes the Link to Document option?

  A. Applet

  B. HTML

  C. Desktop

  D. PDF

  Correct Answer: B

• Question 249:

  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)

  A. In Block

  B. In Body

  C. ForEach ([CITY])

  D. For AII ([CITY])

  Correct Answer: AD

• Question 250:

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

  A. Central Management Console (CMC)

  B. Central Configuration Manager (CCM)

  C. BI launch pad

  D. Report map

  Correct Answer: C