IBM Cognos 10 BI Multidimensional Author (C2090-645) Free Practice Test

Question 1

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. The mapped string values will not pass through to the target report.

C. Using these dimensional methods will not work with an OLAP data source.

D. There is nothing wrong with this approach.

Correct Answer: A

Question 2

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

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

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

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

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

Correct Answer: C

Question 3

The author has created a complex expression called "Sorted Products" on the row edge, which sorts product line by Revenue for 2006.

What must the report author do to sort the members when drilling down?

A. Nothing, as the default drill behavior is sufficient in this case, to maintain sorting of the children.

B. Set the behavior to Depth Based Expression, to maintain sorting at a lower level in the data source.

C. Preserve the Sorted Products expression, but replace the underlying Product Set expression.

D. Configure the Ancestor drill behavior on the Sorted Products expression.

Correct Answer: C

Question 4

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

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

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

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.

Correct Answer: D

Question 5

What kind of authoring style uses the filter function?

A. Relational

B. DMR

C. Dimensional

D. Conformed

Correct Answer: C

Question 6

The following expression is used in a crosstab report: filter([sales_and_marketing]. [Product brand].[Product brand].[Product brand type],[Revenue]<100000000). There are 26 product brand types in the OLAP data source.

Why does the report only return 11 product brand type rows?

A. A relational function was used to filter on the members, not the measure values.

B. A relational function was used to filter on the measure values, not the members.

C. A dimensional function was used to filter on each column.

D. A dimensional function was used to filter on the total of the opposite edge.

Correct Answer: D

Welcome to TestSimulate

IBM Cognos 10 BI Multidimensional Author (C2090-645) Free Practice Test