IBM Cognos 10 BI Metadata Model Developer 試験
Question No : 1
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?
Question No : 2
What technique can Framework Manager modelers use to implement a time dimension for models that lack a time dimension?
Question No : 3
If authors want to perform OLAP-style queries directly against a relational database, which Framework Manager modeling technique will a modeler use?
Question No : 4
In Framework Manager, it is recommended to model operational metadata as a virtual star schema for which one of the following reasons?
Question No : 5
In Framework Manager, role-playing dimension query subjects are used to resolve which reporting trap?
Question No : 6
What is true of a Framework Manager model of an operational database lacking a time dimension?
Question No : 7
In Framework Manager, if a modeler changes the business key for a level in a regular dimension, which of the following may change?
Question No : 8
A user-defined function imported into Framework Manager can be viewed and used in the following locations?
Question No : 9
A recursive relationship exists between SALES_STAFF_CODE and MANAGER_CODE in the SALES_STAFF data source query subject. This query subject is provided in a model to report authors. Using this query subject alone, report authors cannot create a report that includes management staff and the sales staff that report to them.
How can the existing recursive relationship in the model be modified to provide this ability to report authors?
Question No : 10
What must a modeler consider when modeling for drill-through between multiple data sources?
Question No : 11
Which of the following statements is correct regarding the implementation of object security in Framework Manager?
Question No : 12
The groups and roles defined in the Cognos namespace can be used to assign access rights to which of the following Framework Manager objects?
Question No : 13
With respect to Cognos 10 security, which of the following is true of the Cognos namespace?
Question No : 14
Which of the following is correct regarding the Cognos 10 security environment.?
Question No : 15
Which of the following is true when applying object security in Framework Manager?