SAP SAP Certifications C_BOWI_42 Questions & Answers

• Question 61:

  Which of the following option is not a part of The Web Intelligence Query Process?

  Please choose the correct answer.

  Response:

  A. Run the query

  B. Launch panel to generate data

  C. SQL is executed to extract data

  D. Report is displayed

  Correct Answer: B

• Question 62:

  Which two panels can you use to purge data from a BusinessObjects Web Intelligence 4.0 document (WID)?

  There are 2 correct answers to this question.

  Response:

  A. Query

  B. Report

  C. Active X

  D. Slice and Dice

  Correct Answer: AB

• Question 63:

  You are creating a report to summarize the number of cars sold by region. Which object should you use to aggregate the number of cars sold?

  Please choose the correct answer.

  Response:

  A. Sum

  B. Detail

  C. Measure

  D. Dimension

  Correct Answer: C

• Question 64:

  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?

  Please choose the correct answer.

  Response:

  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

  Correct Answer: B

• Question 65:

  You want to force the calculation context of a variable in a table so that its values do not change when a dimension is added to the table. Which of the following statements is correct?

  Please choose the correct answer.

  Response:

  A. You include the dimension using the input context.

  B. You exclude the dimension using the input context.

  C. You include the dimension using the output context.

  D. You exclude the dimension using the output context.

  Correct Answer: D

• Question 66:

  Which is a benefit of using query drill? Please choose the correct answer. Response:

  A. Data is pre-fetched and stored for all levels prior to drill.

  B. Data is pre-formatted and stored for all levels prior to drill.

  C. Dedicated SQL statements are generated for each drill.

  D. Levels you can drill through are based on your security profile.

  Correct Answer: C

• Question 67:

  What all changes you can define and make with the LAYOUT option, to format a Table?

  There are 2 correct answers to this question

  Response:

  A. To define relative pattern of the table on the page

  B. To define horizontal and vertical start on new page

  C. To define rows and columns and background image

  D. Avoid page break and repeat on every page options

  Correct Answer: BD

• Question 68:

  Which of the following options are use to create a default vertical table?

  There are 2 correct answers to this question

  Response:

  A. Create a validate query

  B. Create a new query

  C. Run a new query

  D. Run query panel

  Correct Answer: BC

• Question 69:

  Why would you use the FormatDate() function? There are 2 correct answers to this question. Response:

  A. To modify the format of a string object into a non-standard date format.

  B. To convert a string object into a date object.

  C. To convert a date object into a string object.

  D. To format a date so that it is displayed as a string when it is concatenated with another string.

  Correct Answer: CD

• Question 70:

  Where should you configure the regional settings of a Web Intelligence document (WID) within InfoView?

  Please choose the correct answer.

  Response:

  A. Local Settings

  B. Browser Preferences

  C. User Machine Settings

  D. InfoView Preferences

  Correct Answer: D