3COM certification 3COM
Adobe certification Adobe
Apple certification Apple
Avaya certification Avaya
BEA certification BEA Systems
Business Objects certification Business Objects
Check Point certification CheckPoint
Cisco certification Cisco
Citrix certification Citrix
CIW certification CIW
COGNOS certification COGNOS
CompTIA certification CompTIA
CWNP certification CWNP
EC-Council certification EC-Council
EMC certification EMC
Exam Express certification Exam Express
Exin certification Exin
F5 Networks certification F5 Networks
H3C certification H3C
HDI certification HDI
HP certification HP
Hitachi certification Hitachi
IBM certification IBM
Isaca certification Isaca
ISC certification ISC
ISEB certification ISEB
Juniper certification Juniper Networks
Lotus certification Lotus
LPI certification LPI
Microsoft certification Microsoft
Mile2 certification Mile2
Network Appliance certification Network Appliance
Nortel certification Nortel
Novell certification Novell
Oracle certification Oracle
PMI certification PMI
RedHat certification RedHat
RSA certification RSA Security
SAIR certification SAIR
SAS certification SAS Institute
SNIA certification SNIA
Sun certification Sun
Sybase certification Sybase
Symantec certification Symantec
Teradata certification Teradata
Tibco certification Tibco
Veritas certification Veritas
VMware certification VMware
All Exams

IBM Cognos COG-132 Exam - CertifySky.com

Free COG-132 Sample Questions:

1. Which of the following data structures typically contain normalized data?
A. Cube
B. Flat file
C. Operational
D. Star schema
Answer: C

2. The database table below would typically be found in what data structure?
(Exhibit Not available in this demo)
A. Union
B. Normalized
C. Operational
D. Star schema
Answer: D

3. What does a star schema database structure typically consist of?
A. De-normalized hierarchy of dimension tables and fact tables.
B. Normalized dimension tables and detailed fact tables.
C. Normalized dimension tables and summarized fact tables.
D. De-normalized dimension tables and fact tables.
Answer: D

4. Which of the following is true of an OLAP data structure?
A. Comprised of normalized dimension and fact tables.
B. Organizes dimension tables into hierarchies and levels.
C. Allows "real time" analysis against disparate data sources.
D. Cardinality between tables is typically configured as inner joins.
Answer: B

5. In a transitive relationship scenario, what problems exist when reporting from the tables below?
(Exhibit Not available in this demo)
A. The Order table must be included in each query.
B. The Order Detail table has conflicting cardinalities.
C. Outer joins are generated when querying from Customer.
D. There is more than one possible path between the tables.
Answer: D

6. The illustration below represents which of the following data traps?
(Exhibit Not available in this demo)
A. Bridge
B. Connection
C. Parallel relationship
D. Many-to-many relationship
Answer: C

7.What question should a data modeler answer before accepting this proposed operational data structure?
(Exhibit Not available in this demo)
A. Should all three tables be consolidated into one?
B. Should the cardinalities between the tables be reversed?
C. Are Branch and Employee dimension tables or fact tables?
D. Is there a direct relationship between Branch and Employee?
Answer: D

8. Which of the following is true regarding the operational data structure illustrated below?
(Exhibit Not available in this demo)
A. It illustrates a parallel relationship.
B. It should be consolidated into one table.
C. It should be examined for a connection trap.
D. The cardinality between the tables should be reversed.
Answer: C

9. In Cognos 8, what are the two distinct model types authors can work with?
A. OLAP and DMR
B. Dimensional and DMR
C. Relational and SAP BW
D. Relational and Dimensional
Answer: D

10.Which of the following objects in the Framework Manager environment acts as a container and provides a unique name for objects?
A. model
B. query item
C. namespace
D. query subject
Answer: C