Online Access Free C2090-645 Practice Test

A report author is working with an OLAP data source. The report author creates a query that uses a caption function on a member and applies a string function. What is a possible consequence of this action?

• A.Mixing dimensional styles and relational styles in a single query can create unexpected results.
• B.There is nothing wrong with this approach.
• C.Using these dimensional methods will not work with an OLAP data source.
• D.The mapped string values will not pass through to the target report.

What is the default behavior when drilling down on an edge in a crosstab report?

• A.The edge expression is changed to another item in the query.
• B.All edge expressions of the crosstab are replaced with their children.
• C.The level drilled on is replaced with the entire level below it.
• D.The edge expression is replaced with the children of the item drilled on.

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 than 150000000 for any year.
• B.To filter the cell values by subtracting 150000000 from the revenue for each year and order method type.
• C.To filter the years to show those having revenues greater than 150000000 by order method type.
• D.To return the set of members whose revenue is greater than 150000000 for the sum of the opposite edge.

Which of the following are dimensional objects?

• A.Slicer and string function
• B.Sets and query calculation
• C.Level and member
• D.Query subject and relationship cardinality

Consumers want a report to compare the revenue and quantity sold for all product lines in a selected quarter, to the same quarter for the previous year. They also want to see the total for periods, up to and including the quarter selected.

Which of the following dimensional functions could the report author use to create this report?

• A.ParallelPeriod, tuple, periodsToDate, aggregate
• B.Ancestor, currentMember, lead, total
• C.Cousin, tuple, closingPeriod, aggregate
• D.OpeningPeriod, order, quarter, Firstsibling