SAP C_BOWI_42 Online Practice Questions and Exam Preparation

SAP C_BOWI_42 Online Questions & Answers

• Question 241:

  To produce a report that focuses more precisely on certain data, you may need to apply more than one filter, and these filter must use Logical Operators.

  What are these Logical operators?

  There are 2 correct answers to this question

  Response:

  A. The AND operator
  B. The OR operator
  C. The ONE operator
  D. The PLUS operator
  A. The AND operator
  B. The OR operator

• Question 242:

  Which Pos() function syntax should you use to find the location of the space in the Category string "Evening wear"?

  Please choose the correct answer.

  Response:

  A. Pos([Category] , "" )
  B. Pos((Category) , "" )
  C. Pos([Category] ; " " )
  D. Pos({Category} ; " " )
  C. Pos([Category] ; " " )

• Question 243:

  What are the two relational operators that can be used with wildcard Characters, in a query filter?

  There are 2 correct answers to this question

  Response:

  A. Design pattern: to find values that match the design you specify
  B. Matches pattern: to find values that match the pattern you specify
  C. Different from pattern: to find values different than the pattern you specify
  D. Defined pattern: to find values that match the defined pattern you specify
  B. Matches pattern: to find values that match the pattern you specify
  C. Different from pattern: to find values different than the pattern you specify

• Question 244:

  Which two methods can you use to aggregate measures at the section level in BusinessObjects Web Intelligence 4.0?

  There are 2 correct answers to this question.

  Response:

  A. Drag the measure from the Data tab into the section header.
  B. Copy the measure from the Data tab into the section header.
  C. While pressing the ALT key, drag the measure from the table to the section header.
  D. While pressing the CTRL key, drag the measure from the table to the section header.
  A. Drag the measure from the Data tab into the section header.
  D. While pressing the CTRL key, drag the measure from the table to the section header.

• Question 245:

  Which three statements are true of calculation contexts? There are 3 correct answers to this question. Response:

  A. If no context is defined the default context is assumed.
  B. You can use NoFilter() as an extended syntax keyword when using contexts.
  C. The ForEach context operator automatically takes the dimensions in the block into account.
  D. You must place parentheses around the values listed after the Where keyword when using the Where operator.
  A. If no context is defined the default context is assumed.
  C. The ForEach context operator automatically takes the dimensions in the block into account.
  D. You must place parentheses around the values listed after the Where keyword when using the Where operator.

• Question 246:

  The universe is made up of classes and objects; there are three different types of objects.

  What are they?

  There are 3 correct answers to this question

  Response:

  A. Analyze ?Analysis of data for required result
  B. Dimension -Typically retrieve character-type data
  C. Detail -Provides descriptive data about a dimension
  D. Measure - Retrieves numeric data that is the result of calculations on data in the database
  E. Improve- Selecting and implementation of the best solution
  B. Dimension -Typically retrieve character-type data
  C. Detail -Provides descriptive data about a dimension
  D. Measure - Retrieves numeric data that is the result of calculations on data in the database

• Question 247:

  What is the output of the following expression when the CurrentDate is January 31, 2014?

  If (MonthNumberOfYear(CurrentDate()) = l;

  Year(CurrentDate())-l;

  Year(CurrentDate()))

  A. 01/31/2014
  B. 2014
  C. 01/31/2013
  D. 2013
  D. 2013

• Question 248:

  You use the Last Refresh Date cell from the Templates in the Report Manager on your report page. You then reformat the cell as Tuesday, January 22, 2014. What is the result when you edit the formula, using the Formula toolbar, to

  concatenate the string "Last Refresh Date: " and the LastExecutiondate() function?

  Please choose the correct answer.

  Response:

  A. The cell reads "Last Refresh Date: 1/22/14".
  B. The "Computation Error" error message is displayed.
  C. The "Incompatible Data Types" error message is displayed.
  D. The cell reads "Last Refresh Date: {Tuesday, January 22, 2014}".
  A. The cell reads "Last Refresh Date: 1/22/14".

• Question 249:

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

  There are 2 correct answers to this question.

  Response:

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

• Question 250:

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

  Please choose the correct answer.

  Response:

  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