IBM C2090-645 問題集

質問 1：
The following expression is used in a crosstab report: filter([sales_and_marketing]. [Product brand].[Product brand].[Product brand type],[Revenue]<100000000). There are 26 product brand types in the OLAP data source.

Why does the report only return 11 product brand type rows?
A. A dimensional function was used to filter on the total of the opposite edge.
B. A dimensional function was used to filter on each column.
C. A relational function was used to filter on the members, not the measure values.
D. A relational function was used to filter on the measure values, not the members.
正解：A

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

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

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

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

質問 6：
Why would a report author consider overriding the default drill behavior?
A. To drill down on a member and have its children display as details and have the member drilled on display as summary.
B. To maintain the behavior of a complex edge expression after drilling, such as one whichreturns the top 5 members of a set.
C. To drill down to the lowest level of the hierarchy and then drill down again to display only one member.
D. To replace all members within a hierarchy when drilling through to a report with more detail.
正解：B