SAP SAP Certifications C_BOWI_42 Questions & Answers

• Question 111:

  Which message appears when you select "Use query drill" while Scope of Analysis is set in a BusinessObjects Web Intelligence 4.0 report?

  Please choose the correct answer.

  Response:

  A. The Scope of Analysis is empty.

  B. The Scope of Analysis is not empty.

  C. The query drill mode option is enabled.

  D. The query drill mode option is not enabled.

  Correct Answer: B

• Question 112:

  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?

  Please choose the correct answer.

  Response:

  A. Format cell

  B. Hide cell

  C. Align text

  D. Format number

  Correct Answer: D

• Question 113:

  How does rearranging the objects in the Result pane after the query has run affect the block display?

  Please choose the correct answer.

  Response:

  A. The objects are rearranged in the block based on the order in the Results Objects pane.

  B. The reordered objects are removed from the block.

  C. The block is sorted in ascending order based on the first object in the Results Objects pane.

  D. The block remains unchanged.

  Correct Answer: D

• Question 114:

  Which statement is true about calculation contexts?

  Please choose the correct answer.

  Response:

  A. They allow manipulation of reports to change the way the data is displayed.

  B. They allow manipulation of variables to change the way the data is aggregated.

  C. They allow manipulation of universe objects to change the way the data is displayed.

  D. They allow manipulation of universe contexts to change the way the data is aggregated.

  Correct Answer: B

• Question 115:

  Design mode provides access to the following toolboxes and their associated functions.

  What are they?

  There are 3 correct answers to this question

  Response:

  A. Improve function

  B. Matches data task

  C. Report Element

  D. Data Access

  E. Analysis task

  Correct Answer: CDE

• Question 116:

  What can you use breaks for? Please choose the correct answer. Response:

  A. To create a section

  B. To create multiple table blocks

  C. To remove repeated values in one table block

  D. To manipulate the navigation path

  Correct Answer: C

• Question 117:

  Which DaysBetween() function syntax should you use to calculate the number of years since your birth, assuming the date object is Birth_date?

  Please choose the correct answer.

  Response:

  A. =DaysBetween([Birth_date] ; CurrentDate ) / 365.25

  B. =DaysBetween([Birth_date] , CurrentDate() ) / 365.25

  C. =DaysBetween([Birth_date] ; CurrentDate() ) / 365.25

  D. =DaysBetween(CurrentDate() ; [Birth_date] ) / 365.25

  Correct Answer: C

• Question 118:

  Which two are limitations of a detail object? There are 2 correct answers to this question. Response:

  A. It cannot be drilled on.

  B. It cannot be used in the report filter.

  C. It cannot be merged in a document.

  D. It cannot be used in the WHERE statement of the query.

  Correct Answer: AC

• Question 119:

  Which two statements are true about Page Layout of a report?

  There are 2 correct answers to this question.

  Response:

  A. It displays the definition of the block.

  B. It displays the report page by default.

  C. It defines what the report will look like when printed.

  D. It defines what the report will look like in PDF mode.

  Correct Answer: CD

• Question 120:

  In which two situations should you use sub-queries? There are 2 correct answers to this question. Response:

  A. When the query filter involves values that are known

  B. When the query filter involves values that are not known

  C. When the query filter for the report involves a value that will change over time

  D. When the query filter for the report involves a value that will never change over time

  Correct Answer: BC