IBM COG-632 問題集

質問 1：
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 Report Studio.
B. Using a different query subject icon for display in the studios.
C. Viewing the properties of the query subjects in Framework Manager.
D. Using the same name for the dimension in each star schema grouping.
正解：D

質問 2：
When a modeler imports metadata into Framework Manager, the Usage property for a non-indexed, numeric query item is set to which of the following?
A. Fact
B. Attribute
C. Identifier
D. Measure Dimension
正解：A

質問 3：
The generated Cognos SQL below contains which one of the following joins?

A. Outer join on RETURN_REASON_KEY.
B. Left outer join on RETURN_REASON_KEY.
C. Left inner join on RETURN_REASON_KEY.
D. Inner join on RETURN_REASON_KEY.
正解：D

質問 4：
Which of the following is correct regarding the Cognos 10 security environment?
A. To perform authentication of users, a connection to the Cognos namespace must be defined.
B. In Framework Manager, object security is implemented by defining access to objects for groups and roles (of which users are members), not individual users.
C. In Framework Manager, object security is implemented by defining access to objects for users, groups and roles defined in the authentication providers.
D. Cognos 10 must be configured to use only one authentication provider at a time.
正解：C

質問 5：
In Framework Manager, which of the following is a correct technique for model segmentation?
A. Copy all segmented model files into one common folder before using Framework Manger's model merge feature.
B. Segment a project at the level of an individual query subject.
C. Consolidate segmented and linked metadata in a project into a single project by publishing a package to a network location.
D. Define the repository type and path to the repository in Cognos Connection.
正解：C

質問 6：
Which of the following is true of the generated native SQL below?

A. The parent select statement uses an inner join to directly match columns from physical tables in the database.
B. The outer projection list will return more columns than listed, due to extra columns retrieved in the derived table.
C. The derived table is executed independently, using Pass-Through SQL, and then processed locally.
D. The derived table is used to retrieve one data set, in order to fulfill the join condition of another data set.
正解：D