IBM Cognos Skills Assessment Test
Settings
The IBM Cognos software which can also be recognized as Cognos BI(Business Intelligence), is a web-based, integrated BI suite by IBM. It provides a toolset for monitoring of events, reporting and other functions. Do you think you have the skills to use this software? Find out by taking this quiz.
- 1.Which of the following Cognos component is window based?
- A.
Event Studio
- B.
Framework Manager
- C.
Analysis Studio
- D.
Report Studio
- 2.Which of the following is true of an OLAP data structure?
- A.
Allows "real time" analysis against disparate data sources
- B.
Organizes dimension tables into hierarchies and levels
- C.
Cardinality must be defined
- D.
Comprised of normalized dimension and fact structures
- 3.Which of the following objects in the Framework Manager environment acts as a container and provides a unique name for objects?
- A.
Model
- B.
Namespace
- C.
Query subject folder
- D.
Folder
- 4.What does a star schema database structure typically consist of?
- A.
De-normalized dimension tables and fact tables
- B.
De-normalized hierarchy of dimension tables and fact tables.
- C.
Normalized dimension tables and summarized fact tables.
- D.
Normalized dimension tables and detailed fact tables.
- 5.In Report Studio, which charts lets the report author plot the third measure?
- A.
Progressive column
- B.
Bubble
- C.
Scatter
- D.
Area
- 6.Which statement is true about using burst key to burst reports?
- A.
A burst key can be added to a Map
- B.
A burst key can be added to a chart report.
- C.
A burst key can be added to a list report.
- D.
A burst key can be added to a crosstab report.
- 7.Which object will be used to create the following report? “You are a report author at The Great Outdoors Company, which sells sporting equipment. You are requested to create mailing labels for all of the company's retailers.”
- A.
Repeater
- B.
Crosstab
- C.
List
- D.
Singleton
- 8.What are the types of query subjects?
- A.
Dimensional, function, macros
- B.
Data source, model, stored procedure
- C.
Dimensional, model, stored procedure
- D.
Data source, dimensional, integrated
- 9.In Report Studio, When Creating a list report, What is the difference between creating a section and creating a header?
- A.
Sections appear once at the top of the list
- B.
Headers appear once at the top of the list
- C.
Sections appear outside the list
- D.
Headers appear outside the list
- 10.In Event Studio, which definition best describes the event key?
- A.
One or more data items that uniquely define an event instance
- B.
The set of detected event instances that satisfy the task execution rules
- C.
Specific occurrence of data items that an agent must detect
- D.
The object that is created in Event Studio
Back to top