IBM Cognos Skills Assessment Test

10 Questions | By Jaksiboy | Last updated: Jan 25, 2021 | Total Attempts: 195

Questions

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.

Questions and Answers

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