IBM C2090-645 問題集

質問 1：
What does the following expression do: "generate([Product line],topCount(descendants(currentMember([sales_and_marketing].[Products].[Products]),[sales_a nd_marketing].[Products].[Products].[Product]),2,[Revenue]))"?
A. Returns the top two products by revenue for each product line.
B. Goes two levels up from products and returns the top members by revenue at that level.
C. Calculates the top two product lines for each product.
D. Finds the top two members by revenue at the product level and returns their respective ancestors at the product line level.
正解：A

質問 2：
Based on the diagram,

if the expression firstSibling([2006 Q 1]) is used in the report, what item will be returned?
A. Nothing, because the return value equals the parameter
B. 2006 Q 1
C. 2005 Q 1
D. 2006 Q 4
正解：B

質問 3：
The report author wants to create a report to compare the sales of product types for special sales promotions in 2005 and 2006, but the report will exclude regular sales. Which style of authoring and which function will the report author use to create this report from a cube data source?
A. Dimensional authoring style, filter function
B. Relational authoring style, except function
C. Dimensional authoring style, except function
D. Relational authoring style, filter function
正解：C

質問 4：
A report author creates a revenue report from an OLAP data source. On the rows, there are nested levels, each from different dimensions having a large number of members. The report author filters out empty rows using the expression "[Revenue] > 0". When running this report, there is poor performance. What could cause this?
A. A relational filter was applied.
B. There are too many members or levels nested on the row edge.
C. Limiting the crosstab measures with a filter function.
D. Filtering on measure values is incompatible with an OLAP data source.
正解：A

質問 5：
Instead of prompting the user to select any countries in Europe, the report author wants to constrain the user to select one or more countries from the Northern Europe region. What kind of prompt should be used and how can this be achieved?
A. Create a multi-select value prompt. Populate it using an expression on the [Northern Europe] member to retrieve its children on the country level.
B. This is not possible because a prompt must always be populated with all members of a level.
C. Create a tree prompt, and populate it using an expression on the [Northern Europe] member to retrieve its children at the country level.
D. Generate a prompt by creating an expression with aparameter on the crosstab edge:children([Northern Europe]->?Country?
正解：A

質問 6：
The author has created a complex expression called "Sorted Products" on the row edge, which sorts product line by Revenue for 2006.

What must the report author do to sort the members when drilling down?
A. Set the behavior to Depth Based Expression, to maintain sorting at a lower level in the data source.
B. Configure the Ancestor drill behavior on the Sorted Products expression.
C. Preserve the Sorted Products expression, but replace the underlying Product Set expression.
D. Nothing, as the default drill behavior is sufficient in this case, to maintain sorting of the children.
正解：C