Examsoon offers COG-125 exam demo
COG-125 Exam
IBM Cognos 8 BI Data Warehouse Developer
Former exam code was BI0-125.
BI0-125 Test information:
BI0-125 exam Number of questions: 84
BI0-125 exam Time allowed in minutes: 90
BI0-125 exam Required passing score: 78%
The Cognos 8 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
Examsoon offers free demo for Cognos 8 BI COG-125 exam (IBM Cognos 8 BI Data Warehouse Developer). You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products.
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.
