SAP SAP Certifications C_BOWI_42 Questions & Answers

• Question 201:

  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)

  A. Format number

  B. Preferred viewing locale

  C. Auto detect

  D. Product locale

  Correct Answer: AB

• Question 202:

  What chart elements can use a formula? (2 answers)

  A. Axis titles

  B. Data labels

  C. Chart title

  D. Legend labels

  Correct Answer: AC

• Question 203:

  Which report element can you drill on? (3 answers)

  A. Vertical tables

  B. Charts

  C. Page numbers

  D. Cross tables

  E. Free-standing cells

  Correct Answer: ABD

• Question 204:

  How does WHERE operator affect a formula?

  A. It determines the order of the results.

  B. It adds the dimension to the default context.

  C. It restricts the dimension used to calculate a measure.

  D. It removes the dimension from the default context.

  Correct Answer: C

• Question 205:

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

  A. Right click on the edge of the table. U 2. Select Format Table.

  B. Right click the Total Revenue column name. 2. Select Format Number.

  C. Right click a number in the Total Revenue column. ^ ^ 2. Select Format Cell.

  D. Right click a number in the Total Revenue column. 2. Select Format Number.

  Correct Answer: C

• Question 206:

  Which of these actions clear stored data when tracking data changes? (3 answers)

  A. Enable query stripping

  B. Use the query drill

  C. Drill out of scope

  D. Start the drill on a duplicate report

  E. Modify SQL

  Correct Answer: BCE

• Question 207:

  How do you change the dimension on which a section is based?

  A. 1. Right click the section cell.

  2.

  Select Edit Formula.

  3.

  Choose the new dimension.

  B. 1. Right click in a blank area of the section.

  2.

  Select Format Selection.

  3.

  Modify dimension after "Section on".

  C. 1. Right click the section cell.

  2.

  Select Sort.

  3.

  Select Advanced.

  4.

  Remove existing dimension.

  5.

  Add the new dimension.

  D. 1. Right click in a blank area of the section.

  2.

  Select Edit Selection.

  3.

  Choose the new dimension.

  Correct Answer: D

• Question 208:

  How do you share a Web Intelligence document with another user in the BI launch pad? (2 answers)

  A. Save it to the user's "My Favorites" folder

  B. Save it to your "My Favorite" folder

  C. Send it to the user's inbox

  D. Schedule it to a public folder

  Correct Answer: CD

• Question 209:

  Where is a variable saved?

  A. In the universe

  B. In the document

  C. In a query

  D. In a category

  Correct Answer: B

• Question 210:

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

  A. Data type

  B. Cluster Unique Identifier (CUID)

  C. Description

  D. Object name

  Correct Answer: BD