Number of questions: 84
Time allowed in minutes: 90
Required passing score: 78%
IBM Certified Developer – Cognos 10 BI Data Warehouses
IBM Certified Advanced Developer – Risk Information Governance for BI
IBM Certified Solution Expert – Cognos BI
The IBM Cognos 10 BI Data Warehouse Developer exam covers key concepts, technologies, and functionality of the Cognos products. In preparation for an exam, we recommend a combination of training and hands-on experience, and a detailed review of product documentation.
Data Manager and Data Warehousing (4%)
Identify how Data Manager can be used
Distinguish between OLTP systems and data warehouses
Catalogs and Data Source Connections (12%)
Describe the process of creating a catalog
Identify how to use SQLTerm
Describe how to configure text files using SQLTXT Designer
Describe how to package catalog components
Describe how to navigate through catalog components
Describe how to export catalog metadata to Cognos 8
Dimensions and Basic Hierarchies (7%)
Determine appropriate situations for using a hierarchy
Describe the use of the Reference Explorer tool
Describe the use of the Date Hierarchy wizard
Basic Dimension Builds and Fact Builds (12%)
Describe the types of builds
Describe the use of the Dimension Build wizard
Describe the process of creating a fact build
Describe the modification of build settings
Derivations and Derived Dimensions (6%)
Identify the benefits of creating a derivation
Determine the appropriate location to create a derivation
Identify when it would be useful to create a derived dimension
Conformed Dimensions (10%)
Describe the advantages of conformed dimensions
Describe surrogate keys
Describe how to deliver conformed dimensions
Describe how to check data integrity
Hierarchies and Lookups (8%)
Describe ways to modify hierarchies and lookups
Describe how to manipulate data using hierarchies and lookups
Dimensional History and Late Arriving Data (10%)
Describe the use of slowly changing dimensions (SCDs)
Describe the handling of late arriving fact and dimension data
Data Delivery and Data Processing (22%)
Describe delivering fact and dimension data
Describe how to merge and aggregate fact data
Describe how to restrict fact data delivery
Describe how to implement job control
Describe how to pivot fact data
User-Defined Functions (UDFs) and Variables (5%)
Describe how to create UDFs
Describe the use of variables
Troubleshooting and Tuning (4%)
Describe options to address memory and performance issues
Describe how to interpret the log files
Where can a developer define variables in Data Manager?
A. Metadata dimensions
D. Metadata collections
When delivering fact data to a text file, what can be specified?
A. Line and field delimiters
B. Whether the file is in ASCII or EBCDIC format
C. Maximum number of rows to be stored in the file
D. Default text editor to use with the file
What can be done to minimize memory consumption?
A. Disable dimension breaking on the fact build.
B. Disable fact build logging.
C. Enable dimension breaking on the fact build.
D. Enable auditing on the fact build.
Which of the following is true of the Navigator?
A. When searching for components, wildcards are not supported.
B. When a component is selected, dependent components are shown.
C. Library components (such as hierarchies) cannot be navigated.
D. Components from different catalogs can be compared.