최신COGNOS Cognos 8 BI Metadata Model Developer - BI0-132무료샘플문제
문제1
Although modelers can use model query subjects to create entire business views, it is recommended to use them to do which of the following?
Although modelers can use model query subjects to create entire business views, it is recommended to use them to do which of the following?
정답: A
문제2
If authors want to perform OLAP-style queries directly against a relational database, which Framework Manager modeling technique will a modeler use?
If authors want to perform OLAP-style queries directly against a relational database, which Framework Manager modeling technique will a modeler use?
정답: A
문제3
In Framework Manager, role-playing dimension query subjects are used to resolve which reporting trap?
In Framework Manager, role-playing dimension query subjects are used to resolve which reporting trap?
정답: D
문제4
When a modeler imports metadata into Framework Manager, the Usage property for a nonindexed, numeric query item is set to which of the following?
When a modeler imports metadata into Framework Manager, the Usage property for a nonindexed, numeric query item is set to which of the following?
정답: B
문제5
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)
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)
정답: B
문제6
Which of the following objects in the Framework Manager environment acts as a container and provides a unique name for objects?
Which of the following objects in the Framework Manager environment acts as a container and provides a unique name for objects?
정답: D