IBM Cognos Skills Assessment Test

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Jaksiboy
J
Jaksiboy
Community Contributor
Quizzes Created: 832 | Total Attempts: 12,225,361
| Attempts: 410
SettingsSettings
Please wait...
  • 1/10 Questions

    Which of the following Cognos component is window based?

    • Event Studio
    • Framework Manager
    • Analysis Studio
    • Report Studio
Please wait...
About This Quiz

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.

IBM Cognos Skills Assessment Test - Quiz

Quiz Preview

  • 2. 
    Which of the following objects in the Framework Manager environment acts as a container and provides a unique name for objects? - ProProfs

    Which of the following objects in the Framework Manager environment acts as a container and provides a unique name for objects?

    • Model

    • Namespace

    • Query subject folder

    • Folder

    Correct Answer
    A. Namespace
    Explanation
    In the Framework Manager environment, a namespace acts as a container that provides a unique name for objects. It helps organize and categorize objects within the environment. By using namespaces, objects can be grouped together based on their functionality or purpose, making it easier to manage and locate them. Namespaces also help prevent naming conflicts between objects with the same name but different purposes. Therefore, the correct answer is "namespace".

    Rate this question:

  • 3. 
    Which statement is true about using burst key to burst reports? - ProProfs

    Which statement is true about using burst key to burst reports?

    • A burst key can be added to a Map

    • A burst key can be added to a chart report.

    • A burst key can be added to a list report.

    • A burst key can be added to a crosstab report.

    Correct Answer
    A. A burst key can be added to a list report.
    Explanation
    A burst key can be added to a list report, allowing the report to be bursted or split into multiple reports based on a specific key value. This enables the distribution of personalized reports to different recipients based on their specific criteria or requirements.

    Rate this question:

  • 4. 
    Which of the following is true of an OLAP data structure? - ProProfs

    Which of the following is true of an OLAP data structure?

    • Allows "real time" analysis against disparate data sources

    • Organizes dimension tables into hierarchies and levels

    • Cardinality must be defined

    • Comprised of normalized dimension and fact structures

    Correct Answer
    A. Organizes dimension tables into hierarchies and levels
    Explanation
    An OLAP data structure organizes dimension tables into hierarchies and levels. This means that the dimension tables are structured in a way that allows for easy analysis and navigation through different levels of data. This hierarchical organization helps in understanding the relationships between different dimensions and enables efficient querying and reporting.

    Rate this question:

  • 5. 
    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.” - ProProfs

    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.”

    • Repeater

    • Crosstab

    • List

    • Singleton

    Correct Answer
    A. Repeater
    Explanation
    The Repeater object will be used to create the mailing labels for all of the company's retailers. The Repeater object allows for repeating sections of a report, which is useful for creating multiple copies of the mailing labels for each retailer.

    Rate this question:

  • 6. 
    In Report Studio, which charts lets the report author plot the third measure? - ProProfs

    In Report Studio, which charts lets the report author plot the third measure?

    • Progressive column

    • Bubble

    • Scatter

    • Area

    Correct Answer
    A. Bubble
    Explanation
    The Bubble chart in Report Studio allows the report author to plot the third measure. This type of chart is useful when comparing three different variables or measures. The size of the bubbles represents the value of the third measure, while the x and y axes represent the other two measures. By using this chart, the report author can effectively visualize and analyze the relationships between three different measures in their report.

    Rate this question:

  • 7. 
    What does a star schema database structure typically consist of? - ProProfs

    What does a star schema database structure typically consist of?

    • De-normalized dimension tables and fact tables

    • De-normalized hierarchy of dimension tables and fact tables.

    • Normalized dimension tables and summarized fact tables.

    • Normalized dimension tables and detailed fact tables.

    Correct Answer
    A. De-normalized dimension tables and fact tables
    Explanation
    A star schema database structure typically consists of de-normalized dimension tables and fact tables. In this structure, the dimension tables contain denormalized hierarchies, meaning that redundant data is present to improve performance and simplify querying. The fact tables contain summarized data at a higher level of granularity. This design allows for efficient and fast querying of data, especially for analytical purposes.

    Rate this question:

  • 8. 
    What are the types of query subjects? - ProProfs

    What are the types of query subjects?

    • Dimensional, function, macros

    • Data source, model, stored procedure

    • Dimensional, model, stored procedure

    • Data source, dimensional, integrated

    Correct Answer
    A. Data source, model, stored procedure
    Explanation
    The types of query subjects are data source, model, and stored procedure. A data source query subject represents a table or view from a database, a model query subject represents a query item or calculation in a model, and a stored procedure query subject represents a stored procedure in a database. These query subjects are used to retrieve data and perform operations in a business intelligence system.

    Rate this question:

  • 9. 
    In Event Studio, which definition best describes the event key? - ProProfs

    In Event Studio, which definition best describes the event key?

    • One or more data items that uniquely define an event instance

    • The set of detected event instances that satisfy the task execution rules

    • Specific occurrence of data items that an agent must detect

    • The object that is created in Event Studio

    Correct Answer
    A. One or more data items that uniquely define an event instance
    Explanation
    The event key in Event Studio refers to one or more data items that uniquely define an event instance. This means that the event key is a set of data items that can be used to identify and distinguish one event instance from another. By using the event key, Event Studio can accurately detect and track specific occurrences of data items that an agent must detect, allowing for efficient and effective event monitoring and analysis.

    Rate this question:

  • 10. 
    In Report Studio, When Creating a list report, What is the difference between creating a section and creating a header? - ProProfs

    In Report Studio, When Creating a list report, What is the difference between creating a section and creating a header?

    • Sections appear once at the top of the list

    • Headers appear once at the top of the list

    • Sections appear outside the list

    • Headers appear outside the list

    Correct Answer
    A. Sections appear outside the list
    Explanation
    When creating a list report in Report Studio, creating a section means that the section will appear outside the list. This means that the section will be displayed before or after the list, providing additional information or context. On the other hand, creating a header means that the header will appear once at the top of the list. The header will be displayed at the beginning of the list, typically containing column names or labels for the data in the list.

    Rate this question:

Quiz Review Timeline (Updated): Mar 22, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Dec 14, 2017
    Quiz Created by
    Jaksiboy
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.