IBM C2090-645 問題集

質問 1：
Which of the following statements is true about a slicer?
A. It affects the values of the cells of the report but not the rows or columns.
B. It determines which set of members are displayed on the edges of the report.
C. It keeps the summary column in the report, and removes the detail columns.
D. It removes all blank rows in the report to make it more focused.
正解：A

質問 2：
A report author creates a crosstab as shown.

What is the default measure of the report?
A. Mountaineering Equipment
B. Gross profit
C. Revenue
D. Camping Equipment
正解：C

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

質問 4：
A report author uses the following expression: lastPeriods(3,[2007/Mar]). What data will be returned when the report is run?
A. 3 months, including 2007/Mar and the preceeding 2 months
B. The last 3 months before 2007/Mar
C. The month March of each of the 3 years 2005, 2006, and 2007
D. The total of currentMeasure for 3 months including 2007/Mar and the preceeding 2 months
正解：A

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

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