C_BOWI_42 実際試験問題と解答 - 模擬練習 - 受験自信を増やす

Question No : 1
From the following identify which of the option is not a method to copy a chart from Web Intelligence to a target application? Please choose the correct answer.

A.Right-click the chart, and, from the contextual menu, select Copy.
B.In the target document, right-click the section cell and, from the contextual menu, click Copy
C.In the target document, right-click the area where you want the table to appear and, from the contextual menu, select Paste
D.Drag and drop the table from Web Intelligence to the target application

正解:

Question No : 2
You want to compare the sales revenue performance of the top 20% of your customers to the average of all of your customers.
You decide to apply a rank on the table that shows customers and revenue and create a variable to show the average revenue for all customers.
Which function should you use in the variable?

A.NoFilter()
B.NoRank()
C.AverageAll()
D.IgnoreFilter()

正解:

Question No : 3
Which method should you use to group query filters together to form one AND statement? Please choose the correct answer.

A.Drag the queries together
B.Drag the query filters to the Group panel
C.Select the filters, right-click and select Group
D.Select the filters, then click the Group Filters button on the toolbar

正解:

Question No : 4
For what purposes can you use the Page Layout of a report? There are 2 correct answers to this question.

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.

正解:

Question No : 5
You have a regional sales report with State, City and Sales Revenue dimensions. You want to create a variable that excludes State from the output context.
Which output statement should you use? Please choose the correct answer.

A.In([State])
B.Out([State])
C.ForAll([State])
D.ForEach([State])

正解:

Question No : 6
Your report contains a table.
What happens when you drop a dimension object into a blank part of this report? Please choose the correct answer.

A.A new group is created.
B.A new block is created.
C.A new free-standing cell is created.
D.A new section is created.

正解:

Question No : 7
Which function would you use to extract the word "casual" from the product name "casual pants" of the Product Name field? Please choose the correct answer.

A.Left(5; [Product Name])
B.Left([Product Name]; 5)
C.Right((Product Name), 5)
D.Right(5, [Product Name])

正解:

Question No : 8
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

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

正解:

Question No : 9
Which three output context expressions are valid extended syntax expressions? There are 3 correct answers to this question.

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")

正解:

Question No : 10
Which two settings can you configure for the Sample option in the Properties tab of the Web Intelligence Query panel? There are 2 correct answers to this question.

A.You can enable the "Fixed" option.
B.You can set the "Max retrieval time".
C.You can set the "Max rows retrieved".
D.You can specify a "Sample Result" set.

正解:

Question No : 11
Which type of relationship links sub-queries by default? Please choose the correct answer.

A.OR
B.AND
C.NOR
D.NAND

正解:

Question No : 12
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.

A.TXT
B.XML
C.CSV
D.XLS

正解:

Question No : 13
How do you duplicate a query? Please choose the correct answer.

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

正解:

Question No : 14
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.

A.1.00
B.1.05
C.1.10
D.1.15
E.1.18

正解:

Question No : 15
Which method can you use to hide data using an alerter? Please choose the correct answer.

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

正解:

SAP C_BOWI_42 問題練習