C2090-645 Online Practice Questions and Answers
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.
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.
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 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
The following expression is used to focus OLAP data in the rows of a report: filter([sales_and_marketing].[Order method].[Order method].[Order method type], [Revenue]>150000000).
Which of the following statements describes the purpose of the expression?
A. To return the set of members whose revenue is less than150000000 for any year.
B. To return the set of members whose revenue is greater than 150000000 for the sum of the opposite edge.
C. To filter the cell values by subtracting 150000000 from the revenue for each year and order method type.
D. To filter the years to show those having revenues greater than 150000000 by order method type.
Which of the following family functions is most similar to the relativetime function parallelPeriod?
A. Cousin
B. PrevMember
C. Siblings
D. OpeningPeriod
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.
Which of the following statements is correct about the order function?
A. The currentMeasure function must be used with the orderfunction as the sort by criterion.
B. It arranges members of all sets in the report by ascending or descending values.
C. Optional parameters allow the author to order the members of a hierarchy without regard of their level.
D. It arranges members of a set alphabetically by ascending or descending captions.
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.
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.