COGNOS Cognos 8 BI Metadata Model Developer Sample Questions:
1. In Framework Manager, which of the following is a correct technique for model segmentation?
A) Define the repository type and path to the repository inCognos Connection.
B) Consolidate segmented and linked metadata in a project into a single project by publishing a package to a network location.
C) Copy all segmented model files into one common folder before using Framework Manger's model merge feature.
D) Segment a project at the level of an individual query subject.
2. Which of the following join types does the generated SQL below illustrate? select Manager.Manager as Manager, Product.Product as Product from
datasource_name.database_name.schema.Manager Manager datasource_name.database_name.schema.Product Product
A) Inner join
B) Outer join
C) Cross join
D) Union join
3. 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(Sales_Fact.Revenue for 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
4. Which of the following components does a basic Cognos 8 stitch query consist of?
A) SC() function, full outer join, multiple queries that each query exclusive information.
B) Coalesce function, full outer join, multiple queries that each query exclusive information.
C) SC() function, full outer join, multiple queries that query some of the same information.
D) Coalesce function, full outer join, multiple queries that query some of the same information.
5. In Cognos 8, what are the two distinct model types authors can work with?
A) Relational and SAP BW
B) Dimensional and DMR
C) OLAP and DMR
D) Relational and Dimensional
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: C | Question # 3 Answer: D | Question # 4 Answer: D | Question # 5 Answer: D |
We're so confident of our products that we provide no hassle product exchange.


By Cedric

