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

Jaksiboy

Community Contributor

Quizzes Created: 832 | Total Attempts: 12,219,230

| Attempts: 408

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Easy First Hard First Sequential

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

1/10 Questions

Which of the following Cognos component is window based?
- Event Studio
- Framework Manager
- Analysis Studio
- Report Studio

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

2.

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