C2020-632.pdf - IBM C2020-632 IBM Cognos 10 BI Metadata Model Developer http\/killexams.com\/exam-detail\/C2020-632 B XSUM(Sales_Fact.Revenue for

C2020-632.pdf - IBM C2020-632 IBM Cognos 10 BI Metadata...

This preview shows page 1 - 3 out of 5 pages.

C2020-632 IBM IBM Cognos 10 BI Metadata Model Developer
Image of page 1
B. XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue2 C. XSUM(XSUM(Sales_Fact.Revenue forTime_Dimension.Month1,Product_Dimension.Product_Line) in Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue D. XSUM(XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) at Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue1 Answer: D QUESTION: 50 Which of the following join types does the generated SQL below illustrate? A. Inner join B. Disjointed join C. Outer join D. Cross join Answer: D QUESTION: 51 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 shortcuts to regular dimensions and fact query subjects.
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 5 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture