IBM COG-645 問題集

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

質問 2：
Assuming that Star products and Husky products are sets,

which statement below is correct about the sets in the graphic?
A. Each set can be sorted and aggregated.
B. The query displays each set as all the members of the level.
C. The report creates a query for each member of the set.
D. Each set is a grouping of members from different hierarchies.
正解：A

質問 3：
Which of the following are dimensional objects?
A. Sets and query calculation
B. Level and member
C. Slicer and string function
D. Query subject and relationship cardinality
正解：D

質問 4：
Which of the following statements is correct about the order function?
A. It arranges members of a set alphabetically by ascending or descending captions.
B. The currentMeasure function must be used with the order function as the sort by criterion.
C. Optional parameters allow the author to order the members of a hierarchy without regard of their level.
D. It arranges members of all sets in the report by ascending or descending values.
正解：C

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

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