IBM Cognos Skills Assessment Test

10 Questions | Total Attempts: 133

SettingsSettingsSettings
Please wait...
IBM Cognos Skills Assessment Test

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