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
質問 2:
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. Determine MUNs for the years 2005 and 2006, and then create an expression using the MUNs.
C. Create a new column as a query calculation, and create the expression [2006]-[2005].
D. Ask the modeler to create a calculated category in Transformer and then use it directly.
正解: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:
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
質問 5:
What does the following expression do: "generate([Product line],topCount(descendants(currentMember([sales_and_marketing].[Products].[Products]),[sales_a nd_marketing].[Products].[Products].[Product]),2,[Revenue]))"?
A. Finds the top two members by revenue at the product level and returns their respective ancestors at the product line level.
B. Calculates the top two product lines for each product.
C. Goes two levels up from products and returns the top members by revenue at that level.
D. Returns the top two products by revenue for each product line.
正解:D
質問 6:
Can a prompt be used in the expression of a slicer?
A. No, the slicer syntax is not compatible with prompt syntax.
B. Yes, if the correct syntax is used.
C. No, the slicer must be manually created by the report author.
D. Yes, if the slicer is a hierarchy.
正解:B
安部** -
C2090-645出題がされているので非常に役に立っています。おすすめできます。