最新なIBM COG-645問題集（57題）、真実試験の問題を全部にカバー！

質問 1：
Based on the crosstab displayed, the report author creates a singleton using the tuple function as follows: tuple([Camping Equipment],[Revenue],[2006]).

Which of the following will appear in the singleton when the report is run?
A. 500,382,422.83
B. Camping Equipment, Revenue, 2006
C. Nothing, singletons are not dimensional objects.
D. Camping Equipment, 500,382,422.83, 2006
正解：A

質問 2：
A report author creates the following nested report using 2 adjacent levels of the same hierachy. Users should be able to drill down on the inner nesting with the outer nesting remaining unchanged.

What advanced drilling behavior should the report author use to achieve this?
A. Replace Item
B. Depth Based Expression
C. Preserve
D. Replace Expression
正解：C

質問 3：
A report author creates a report with a drill-through definition. In the target report the parameter expression is "<Level expression> ->?P?". What type of data must be passed to the parameter?
A. A business key from the level
B. A member from the level
C. A value
D. Any member from the hierarchy
正解：B

質問 4：
In a crosstab report, the report author wants a column to display a percentage of overall revenue that a particular product contributed to.

Which of the following is a valid dimensional expression for this purpose?
A. [Revenue]/tuple([Revenue],[Products])
B. [Revenue]/([Revenue]*[Products])
C. tuple([Revenue]/[Products]*[Revenue])
D. [Revenue]/total([Revenue]for[Products])
正解：A

質問 5：
Which of the following statements is true about explicitly defined member sets?
A. They are automatically configured for default drill behavior.
B. They must have drill behavior defined manually.
C. They assume the drill behavior from the top member set in the same branch.
D. They are too complex to enable drilling.
正解：B

質問 6：
The sales manager requires a crosstab report to display the top 3 sales people for the month. Considering that an OLAP data source is used, what will the report author use when creating this report?
A. A set expression
B. A percent of base calculation
C. An axis title
D. The hierarchize function
正解：A