BI0-132無料問題集「COGNOS Cognos 8 BI Metadata Model Developer」

質問 1

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.REASON_DESCRIPTION

（B）D3.RETURN_QUANTITY

（C）D2.ORDER_METHOD

（D）D2.DAY_DATE

正解：A 解答を投票する

質問 2

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

（A）Defining multiple connections to the data source.

（B）Generating relationships based on existing primary and foreign key relationships in the database.

（C）Specifying the usage property for generated query items.

（D）Converting inner joins in the database to outer joins in the model.

正解：B 解答を投票する

質問 3

In Framework Manager, when using star schema groupings in the business view, conformed dimensions can be identified by which one of the following?

（A）Viewing the properties of the query subjects in Framework Manager.

（B）Using a different query subject icon for display in the studios.

（C）Using the same name for the dimension in each star schema grouping.

（D）Viewing the properties of the query subjects in Report Studio.

正解：C 解答を投票する

質問 4

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 outer join on RETURN_REASON_KEY.

（D）Left inner join on RETURN_REASON_KEY.

正解：B 解答を投票する

質問 5

Which of the following statements is correct regarding the implementation of object security in Framework Manager?

（A）A user belongs to two groups. One of the groups is denied access to an object. The other group is granted access to the object. The result is that user has access to the object.

（B）Groups and roles can be created in theCognos namespace when specifying access to objects.

（C）Even when object security is applied, if anonymous access is configured, every object in a Framework Manager project is visible to everyone.

（D）Granting access to an object for one user, group or role (except the Everyone and All Authenticated Users groups), implicitly denies access to that object for all other users, groups or roles.

正解：D 解答を投票する

BI0-132 無料問題集「COGNOS Cognos 8 BI Metadata Model Developer」

弊社を連絡する

関連リンク

トップ試験