Online Access Free BI0-132 Exam Questions

Which of the following are proven practices for organizing the objects in a project?

• A.When importing metadata from more than one data source, do not override the relationships defined between the data sources at the time of import.
• B.When importing metadata from more than one data source, create a separate namespace for the imported objects from each data source.
• C.When importing metadata from more than one data source, include all imported objects in the root namespace.
• D.When importing metadata from more than one data source, create a separate folder for the imported objects from each data source.

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(XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) at Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue1
• C.XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue
• D.XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue2

In Framework Manager, which of the following will have a negative impact on query performance?

• A.Ensure that, where required, queries are executed against materialized views which contain only aggregated data rather than base tables that contain all the data.
• B.Enable the Allow Enhanced Model Portability governor.
• C.Add filters and calculations to model query subjects rather than data source query subjects.
• D.Set the Cross-product joins and Outer Joins governors to Deny.

The groups and roles defined in the Cognos namespace can be used to assign access rights to which of the following Framework Manager objects?

• A.Data sources.
• B.Parameter maps.
• C.Query items.
• D.Relationships.

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

• A.namespace
• B.model
• C.query subject
• D.query item