C2020-632 - IBM Cognos 10 BI Metadata Model Developer Exam

Go back to IBM

Example Questions

In order to create complex joins in Framework Manager, a modeler can use which of the following techniques? Which of the following is correct regarding the Cognos 10 security environment? Which of the following statements is correct regarding the implementation of object security in Framework Manager? To create a report in Report Studio, a report author accesses which object? Although modelers can use model query subjects to create entire business views, it is recommended to use them to do which of the following? In Framework Manager, if a modeler tests the Month from Time Dimension and SALE_TOTAL from Sales Fact and applies Auto Sum, which of the following is a modeler most likely to see? In Framework Manager, if a modeler changes the business key for a level in a regular dimension, which of the following may change? What must a modeler consider when modeling for drill-through between multiple data sources? When importing metadata into Framework Manager from a relational database, which of the following can be controlled by the modeler performing the import? What is true of a Framework Manager model of an operational database lacking a time dimension? In Framework Manager, which of the following will have a negative impact on query performance? In Framework Manager, role-playing dimension query subjects are used to resolve which reporting trap? In Framework Manager, which of the following will have a positive impact on query performance without intervention from an author? Which of the following components does a basic Cognos 10 stitch query consist of? In Framework Manager, which of the following is a correct technique for model segmentation? Which of the following is true of an OLAP data structure? An author creates a Report Studio report that contains Month, Product Line and Revenue. Revenue has a footer to show the overall total. What will the author see in the generated Cognos SQL for the Revenue footer column? In Framework Manager, which of the following is a correct technique for maintaining packages? To ensure a query subject is recognized as a fact by the Cognos 10 query engine in all query scenarios, the query subject requires which cardinality rule? Which of the following is true for 0..n cardinality? The groups and roles defined in the Cognos namespace can be used to assign access rights to which of the following Framework Manager objects? Which of the following data structures typically contain normalized data? In Framework Manager, which of the following statements is correct when working with a multi- lingual project? In Framework Manager, it is recommended to model operational metadata as a virtual star schema for which one of the following reasons? If authors want to perform OLAP-style queries directly against a relational database, which Framework Manager modeling technique will a modeler use? Which of the following is true when applying object security in Framework Manager? In Framework Manager, which of the following is true about verifying your model? With respect to Cognos 10 security, which of the following is true of the Cognos namespace? A user-defined function imported into Framework Manager can be viewed and used in the following locations? In Framework Manager, what are the minimum requirements to implement a stored procedure that expects arguments and make it available to authors? After metadata is imported into Framework Manager or a new query subject is created, it is recommended to first verify which one of the following property settings? 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? In Framework Manager, why is it recommended that modelers alter the default all-inclusive select statements of data source query subjects as little as possible? In Cognos 10, what are the two distinct model types authors can publish from Framework Manager? In Framework Manager, when using star schema groupings in the business view, conformed dimensions can be identified by which one of the following? When running an interactive HTML report, which of the following aggregation methods is used by default? What technique can Framework Manager modelers use to implement a time dimension for models that lack a time dimension? Which of the following are proven practices for organizing the objects in a project? 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? Which of the following objects in the Framework Manager environment acts as a container and provides a unique name for objects? What does a star schema database structure typically consist of? In Cognos 10, which of the following is true of multi-fact result sets?