SAP SAP Certifications C_BOWI_42 Questions & Answers

• Question 221:

  Which of the following filter components are used to restrict data? (3 answers)

  A. An operator

  B. A universe connection

  C. A SELECT statement

  D. An object

  E. An operand

  Correct Answer: ADE

• Question 222:

  What happens when you create a section in a report? (2 answers)

  A. Blocks in the report are repeated for each section value.

  B. Header and footer cells are created for each section value.

  C. Free-standing cells are created to label each section value.

  D. Page breaks are created to divide each section value.

  Correct Answer: AC

• Question 223:

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

  A. OpenDocument

  B. The report map

  C. The document summery

  D. Element linking

  Correct Answer: A

• Question 224:

  What does the RefValue() function return if there is no reference data?

  A. A blank

  B. A zero

  C. A null

  D. An error

  Correct Answer: C

• Question 225:

  How do you duplicate an existing query? (2 answers)

  A. In the report, right click the report tab and select Duplicate Report.

  B. In the design mode, right click the block and select Publish as Web Service.

  C. In the query panel, right click the query tab and select Duplicate.

  D. In the data mode, right click the query and copy and paste the query.

  Correct Answer: CD

• Question 226:

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

  A. Add a report filter

  B. Merge objects

  C. Assign chart series data

  D. Create a new data provider

  Correct Answer: BD

• Question 227:

  How do you remove a custom sort that has been applied to an object?

  A. Choose the Remove button in the Manage Sorts dialog.

  B. Choose the Reset button in the Manage Sorts dialog.

  C. Delete the column containing the object.

  D. Right click the object, select Sort and then select None.

  Correct Answer: B

• Question 228:

  How do you make changes to a document that has been published in the BI Launch pad? (2 answers)

  A. Right click the document and select Properties.

  B. Right click the document and select Document Link.

  C. Select the document, select More Actions and select Modify.

  D. Double click the document and select Design Mode.

  Correct Answer: CD

• Question 229:

  You have a measure with different names coming from two queries. How you determine which query each measure comes from?

  A. Select the Arrange by Alphabetical Order option in the Available Objects pane.

  B. Select the Arrange by Query option in the Available Objects pane.

  C. Select the View Lineage option in the BI launch pad.

  D. Select the Visual Difference option in the Central Management Console (CMC).

  Correct Answer: B

• Question 230:

  What actions can you perform in the Web Intelligence query panel? (3 answers)

  A. Publish as a web service.

  B. Remove objects from the query.

  C. Change custom filters.

  D. Change table to chart.

  E. Rearrange objects in the query.

  Correct Answer: BCE