C2090-645 Online Practice Questions and Answers

A data source has a Time hierarchy, a Products hierarchy, and a Retailers hierarchy. What are the preferred techniques the report author would use to focus reports for this type of a data source?

A. Dimensional functions and slicers

B. Use Members directly

C. Ancestors and descendants

D. Detail filters and summary filters

Which of the following are dimensional objects?

A. Sets and query calculation

B. Query subject andrelationship cardinality

C. Slicer and string function

D. Level and member

The sales manager requires a crosstab report to display the top 3 sales people for the month. Considering that an OLAP data source is used, what will the report author use when creating this report?

A. A set expression

B. An axis title

C. A percent of base calculation

D. The hierarchize function

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

When must a report author use the caption function?

A. As the first parameter of the roleValue function.

B. To return the display name for thespecified business key.

C. To see the string display name for the specified element.

D. To pass the returned value to a drill-through target report, this expects a matching string as a parameter value.

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.

Of the following prompt syntax expressions, which two are considered to be dimensional?

1) -> ??

2) in (??)

3) = ??

4) set( -> ??)

A. 1 and 4

B. 1 and 2

C. 2 and 3

D. 3 and 4

The report author creates a query where two items (TopThree and Retailer country) exist in the same member set. The expression for TopThree is: topCount([Retailer country],3,[Revenue]).

What drill behavior should the report author set in order to display the top three children instead of all children on drill down?

A. Configure TopThree to Change Expression, and configureRetailer country to Preserve.

B. Configure TopThree to Preserve, and configure Retailer country to Preserve.

C. Configure TopThree to Preserve, and configure Retailer country to Replace Expression.

D. Configure TopThree to Ancestor, and configure Retailercountry to Change Expression.

Which of the following is true if a report author nests members in a crosstab report?

A. Nested members are also known as complex members.

B. The inner membermust be on the level immediately below the outer member.

C. Nested members must be members of hierarchies, not of the Measures folder.

D. It is possible to nest members from different dimensions.

To display all individual campaigns in a crosstabreport, a report author could use the expression set([TrailChef Campaign],[EverGlow Campaign],[Course Pro Campaign]). Instead, the report author decides to use the parent member of the campaigns in the set expression "children([All Campaigns])".

Which statement is true about the method that was used?

A. In the future, when a campaign is deleted or new ones are added, the report author must modify the expression.

B. In the future, when a campaign is deleted or new ones are added, the unmodified expression will be valid.

C. The report author should not have used the method chosen, as the first method is best in this situation.

D. To be accurate, the report author should avoid using a set expression.