IBM C2020-632 問題集

質問 1：
Which of the following is true for 0..n cardinality?
A. The cardinality is optional and a union will be performed.
B. The cardinality is optional and an inner join will be performed.
C. The cardinality is required and an outer join will be performed.
D. The cardinality is optional and an outer join will be performed.
正解：D

質問 2：
Which of the following statements is correct regarding the implementation of object security in Framework Manager?
A. Groups and roles can be created in the Cognos namespace when specifying access to objects.
B. 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.
C. 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.
D. Even when object security is applied, if anonymous access is configured, every object in a Framework Manager project is visible to everyone.
正解：B

質問 3：
When running an interactive HTML report, which of the following aggregation methods is used by default?
A. Extended
B. Unspecified
C. Unknown
D. Running
正解：D

質問 4：
Users want to compare Actual Revenue and Sales Target values by Month. Actual Revenue values are stored at the day grain in the Orders Fact table. Sales Target values are stored at the month grain in the Sales Target Fact table.

In Framework Manager, which technique will best prevent Sales Target values from being double-counted in Query Studio reports?
A. Set scope for Actual Revenue at the Day level and Sales Target at the Month level in the Dimension Map.
B. Define both Month and Day determinant levels in the Time Dimension and Group By Day.
C. Define both Month and Day determinant levels in the Time Dimension and Group By Month.
D. Create separate star schema groupings for Orders Fact and Sales Target Fact, both at the month grain.
正解：C

質問 5：
When importing metadata into Framework Manager from a relational database, which of the following can be controlled by the modeler performing the import?
A. Converting inner joins in the database to outer joins in the model.
B. Specifying the usage property for generated query items.
C. Generating relationships based on existing primary and foreign key relationships in the database.
D. Specifying the item names in various languages.
正解：C