We're so confident of our products that we provide no hassle product exchange.
COGNOS BI0-132 Exam Overview:
| Certification Vendor: | IBM |
| Exam Name: | IBM Cognos 8 BI Metadata Model Developer |
| Exam Number: | BI0-132 |
| Certificate Validity Period: | Retired (no longer actively offered) |
| Exam Format: | Multiple choice, Scenario-based questions |
| Related Certifications: | IBM Cognos BI Administration IBM Cognos BI Report Developer |
| Available Languages: | English |
| Sample Questions: | COGNOS BI0-132 Sample Questions |
| Exam Way: | Computer-based exam (historically delivered through IBM authorized testing centers or online proctored systems depending on region) |
| Pre Condition: | Basic knowledge of relational databases and data warehousing concepts is recommended. |
COGNOS BI0-132 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Business Rules and Calculations | - Expression building
|
| Troubleshooting and Performance | - Model optimization
|
| Security and Deployment | - Security implementation
|
| Cognos Architecture and Components | - IBM Cognos 8 BI architecture overview
|
| Relational and Dimensional Modeling | - Query subjects and relationships
|
| Framework Manager Modeling | - Model design techniques
|
COGNOS Cognos 8 BI Metadata Model Developer Sample Questions:
1. Which of the following components does a basic Cognos 8 stitch query consist of?
A) SC() function, full outer join, multiple queries that each query exclusive information.
B) Coalesce function, full outer join, multiple queries that each query exclusive information.
C) SC() function, full outer join, multiple queries that query some of the same information.
D) Coalesce function, full outer join, multiple queries that query some of the same information.
2. 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?
A) Usage
B) Data Type
C) Format
D) Semi-Aggregate
3. To ensure a query subject is recognized as a fact by the Cognos 8 query engine in all query scenarios, the query subject requires which cardinality rule?
A) All instances of attached cardinality must be either 1..1 or 0..n.
B) All instances of attached cardinality must be either 1..n or 0..n.
C) One instance of attached cardinality must be 0..1.
D) One instance of attached cardinality must be 1..1.
4. Which of the following is true of an OLAP data structure?
A) Organizes dimension tables into hierarchies and levels.
B) Comprised of normalized dimension and fact tables.
C) Cardinality between tables is typically configured as inner joins.
D) Allows "real time" analysis against disparate data sources.
5. Which of the following are proven practices for organizing the objects in a project?
A) When importing metadata from more than one data source, create a separate folder for the imported objects from each data source.
B) When importing metadata from more than one data source, create a separate namespace for the imported objects from each data source.
C) When importing metadata from more than one data source, include all imported objects in the root namespace.
D) When importing metadata from more than one data source, do not override the relationships defined between the data sources at the time of import.
Solutions:
| Question # 1 Answer: D | Question # 2 Answer: A | Question # 3 Answer: B | Question # 4 Answer: A | Question # 5 Answer: B |
By Felix
