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

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.

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 is working with an OLAP data source. The reportauthor 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. Using these dimensional methods will not work with an OLAP data source.

B. The mapped string values willnot pass through to the target report.

C. There is nothing wrong with this approach.

D. Mixing dimensional styles and relational styles in a single query can create unexpected results.

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 previousyear. 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. Ancestor, currentMember, lead, total

B. OpeningPeriod, order, quarter, Firstsibling

C. Cousin, tuple, closingPeriod, aggregate

D. ParallelPeriod, tuple, periodsToDate, aggregate

A report author uses an OLAP cube to create a crosstab with Revenue as a measure, the Product linelevel in the rows, and the year members (2004-2007) in the columns.

How can the report author efficiently determine the difference in revenue between the years 2005 and 2006?

A. Determine MUNs for the years 2005 and 2006, and then create an expressionusing the MUNs.

B. Create a new column as a query calculation, and create the expression [2006]-[2005].

C. Create a set of the 2005 and 2006 members and aggregate it.

D. Ask the modeler to create a calculated category in Transformer and then use it directly.

If the syntax for thehead function is head(set_exp[,index_exp]),then which of the following expressions is correct?

A. head(members([sales_and_marketing].[Products].[Products].[Product line]),2)

B. head(([sales_and_marketing].[Products].[Products].[Product line])[,2])

C. head(order([sales_and_marketing].[Products].[Products].[Product line])2)

D. head(members([sales_and_marketing].[Products].[Products].[Product line],2))

The dialog box shown appears when a report is run.

What should the report author do to correct the situation?

A. Ask the modeler to rename the hierarchy to '[sales_and_marketing].[Products].[Products].[Products]', and to republish the package.

B. Modify the expression to change the 'currentMember' function to 'currentLevel'.

C. Modify the expression to change the 'currentMember' function to 'currentHierarchy'.

D. Modify the expression to 'currentMember([sales_and_marketing].[Products].[Products])'.

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

A. The level drilled on is replaced with the entire level below it.

B. The edge expression is replaced with the children of the item drilled on.

C. All edge expressions of the crosstab are replaced with their children.

D. The edge expression is changed to another item in the query.

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.