Which of the following statements is correct about the order function?
A. Optional parameters allow the author to order the members of a hierarchy without regard of their level.
B. It arranges members of a set alphabetically by ascending or descending captions.
C. The currentMeasure function must be used with the order function as the sort by criterion.
D. It arranges members of all sets in the report by ascending or descending values.
正解:A
質問 2:
What dimensional function is used to return the members on the level below the Product line level?
A. Set
B. members
C. Descendants
D. Children
正解:C
質問 3:
Assuming that Star products and Husky products are sets,
which statement below is correct about the sets in the graphic?
A. Each set is a grouping of members from different hierarchies.
B. The query displays each set as all the members of the level.
C. Each set can be sorted and aggregated.
D. The report creates a query for each member of the set.
正解:C
質問 4:
When must a report author use the caption function?
A. To pass the returned value to a drill-through target report,this expects a matching string as a parameter value.
B. As the first parameter of the roleValue function.
C. To return the display name for the specified business key.
D. To see the string display name for the specified element.
正解:A
質問 5:
Which of the following is true if a report author nests members in a crosstab report?
A. The inner member must be on the level immediately below the outer member.
B. Nested members are also known as complex members.
C. Nested members must be members of hierarchies, not of the Measures folder.
D. It is possible to nest members from different dimensions.
正解:D
質問 6:
The dialog box shown appears when a report is run.
What should the report author do to correct the situation?
A. Modify the expression to change the 'currentMember' function to 'currentHierarchy'.
B. Modify the expression to 'currentMember([sales_and_marketing].[Products].[Products])'.
C. Ask the modeler to rename the hierarchy to '[sales_and_marketing].[Products].[Products].[Products]', and to republish the package.
D. Modify the expression to change the 'currentMember' function to 'currentLevel'.
正解:B
Miyagawa -
C2090-645解説はいずれもセキュリティのプロが行っているので、確かな知識が身に付き、得点に結びつきます。