Online Access Free BI0-132 Exam Questions

What question should a data modeler answer before accepting this proposed operational data structure?

• A.Are Branch and Employee dimension tables or fact tables?
• B.Should the cardinalities between the tables be reversed?
• C.Is there a direct relationship between Branch and Employee?
• D.Should all three tables be consolidated into one?

The generated Cognos SQL below contains which one of the following joins? select
Return_Reason_Dimension.REASON_DESCRIPTION_EN as REASON_DESCRIPTION_EN, Returned_Items_Fact.RETURN_QUANTITY as RETURN_QUANTITY from go_data_warehouse.GOSLDW.dbo.RETURN_REASON_DIMENSION Return_Reason_Dimension join go_data_warehouse.GOSLDW.dbo.RETURNED_ITEMS_FACT Returned_Items_Fact on (Return_Reason_Dimension.RETURN_REASON_KEY = Returned_Items_Fact.RETURN_REASON_KEY)

• A.Outer join on RETURN_REASON_KEY.
• B.Inner join on RETURN_REASON_KEY.
• C.Left inner join on RETURN_REASON_KEY.
• D.Left outer join on RETURN_REASON_KEY.

In Cognos 8, which of the following is true of multi-fact result sets?

• A.Both contiguous and correlated lists cannot have repeating fact values.
• B.Both contiguous and correlated lists can have repeating fact values.
• C.Only contiguous result sets can have repeating fact values.
• D.Only correlated result sets can have repeating fact values.

Which column is most likely a non-conformed or non-shared dimension from the SQL below?
select coalesce(D2.DAY_DATE,D3.DAY_DATE) as DAY_DATE, coalesce(D2.ORDER_METHOD,D3.ORDER_METHOD) as ORDER_METHOD, D3.REASON_DESCRIPTION as REASON_DESCRIPTION, D2.SALE_TOTAL as SALE_TOTAL, D3.RETURN_QUANTITY as RETURN_QUANTITY from

• A.D3.RETURN_QUANTITY
• B.D3.REASON_DESCRIPTION
• C.D2.DAY_DATE
• D.D2.ORDER_METHOD

When importing metadata into Framework Manager from a relational database, which of the following can be controlled by the modeler performing the import?

• A.Generating relationships based on existing primary and foreign key relationships in the database.
• B.Specifying the usage property for generated query items.
• C.Converting inner joins in the database to outer joins in the model.
• D.Defining multiple connections to the data source.