C2090-645 Online Practice Questions and Answers

Which term below best describes the selected cell in the crosstab?

A. Level

B. member

C. Tuple

D. Revenue

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

Which statement is true about MUNs?

A. They are used to define roll-up properties in a hierarchy.

B. They are used to retrieve members from the data source.

C. They change each time the package is published.

D. They are used to retrieve levels from the data source.

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 report author uses the filter function to focus data in areport, but the results are unexpected. What did the report author overlook when filtering the data?

A. Relational detail

B. Products hierarchy

C. Report context

D. Root levels

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

The report author creates a source report that containsvalues from "Products" on which the report consumer will drill through for details. The report author has created a target report which expects a member from the source.

Is this a supported drill-through combination?

A. Yes, this value-to-member drill-through is a supported combination.

B. No, this value-to-member drill-through is not a supported combination.

C. No, this member-to-value drill-through is not a supported combination.

D. Yes, this member-to-value drill-through is a supported combination.

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.

What does the following expression do:

"generate([Productline],topCount(descendants(currentMember([sales_and_marketing].[Pro ducts].[Products]),[sales_and_marketing].[Products].[Products].[Product]),2,[Revenue]))"?

A. Returns the top two products by revenue for each product line.

B. Finds the top two members by revenue at the product level and returns their respective ancestors at the product line level.

C. Calculates the top two product lines for each product.

D. Goes two levels up from products and returns the top members by revenue at that level.

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.

Based on the diagram,

if the expression firstSibling([2006 Q 1]) is used in the report, what item will be returned?

A. 2005 Q 1

B. 2006 Q 4

C. 2006 Q 1

D. Nothing, because the return value equals the parameter

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.

Which of the following statements is true about a slicer?

A. It keeps the summary column in the report, and removes the detail columns.

B. It affects the values of the cells of the report but not the rows or columns.

C. It determines which set of members are displayed onthe edges of the report.

D. It removes all blank rows in the report to make it more focused.

A report author creates a revenue report from an OLAP data source. On the rows, there are nested levels, each from different dimensions having a large number of members. The report author filters out empty rows using the expression "[Revenue] > 0".

When running this report, there is poor performance. What could cause this?

A. There are too many members or levels nested on the rowedge.

B. Filtering on measure values is incompatible with an OLAP data source.

C. Limiting the crosstab measures with a filter function.

D. A relational filter was applied.