SAP SAP Certifications C_BOWI_41 Questions & Answers

• Question 61:

  Which combination of functions should you use to convert the string "13/11/46 12:00:00 AM" to "Wednesday 13 Nov 1946"?

  A. Right() using Pos(), ToDate(), FormatDate()

  B. SubStr() using Pos(), ToDate(), FormatDate()

  C. Right() using Pos(), CurrentDate(), FormatDate()

  D. SubStr() using Pos(), CurrentDate(), FormatDate()

  Correct Answer: B

• Question 62:

  Which method should you use to see report filters?

  A. Right-click the report and select "Show Filter Pane"

  B. On the toolbar, click the "Show/Hide Filter Pane" button

  C. In the Filters panel, enable the "Show Report Filters" option

  D. In InfoView Preferences, enable the "Show Report Filters" option

  Correct Answer: B

• Question 63:

  How do you duplicate a query?

  A. Choose Duplicate Query in the Tools Menu

  B. Select Duplicate Query in Properties in the Query Panel

  C. Right-click Query in the Report Manager and select Duplicate Query

  D. Right-click the Query Tab in the Query Panel and select Duplicate Query

  Correct Answer: D

• Question 64:

  Which function would you use to extract the word "casual" from the product name "casual pants" of the Product Name field?

  A. Left(5; [Product Name])

  B. Left([Product Name]; 5)

  C. Right((Product Name), 5)

  D. Right(5, [Product Name])

  Correct Answer: B

• Question 65:

  You are working with a set of store revenues. All stores have positive revenue values.

  Which formula should you use to display the variance value of the Revenue measure in your document when data tracking is active?

  A. =[Revenue]/RefValue([Revenue])

  B. =[Revenue]/PreValue([Revenue])

  C. =[Revenue]/HistValue([Revenue])

  D. =[Revenue]/BaseValue([Revenue])

  Correct Answer: A

• Question 66:

  For what purposes can you use the Page Layout of a report?

  A. To display the definition of the block.

  B. To define how the report will look like in PDF mode.

  C. To define how the report will look like when printed.

  D. To display the report page by default.

  Correct Answer: BC

• Question 67:

  Which property do you enable to keep rows in a break together on the same page?

  A. The "Start on New Page" property in the Format Section.

  B. The "Start on New Page" property.

  C. The "Avoid page breaks in block" property.

  D. The "Avoid page break" property in the Format Section.

  Correct Answer: C

• Question 68:

  Which three options are valid Page Layout Options in the Properties tab of a document?

  A. Top margin

  B. Left margin

  C. Page orientation

  D. Background color

  E. Visited hyperlink colors

  Correct Answer: ABC

• Question 69:

  In the creation of a document, you have to import a personal data file. The data file contains date information, but when the file is imported, the dates are imported as character strings.

  Which function should you use to change the format from string to date?

  A. Date()

  B. Char()

  C. ToChar()

  D. ToDate()

  Correct Answer: D

• Question 70:

  Where are contexts created?

  A. In a report

  B. In a universe

  C. In a derived table

  D. At the database level

  Correct Answer: B