C2090-645 Online Practice Questions and Answers

What kind of authoring style uses the filter function?

A. Relational

B. Conformed

C. Dimensional

D. DMR

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

A reportauthor creates a crosstab as shown.

What is the default measure of the report?

A. Mountaineering Equipment

B. Camping Equipment

C. Gross profit

D. Revenue

The "Sales" and "Inventory" data stores each have "Products" and "Time"dimensions. For drill-through between the data stores on the "Products" and "Time" dimensions to work, which items in the structures must be identical in the data stores?

A. Hierarchy names, member values

B. Level order, level names

C. Hierarchy names, snowflake schema

D. Role value, internal keys

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

What type of prompt would a report author use to return a set of members from a hierarchy?

A. Select and Search Prompt

B. Value prompt

C. Tree prompt

D. Prompt Page

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.

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. This is not possible because a prompt must always be populated with all members of a level.

B. Create a multi-select value prompt. Populate it using an expression on the [Northern Europe] member to retrieve its children on the country level.

C. Generate a prompt by creating an expression with a parameter on the crosstab edge: children([Northern Europe]->?Country?

D. Create a tree prompt, and populate it using an expression on the[Northern Europe] member to retrieve its children at the country level.

A report authorhas created a crosstab report from the data source shown. The Retailer name level has been dragged to the rows and default drilling up and down has been activated.

What will be displayed in the report if the consumer drills up on one of the members of Retailer name?

A. The parent member of the member drilled on.

B. The ancestors of the member drilled on from the whole Retailers hierarchy.

C. The members from the Region level.

D. The members from the Retailer country level.

Why would a report author consider overriding the default drill behavior?

A. To maintain the behavior of a complex edge expression after drilling, such as one which returns the top 5 members of a set.

B. To replace all members within a hierarchy when drilling through to a report with more detail.

C. To drill down to the lowest level of the hierarchy and then drill down again to display only one member.

D. To drill down on a member and have its children display as details and have the member drilled on display as summary.