Test4actual certification

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.
Test4actual 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.

Catalogs and Data Source Connections (12%)
a.Describe the process of creating a catalog
b.Identify how to use SQLTerm
c.Describe how to configure text files using SQLTXT Designer
d.Describe how to package catalog components
e.Describe how to navigate through catalog components
f.Describe how to export catalog metadata to Cognos 8

Dimensions and Basic Hierarchies (7%)
a.Determine appropriate situations for using a hierarchy
b.Describe the use of the Reference Explorer tool
c.Describe the use of the Date Hierarchy wizard

Basic Dimension Builds and Fact Builds (12%)
a.Describe the types of builds
b.Describe the use of the Dimension Build wizard
c.Describe the process of creating a fact build
d.Describe the modification of build settings

Conformed Dimensions (10%)
a.Describe the advantages of conformed dimensions
b.Describe surrogate keys
c.Describe how to deliver conformed dimensions
d.Describe how to check data integrity

Hierarchies and Lookups (8%)
a.Describe ways to modify hierarchies and lookups
b.Describe how to manipulate data using hierarchies and lookups

Dimensional History and Late Arriving Data (10%)
a.Describe the use of slowly changing dimensions (SCDs)
b.Describe the handling of late arriving fact and dimension data

Data Delivery and Data Processing (22%)
a.Describe delivering fact and dimension data
b.Describe how to merge and aggregate fact data
c.Describe how to restrict fact data delivery
d.Describe how to implement job control
e.Describe how to pivot fact data

User-Defined Functions (UDFs) and Variables (5%)
a.Describe how to create UDFs
b.Describe the use of variables

Sample test:
The sample test is designed to give the candidate an idea of the content and format of the questions that will be on the certification exam. Performance on the sample test is NOT an indicator of performance on the certification exam. This should not be considered an assessment tool.
With the complete collection of questions and answers, Test4actual has assembled to take you through 90 Q&A to your COG-125 exam preparation. In the COG-125 exam resources, you will cover every field and category in Cognos 8 BI helping to ready you for your successful IBM Certification.

1. Which of the following is contained in a Data Manager catalog?
A. Cognos 8 packages
B. Flat files
C. Fact tables
D. User-defined functions
2. Where can an administrator create a derivation?
A. DataStream
B. Fact Delivery module
C. Reference dimension
D. User-defined function
3. When pivoting data in Data Manager, where must the pivot values be declared?
A. In the data source
B. In the DataStream
C. In the relational table delivery
D. In the data source connection
4. Where can a user-defined function be utilized in the transformation model?
A. In a dimension element
B. In an attribute element
C. In a derivation element
D. In a measure element
5. What can be done to reduce the amount of memory that is used by a dimension build when it is executed?
A. Disable file caching on the underlying hierarchy levels.
B. Enable auditing on the dimension build.
C. Enable file caching on the underlying hierarchy levels.
D. Disable logging on the dimension build.
ANSWERS: 1-D; 2-A; 3-B; 4-C; 5-C