SAP C_BOWI_30 問題集

質問 1：
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. Resave the document with data tracking formats enabled.
B. Edit the document in tracking mode.
C. Open the document in tracking mode.
D. Contact the system administrator.
正解：D

質問 2：
Which three statements are true of calculation contexts? (Choose three.)
A. You must place parentheses around the values listed after the Where keyword when using the Where operator.
B. The ForEach context operator automatically takes the dimensions in the block into account.
C. You can use NoFilter() as an extended syntax keyword when using contexts.
D. If no context is defined the default context is assumed.
正解：A,B,D

質問 3：
Which method can you use to change the object qualification of an object within Web Intelligence Rich Client?
A. In the Query panel, select the qualification.
B. Select the object, right-click and select the qualification.
C. In the Document Properties, select the qualification.
D. In Query View, right-click and select the qualification.
正解：A

質問 4：
Which two statements about the If() function are correct? (Choose two.)
A. Contains a Boolean expression
B. Can contain a Case expression
C. Can contain nested If() statements
D. Can contain a SQL statement
正解：A,C

質問 5：
You use the Last Refresh Date cell from the Templates in the Report Manager on your report page. You then reformat the cell as Tuesday, January 22, 2008. What is the result when you edit the formula, using the Formula toolbar, to concatenate the string "Last Refresh Date: " and the LastExecutiondate() function?
A. The cell reads "Last Refresh Date: 1/22/08".
B. The "Computation Error" error message is displayed.
C. The cell reads "Last Refresh Date: {Tuesday, January 22, 2008}".
D. The "Incompatible Data Types" error message is displayed.
正解：A

質問 6：
Which two operators are available when using wildcards in a query filter? (Choose two.)
A. Not equals Pattern
B. Matches Pattern
C. Different from Pattern
D. LIKE
正解：B,C

質問 7：
Which two functions could you use to concatenate the First Name and Last Name objects? (Choose two.)
A. =[First Name]+[Last Name]
B. =[First Name]||[Last Name]
C. =[First Name]&[Last Name]
D. =Concatenation([First Name];[Last Name])
E. =Concatenation([First Name],[Last Name])
正解：A,D

質問 8：
Which method should you use to force each section of a report to start on a new page?
A. Select the section, Press CTRL-Enter.
B. Select the section; click Report > Section and select "Start on New Page".
C. Right-click the section, select "Start Section on New Page".
D. Select the section; in the Properties tab, check "Start on New Page".
正解：D

質問 9：
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. IgnoreFilter()
B. NoRank()
C. AverageAll()
D. NoFilter()
正解：D