IBM C2020-645 問題集

質問 1：
A report author uses an OLAP cube to create a crosstab with Revenue as a measure, the Product line level in the rows, and the year members (2004-2007) in the columns. How can the report author efficiently determine the difference in revenue between the years 2005 and 2006?
A. Create a set of the 2005 and 2006 members and aggregate it.
B. Ask the modeler to create a calculated category in Transformer and then use it directly.
C. Create a new column as a query calculation, and create the expression [2006]-[2005].
D. Determine MUNs for the years 2005 and 2006, and then create an expression using the MUNs.
正解：C

質問 2：
The report author uses the filter function to focus data in a report, but the results are unexpected. What did the report author overlook when filtering the data?
A. Root levels
B. Relational detail
C. Report context
D. Products hierarchy
正解：C

質問 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：
What is the default behavior when drilling down on an edge in a crosstab report?
A. All edge expressions of the crosstab are replaced with their children.
B. The level drilled on is replaced with the entire level below it.
C. The edge expression is changed to another item in the query.
D. The edge expression is replaced with the children of the item drilled on.
正解：D

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

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