IBM Cognos Skills Assessment Test
(195).jpg "IBM Cognos Skills Assessment Test - 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.
- 1.
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
Correct Answer
B. Organizes dimension tables into hierarchies and levelsExplanation
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:
-
- 2.
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.
Correct Answer
A. De-normalized dimension tables and fact tablesExplanation
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:
-
- 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
Correct Answer
B. NamespaceExplanation
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:
-
- 4.
Which of the following Cognos component is window based?
- A.
Event Studio
- B.
Framework Manager
- C.
Analysis Studio
- D.
Report Studio
Correct Answer
B. Framework ManagerExplanation
Framework Manager is a window-based component in Cognos. It is used for creating and managing metadata models, which provide a semantic layer for reporting and analysis. With Framework Manager, users can define data sources, create business views, and establish relationships between data items. This component allows for the creation of reusable and consistent data models, making it easier for users to access and analyze data in Cognos.Rate this question:
-
- 5.
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.
Correct Answer
C. 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:
-
- 6.
In Report Studio, which charts lets the report author plot the third measure?
- A.
Progressive column
- B.
Bubble
- C.
Scatter
- D.
Area
Correct Answer
B. BubbleExplanation
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.
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
Correct Answer
A. RepeaterExplanation
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:
-
- 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
Correct Answer
B. Data source, model, stored procedureExplanation
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 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
Correct Answer
C. Sections appear outside the listExplanation
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:
-
- 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
Correct Answer
A. One or more data items that uniquely define an event instanceExplanation
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:
-
Back to top