SAP SAP Certified Application Associate C_BOWI_42 Questions & Answers

• Question 1:

  Which options can you select when you save a Web Intelligence document (WID)? (Choose two.)

  A. Permanent regional formatting

  B. Associate universe

  C. Send to users

  D. Refresh on open

  Correct Answer: AD

• Question 2:

  Which panel should you use to create sub-queries?

  A. Query Panel

  B. Report Panel

  C. Data Panel

  D. Slice and Dice Panel

  Correct Answer: A

• Question 3:

  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. ForAll

  C. All

  D. ForEach

  Correct Answer: D

• Question 4:

  You open a Web Intelligence document (WID) with tracked data changes. You wish to change the color of the tracked data. You however cannot change the format of the tracked data. What should you do to enable formatting of the tracked data?

  A. Open the document in tracking mode.

  B. Contact the system administrator.

  C. Edit the document in tracking mode.

  D. Resave the document with data tracking formats enabled.

  Correct Answer: B

• Question 5:

  Which two operators are available when using wildcards in a query filter? (Choose two.)

  A. Different from Pattern

  B. Matches Pattern

  C. Not equals Pattern

  D. LIKE

  Correct Answer: AB

• Question 6:

  Which object types can you merge when using Multi Queries in a Web Intelligence document (WID)?

  A. Dimension - Detail

  B. Dimension - Dimension

  C. Dimension - Measure

  D. Measure - Measure

  Correct Answer: B

• Question 7:

  Which option can you use to convert a table block into a chart in Web Intelligence Rich Client?

  A. Click Format > Charts and select "Convert to Chart"

  B. Click Tools > Charts and select "Change Table to Chart"

  C. Right-click the table block and select "Turn To"

  D. Right-click the table block and select "Convert to Chart"

  Correct Answer: C

• Question 8:

  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. ToDate()

  B. Date()

  C. ToChar()

  D. Char()

  Correct Answer: A

• Question 9:

  Which two functions could you use to concatenate the First Name and Last Name objects? (Choose two.)

  A. =Concatenation([First Name],[Last Name])

  B. =[First Name]+[Last Name]

  C. =Concatenation([First Name];[Last Name])

  D. =[First Name]and[Last Name]

  E. =[First Name] | | [Last Name]

  Correct Answer: BC

• Question 10:

  Which two operators are used as calculation context operators? (Choose two.)

  A. Select

  B. Where

  C. In

  D. Having

  Correct Answer: BC