IBM COG-645 問題集

質問 1：
A report author is working with an OLAP data source. The report author creates a query that uses a caption function on a member and applies a string function. What is a possible consequence of this action?
A. Mixing dimensional styles and relational styles in a single query can create unexpected results.
B. There is nothing wrong with this approach.
C. The mapped string values will not pass through to the target report.
D. Using these dimensional methods will not work with an OLAP data source.
正解：A

質問 2：
The "Sales" and "Inventory" data stores each have "Products" and "Time" dimensions. For drill-through between the data stores on the "Products" and "Time" dimensions to work, which items in the structures must be identical in the data stores?
A. Role value, internal keys
B. Hierarchy names, snowflake schema
C. Hierarchy names, member values
D. Level order, level names
正解：D

質問 3：
Of the following prompt syntax expressions, which two are considered to be dimensional?
1) <expression> -> ?<prompt name>?
2) <expression> in (?<prompt name>?)
3) <expression> = ?<prompt name>?
4) set(<expression> -> ?<prompt name>?)
A. 1 and 4
B. 1 and 2
C. 2 and 3
D. 3 and 4
正解：A

質問 4：
When the report consumer drills through from a dimensional member to a relational data item, what data type is passed?
A. Caption value
B. Business key
C. Category code
D. Member unique name
正解：B

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

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