Test information:
Number of questions: 65
Time allowed in minutes: 90
Required passing score: 76%
Languages: English, Japanese

Related certifications:
IBM Certified Advanced Developer – Risk Information Governance for BI
IBM Certified Solution Expert – Cognos BI
IBM Certified Developer – Cognos 10 BI OLAP Models

The Cognos 10 BI OLAP 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.

Transformer Basics (5%)
Describe the Transformer development process

Data Sources (12%)
Identify data sources for use in Transformer
Describe the use of multiple data sources
Describe uniqueness

Model Creation (17%)
Describe the process to build a basic Transformer model
Describe the implementation of a time dimension
Describe how to make data available in the Cognos 10 studios

Model Key Performance Measures (12%)
Differentiate between measures
Describe the use of measures

Security (12%)
Describe the IBM Cognos 10 security environment
Describe how to secure a PowerCube

PowerCube Content Customization (20%)
Define techniques to customize dimensions
Describe the process to customize PowerCube content

Maintenance and Advanced Techniques (22%)
Describe techniques for model maintenance
Describe how to update published PowerCubes and PowerCube connections
Identify ways to trouble shoot issues
Identify considerations for optimization
Describe changes that impact MUNs

---

QUESTION 1
What should a developer do if some levels appear red after validating the model using Show Scope?

A. Ensure the level exists in the data source.
B. Specify a valid relationship between the level and the data source.
C. Re-attach the categories in the Dimension Diagram.
D. Apply unique move to the level and regenerate the categories.

Answer: B

---

QUESTION 2
When measures are calculated after rollup, when are the calculations performed?

A. Before time state rollup takes place.
B. After allocated measures are calculated.
C. Before regular rollup takes place on all measures.
D. After relative time calculations.

Answer: B

---

QUESTION 3
What objects can be created within the Cognos Namespace?

A. Roles and users
B. Groups and roles
C. Groups and users
D. Members

Answer: B

---

QUESTION 4
Transformer is unable to locate one of the source files for a data source in the model, and
the model update fails. Which type of files can be used to restart the processing at the point of failure?

A. .py?
B. .qy?
C. .mdl
D. .mdx

Answer: B

Click here to view complete Q&A of C2090-635 exam
Certkingdom Review, Certkingdom C2090-635 PDF

Best IBM C2090-635 Certification, IBM C2090-635 Training at certkingdom.com