IBM Cognos 10 BI Metadata Model Developer - C2020-632 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

An author creates a Report Studio report that contains Month, Product Line and Revenue. Revenue has a footer to show the overall total. What will the author see in the generated Cognos SQL for the Revenue footer column?

A. XSUM(XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) in Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue B. XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue2 C. XSUM(XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) at Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue1 D. XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue

Discussion 0

Correct Answer: C Vote an answer

Question 2

When running an interactive HTML report, which of the following aggregation methods is used by default?

A. Running B. Unspecified C. Unknown D. Extended

Discussion 0

Correct Answer: A Vote an answer

Question 3

When a modeler imports metadata into Framework Manager, the Usage property for a non-indexed, numeric query item is set to which of the following?

A. Fact B. Measure Dimension C. Attribute D. Identifier

Discussion 0

Correct Answer: A Vote an answer

Question 4

To create a report in Report Studio, a report author accesses which object?

A. A file that contains query subjects externalized from Framework Manager. B. The runtime version of a Framework Manager model. C. A report specification. D. A development model from Framework Manager.

Discussion 0

Correct Answer: B Vote an answer

Question 5

Which of the following objects in the Framework Manager environment acts as a container and provides a unique name for objects?

A. query subject folder B. namespace C. folder D. model

Discussion 0

Correct Answer: B Vote an answer

Question 6

If authors want to perform OLAP-style queries directly against a relational database, which Framework Manager modeling technique will a modeler use?

A. Create regular and measure dimensions and set scope. B. Create relationships between regular dimensions and measure dimensions. C. Create shortcuts to regular dimensions and fact query subjects. D. Create star schema groupings for dimension and fact query subjects.

Discussion 0

Correct Answer: A Vote an answer