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

質問 1：
A report author has created a crosstab report from the data source shown. The Retailer name level has been dragged to the rows and default drilling up and down has been activated.

What will be displayed in the report if the consumer drills up on one of the members of Retailer name?
A. The parent member of the member drilled on.
B. The members from the Region level.
C. The members from the Retailer country level.
D. The ancestors of the member drilled on from the whole Retailers hierarchy.
正解：C

質問 2：
The report author creates a query where two items (TopThree and Retailer country) exist in the same member set. The expression for TopThree is: topCount([Retailer country],3,[Revenue]).

What drill behavior should the report author set in order to display the top three children instead of all children on drill down?
A. Configure TopThree to Change Expression, and configure Retailer country to Preserve.
B. Configure TopThree to Ancestor, and configure Retailer country to Change Expression.
C. Configure TopThree to Preserve, and configure Retailer country to Preserve.
D. Configure TopThree to Preserve, and configure Retailer country to Replace Expression.
正解：D

質問 3：
What is a key difference between the total function and the aggregate function?
A. The aggregate function is dimensional, and the total function is relational.
B. The aggregate function will summarize only the currentMeasure, and the total function will summarize any specified measure.
C. The aggregate function can only summarize within a set, and the total function can accept separate members.
D. The aggregate function follows the rollup rules of the measure defined in the data source, and the total function adds the total of the specified measure.
正解：D

質問 4：
What type of prompt would a report author use to return a set of members from a hierarchy?
A. Tree prompt
B. Select and Search Prompt
C. Value prompt
D. Prompt Page
正解：A

質問 5：
A data source has a Time hierarchy, a Products hierarchy, and a Retailers hierarchy. What are the preferred techniques the report author would use to focus reports for this type of a data source?
A. Ancestors and descendants
B. Dimensional functions and slicers
C. Detail filters and summary filters
D. Use Members directly
正解：B

質問 6：
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