SAP C_BOWI_41 Online Practice Questions and Exam Preparation

SAP C_BOWI_41 Online Questions & Answers

• Question 11:

  You want to force the calculation context for a variable in a large report with many dimensions. Which operator allows you to add a dimension to the default context?

  A. In
  B. All
  C. ForAll
  D. ForEach
  D. ForEach

• Question 12:

  Which two Web Intelligence Rich Client authentication methods enable you to export Web Intelligence documents (WID) to the Central Management Server (CMS)?

  A. LTM
  B. LDAP
  C. Offline
  D. Enterprise
  E. Standalone
  B. LDAP
  D. Enterprise

• Question 13:

  Which two statements are true of an ambiguous query?

  A. It can be resolved with a loop.
  B. It can be resolved with a context.
  C. It contains all possible combinations of rows from the tables inferred by the objects.
  D. It contains one or more objects that can potentially return two different types of information.
  B. It can be resolved with a context.
  D. It contains one or more objects that can potentially return two different types of information.

• Question 14:

  Which two statements are true of grouping sets when using smart measures?

  A. It is a set of dimensions that generates a result for a measure.
  B. It is a set of measures that generates a result for a dimension.
  C. The generated SQL includes grouping sets for all the aggregations of that dimension that are included in the report.
  D. The generated SQL includes grouping sets for all the aggregations of that measure that are included in the report.
  A. It is a set of dimensions that generates a result for a measure.
  D. The generated SQL includes grouping sets for all the aggregations of that measure that are included in the report.

• Question 15:

  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?

  A. Format cell
  B. Hide cell
  C. Align text
  D. Format number
  D. Format number

• Question 16:

  Which three layout options can you use when creating sections in a report?

  A. Relative Position
  B. Start on New Page
  C. Keep Blocks Together
  D. Avoid Page Break in Section
  A. Relative Position
  B. Start on New Page
  D. Avoid Page Break in Section

• Question 17:

  Which two break properties can you use when setting Break Priority?

  A. Order Breaks
  B. Vertical Breaks
  C. Crosstab Breaks
  D. Horizontal Breaks
  B. Vertical Breaks
  D. Horizontal Breaks

• Question 18:

  For which tasks do you use an If() function?

  A. To conditionally show rows in a block
  B. To conditionally execute a scheduled report
  C. To display dynamically grouped values
  D. To display a dynamic list of values
  A. To conditionally show rows in a block
  C. To display dynamically grouped values

• Question 19:

  You are creating a "Target Revenue Based on Required % Growth" variable that is represented by 5% revenue growth for California and 18% for Massachusetts. Which If() function statement is valid?

  A. =If[State] = "California" Then [Sales revenue] * 1.05 Else[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue]
  B. =If[State] = "California" Then [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue]
  C. =If[State] = "California" ; [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue]
  D. =If[State] = "California" Then [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue] End
  B. =If[State] = "California" Then [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue]

• Question 20:

  Which method should you use to view alerts in a report?

  A. Open "Query View"
  B. Click Tools > Alerters and select "View Alerters"
  C. Right-click anywhere in the report, select "Alerters"
  D. Select a block; on the toolbar, click the "Alerters" button
  D. Select a block; on the toolbar, click the "Alerters" button