SAP SAP Certifications C_BOWI_42 Questions & Answers

• Question 151:

  Which three output context expressions are valid extended syntax expressions?

  There are 3 correct answers to this question.

  Response:

  A. Where ([State] = "CA")

  B. Where Section In [State]

  C. In Block Where Section = [State]

  D. In Section Where ([State] = "CA")

  E. Where ([State]="CA" And [Year] ="2006")

  Correct Answer: ADE

• Question 152:

  In the Web Intelligence Desktop, when you save a document as an Excel file, you can specify which reports saving; Following are the options available to save and export data?

  There are 2 correct answers to this question

  Response:

  A. Prioritize data analysis in the Excel document

  B. Prioritize the format of reports in the Excel document

  C. Prioritize easy data processing in the Excel document

  D. Prioritize the selection of best solution in the Excel document

  Correct Answer: BC

• Question 153:

  Which three types of local data files can you use to create a BusinessObjects Web Intelligence 4.0 document (WID)?

  There are 3 correct answers to this question.

  Response:

  A. TXT

  B. XML

  C. CSV

  D. XLS

  Correct Answer: ACD

• Question 154:

  Which type of relationship links sub-queries by default?

  Please choose the correct answer.

  Response:

  A.OR

  B. AND

  C. NOR

  D. NAND

  Correct Answer: B

• Question 155:

  How do you duplicate a query? Please choose the correct answer. Response:

  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 156:

  A variable in your report contains the statement:

  =If[State] = "California" Then [Sales revenue] * 1.05 Else If[State] = "Colorado" Then [Sales revenue] *

  1.1 Else If[State] InList ("DC";"Texas ") Then [Sales revenue] * 1.15 Else If[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue]

  Sales revenue for Florida is $1,879,159. Which rate is applied to the Florida revenue by the formula?

  Please choose the correct answer.

  Response:

  A. 1.00

  B. 1.05

  C. 1.10

  D. 1.15

  E. 1.18

  Correct Answer: A

• Question 157:

  Which method can you use to hide data using an alerter?

  Please choose the correct answer.

  Response:

  A. Build an alerter that removes the column.

  B. Build an alerter that applies a formula that changes the block value.

  C. Build an alerter with a formula that changes the font color to the background color.

  D. Click anywhere in the document. On the toolbar, click the "Data" button and select "Hide Data".

  Correct Answer: C

• Question 158:

  Which two data sources can you directly access from a Web Intelligence document (WID) using the Web Intelligence Rich Client?

  There are 2 correct answers to this question.

  Response:

  A. Universe

  B. Text File

  C. Web Service

  D. OLAP Cube

  Correct Answer: AB

• Question 159:

  Which two methods can you use to define document properties?

  There are 2 correct answers to this question.

  Response:

  A. Click the report tab, select "Document Properties" and enter the required information.

  B. Right-click the report tab, select "Document Properties" and enter the required information.

  C. Right-click a blank space on the report page, select "Document Properties" and enter the required information.

  D. In the Properties tab of the Report Manager, select "Document Properties" and enter the required information.

  Correct Answer: BC

• Question 160:

  Which method should you use to store a Web Intelligence Rich Client document in an enterprise secured location?

  Please choose the correct answer.

  Response:

  A. Save the document to the Enterprise directories

  B. Save the document to the Enterprise documents.

  C. Export the document to the Central Management Server (CMS).

  D. Export the document to the Central Configuration Manager (CCM).

  Correct Answer: C