We're so confident of our products that we provide no hassle product exchange.
COGNOS Cognos 8 BI Metadata Model Developer Sample Questions:
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(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
2. What is true of a Framework Manager model of an operational database lacking a time dimension?
A) Report authors cannot create multi-fact, time-based queries unless using a union.
B) Report authors cannot create multi-fact, time-based queries.
C) Virtual star schema models require a time dimension for multi-fact queries.
D) Time-based rollups for multi-fact queries may be difficult to handle.
3. In Framework Manager, if a modeler changes the business key for a level in a regular dimension, which of the following may change?
A) Level identifier
B) Level MUN
C) Member MUNs
D) Member aliases
4. A recursive relationship exists between SALES_STAFF_CODE and MANAGER_CODE in the SALES_STAFF data source query subject. This query subject is provided in a model to report authors. Using this query subject alone, report authors cannot create a report that includes management staff and the sales staff that report to them. How can the existing recursive relationship in the model be modified to provide this ability to report authors?
A) Import a query subject that does not contain a recursive relationship.
B) Create a shortcut to the SALES_STAFF data source query subject, and report authors will use it instead of the underlying query subject to create the required report.
C) Create a star schema grouping that contains the SALES_STAFF data source query subject and a shortcut to the SALES_STAFF data source query subject.
D) Create a model query subject with the appropriate relationship to the existing SALES_STAFF data source query subject and make both available to report authors.
5. Which of the following is true of an OLAP data structure?
A) Organizes dimension tables into hierarchies and levels.
B) Comprised of normalized dimension and fact tables.
C) Cardinality between tables is typically configured as inner joins.
D) Allows "real time" analysis against disparate data sources.
Solutions:
| Question # 1 Answer: D | Question # 2 Answer: D | Question # 3 Answer: C | Question # 4 Answer: D | Question # 5 Answer: A |
By Byron
