IBM C2020-645 問題集

質問 1：
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 Replace Expression.
D. Configure TopThree to Preserve, and configure Retailer country to Preserve.
正解：C

質問 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. Depth Based Expression
B. Replace Expression
C. Replace Item
D. Preserve
正解：D

質問 3：
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. Camping Equipment, Revenue, 2006
B. Nothing, singletons are not dimensional objects.
C. 500,382,422.83
D. Camping Equipment, 500,382,422.83, 2006
正解：C

質問 4：
Which of the following statements is true about a slicer?
A. It affects the values of the cells of the report but not the rows or columns.
B. It determines which set of members are displayed on the edges of the report.
C. It keeps the summary column in the report, and removes the detail columns.
D. It removes all blank rows in the report to make it more focused.
正解：A

質問 5：
When a report author inserts Revenue into the Measures area of a blank crosstab report, which of the following statements is correct?
A. The report author has declared a currentMember function to return the Revenue data.
B. The report author must validate the expression for Revenue to ensure there are no crosstab errors.
C. The report author has implicitly set the default measure for the crosstab report to be Revenue.
D. The report author must verify the aggregation properties of Revenue to make sure it will display correctly.
正解：C

質問 6：
Which statement is true about MUNs?
A. They are used to retrieve members from the data source.
B. They change each time the package is published.
C. They are used to retrieve levels from the data source.
D. They are used to define roll-up properties in a hierarchy.
正解：A