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?
Open the Relationship Definition dialog, and then edit the join expression as required.
Which of the following is correct regarding the Cognos 10 security environment?
In Framework Manager, object security is implemented by defining access to objects for users, groups and roles defined in the authentication providers.
Which of the following statements is correct regarding the implementation of object security in Framework Manager?
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.
To create a report in Report Studio, a report author accesses which object?
The runtime version of a Framework Manager model.
Although modelers can use model query subjects to create entire business views, it is recommended to use them to do which of the following?
Resolve reporting traps and simplify snowflake tables through consolidation.
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?
An XSUM on SALE_TOTAL.
In Framework Manager, if a modeler changes the business key for a level in a regular dimension, which of the following may change?
Member MUNs
What must a modeler consider when modeling for drill-through between multiple data sources?
Drill-through values must be conformed.
When importing metadata into Framework Manager from a relational database, which of the following can be controlled by the modeler performing the import?
Generating relationships based on existing primary and foreign key relationships in the database.
What is true of a Framework Manager model of an operational database lacking a time dimension?
Time-based rollups for multi-fact queries may be difficult to handle.
In Framework Manager, which of the following will have a negative impact on query performance?
Enable the Allow Enhanced Model Portability governor.
In Framework Manager, role-playing dimension query subjects are used to resolve which reporting trap?
Multiple ambiguous joins between two query subjects.
In Framework Manager, which of the following will have a positive impact on query performance without intervention from an author?
Configure data sources in a project pointing to the same database instance to use the same connection.
Which of the following components does a basic Cognos 10 stitch query consist of?
Coalesce function, full outer join, multiple queries that query some of the same information.
In Framework Manager, which of the following is a correct technique for model segmentation?
Consolidate segmented and linked metadata in a project into a single project by publishing a package to a network location.
Which of the following is true of an OLAP data structure?
Organizes dimension tables into hierarchies and levels.
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?
XSUM(XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) at Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue1
In Framework Manager, which of the following is a correct technique for maintaining packages?
Edit the contents of a package by including or excluding model objects such as namespaces, folders, and query subjects.
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?
All instances of attached cardinality must be either 1..n or 0..n.
Which of the following is true for 0..n cardinality?
The cardinality is optional and an outer join will be performed.
The groups and roles defined in the Cognos namespace can be used to assign access rights to which of the following Framework Manager objects?
Query items.
Which of the following data structures typically contain normalized data?
Operational
In Framework Manager, which of the following statements is correct when working with a multi- lingual project?
A language must be added to the project before it can be published with a package.
In Framework Manager, it is recommended to model operational metadata as a virtual star schema for which one of the following reasons?
Helps to remove ambiguity and provide predictable results.
If authors want to perform OLAP-style queries directly against a relational database, which Framework Manager modeling technique will a modeler use?
Create regular and measure dimensions and set scope.
Which of the following is true when applying object security in Framework Manager?
If beginning to apply security by specifying object security on an object with no children, all other objects will not be accessible to all users.
In Framework Manager, which of the following is true about verifying your model?
It is possible to select to automatically repair certain issues that have been detected.
With respect to Cognos 10 security, which of the following is true of the Cognos namespace?
Can be used to create Cognos 10 specific groups and roles.
A user-defined function imported into Framework Manager can be viewed and used in the following locations?
Viewed in the Explorer and used in the expression editor.
In Framework Manager, what are the minimum requirements to implement a stored procedure that expects arguments and make it available to authors?
Import the stored procedure, provide values that satisfy the procedure's arguments, retrieve a projection list and then publish it as part of a package.
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?
Usage
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?
Create a model query subject with the appropriate relationship to the existing SALES_STAFF data source query subject and make both available 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?
To generate the most efficient SQL at run time and simplify model maintenance.
In Cognos 10, what are the two distinct model types authors can publish from Framework Manager?
Relational and Dimensional
In Framework Manager, when using star schema groupings in the business view, conformed dimensions can be identified by which one of the following?
Using the same name for the dimension in each star schema grouping.
When running an interactive HTML report, which of the following aggregation methods is used by default?
Running
What technique can Framework Manager modelers use to implement a time dimension for models that lack a time dimension?
Identify a time dimension table source, import into the model and create relationships to fact query subjects.
Which of the following are proven practices for organizing the objects in a project?
When importing metadata from more than one data source, create a separate namespace for the imported objects from each data source.
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?
Fact
Which of the following objects in the Framework Manager environment acts as a container and provides a unique name for objects?
namespace
What does a star schema database structure typically consist of?
De-normalized dimension tables and fact tables.
In Cognos 10, which of the following is true of multi-fact result sets?
Both contiguous and correlated lists can have repeating fact values.