C2090-645 Online Practice Questions and Answers

When would a report author define a set?

A. To create a slicer to focus on a specific number of years of data in a report.

B. To change the crosstab node member properties for a level.

C. To use as a summaryfunction to return the total of the specified members.

D. To return members from different hierarchies of the same dimension.

To create a report from the data source shown, what entities will the report author use?

A. Members

B. Values

C. Attributes

D. MUNs

What is true about MUNs?

A. A MUN is abusiness key that allows drill through between packages.

B. A MUN is a key with a unique value at each level.

C. A MUN contains the fully qualified path to a member.

D. A MUN is a category code that is generated when the cube is built.

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 report creates a query for each member ofthe set.

C. The query displays each set as all the members of the level.

D. Each set can be sorted and aggregated.

A report author can use a slicer to dowhat?

A. Make the report database smaller and efficient

B. Provide context to intersection values

C. Reduce the number of members on the edge of the crosstab.

D. Generate a zero suppression filter in the rows

A report author creates a report with a drill-through definition. In the target report the parameter expression is "->?P?".

What type of data must be passed to the parameter?

A. A member from the level

B. Any member from the hierarchy

C. A value

D. A business key from the level

What dimensional function is used to return the members on the level below the Product line level?

A. Set

B. Children

C. Descendants

D. members

Based on the crosstab displayed, the report author creates a singleton using the tuple function as follows: tuple([Camping Equipment],[Revenue],[2006]).

Which of the following will appear in the singleton when the report is run?

A. Camping Equipment, 500,382,422.83, 2006

B. 500,382,422.83

C. Camping Equipment, Revenue, 2006

D. Nothing, singletons are notdimensional objects.

A report author creates an expression usingthe closingPeriod function to return the latest month found in the data source, and names the expression "Current Month".

What can the report author do with "Current Month"?

A. Use it to replace the lastPeriods(1,[Month]) expression currently in the report.

B. Add it to an expression to find the current member for the Month level.

C. Use it to determine the current quarter: parent([Current Month]).

D. Use it as a report expression to display the current month in the page header of the report.

A report author creates the following nestedreport 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. Replace Expression

B. Depth Based Expression

C. Preserve

D. Replace Item