Cognos Online Test! Trivia Quiz
Total 25 Questions, each one carry 1 mark and duration is 30 min.
- 1.
The sales department require a report that numerically compares the gross profit genereated for all products lines in each territory.In Report Studio,which is the most appropriate report type?
- A.
List
- B.
Chart
- C.
Crosstab
- D.
Repeater
Correct Answer
C. CrosstabExplanation
A crosstab report is the most appropriate report type for comparing the gross profit generated for all product lines in each territory. A crosstab report allows for the comparison of data across different dimensions, such as product lines and territories, by displaying them in a grid format. This will enable the sales department to easily analyze and compare the gross profit for each product line in each territory numerically.Rate this question:
-
- 2.
In Report Studio, which chart lets the report author plot a third measure?
- A.
Area
- B.
Bubble
- C.
Scatter
- D.
Progressive column
Correct Answer
B. BubbleExplanation
The Bubble chart in Report Studio allows the report author to plot a third measure. This type of chart is useful when visualizing three different variables simultaneously. The size of the bubbles represents the value of the third measure, while the x and y axes represent the other two measures. This chart is effective in showing patterns and relationships between the variables in a visually appealing way.Rate this question:
-
- 3.
In Report Studio, When Creating a list report, What is the differnce between creating a section and creating a header?
- A.
Headers appear outside the list
- B.
Sections appear outside the list
- C.
Headers appear once at the top of the list
- D.
Sections appear once at the top of the list
Correct Answer
B. 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 implies that the section will be displayed separately from the list, possibly before or after it. On the other hand, creating a header means that the header will appear once at the top of the list. This suggests that the header will be displayed only once, at the beginning of the list.Rate this question:
-
- 4.
Which statement is true about using burst key to burst reports?
- A.
A burst key can be added to a crosstab report.
- B.
A burst key can be added to a list report.
- C.
A burst key can be added to a chart report.
- D.
A burst key can be added to a Map report.
Correct Answer
B. A burst key can be added to a list report.Explanation
A burst key can be added to a list report. This means that a list report can be organized and distributed based on the values of a burst key. The burst key determines how the report is split and delivered to different recipients. By using a burst key, the list report can be customized and sent to specific individuals or groups based on their defined criteria. This allows for targeted and personalized distribution of the report.Rate this question:
-
- 5.
In Report Studio, why would an author unlock a report?
- A.
To open a report saved locally in XML.
- B.
To insert an object inside a list column.
- C.
To apply conditional formatting.
- D.
To view data that has been restricted in Framework
Correct Answer
B. To insert an object inside a list column.Explanation
An author would unlock a report in Report Studio to insert an object inside a list column. This means that they want to add an additional element or component within a specific column of the report. By unlocking the report, the author gains the ability to make changes and modifications to the structure and layout of the report, including inserting objects into list columns.Rate this question:
-
- 6.
In Event Studio, which definition best describes the event key?
- A.
. The object that is created in Event Studio. DreamBig Technologies
- B.
Specific occurrence of data items that an agent must detect.
- C.
One or more data items that uniquely define an event instance
- D.
The set of detected event instances that satisfy the task execution rules
Correct Answer
C. 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 elements that can be used to identify and differentiate one event instance from another. By using the event key, Event Studio can accurately detect and trigger actions based on specific occurrences of data items that match the defined criteria.Rate this question:
-
- 7.
What is the format in which a report specification is saved in cognos connection?
- A.
HTML
- B.
XML
- C.
.XLS
- D.
PDF
Correct Answer
B. XMLExplanation
A report specification is saved in XML format in Cognos Connection. XML (Extensible Markup Language) is a widely used format for storing and exchanging data. It allows for structured and hierarchical representation of data, making it suitable for storing report specifications which often have complex structures and relationships between elements. By saving report specifications in XML format, Cognos Connection ensures that the data is stored in a standardized and easily readable format, facilitating easy sharing, editing, and processing of the report specifications.Rate this question:
-
- 8.
Which of the following is not a prompt type in report studio?
- A.
Date and time prompt
- B.
Time prompt
- C.
Evaluate prompt
- D.
Date prompt
Correct Answer
C. Evaluate promptExplanation
The given answer, "Evaluate prompt," is not a prompt type in Report Studio. Report Studio offers various prompt types to filter and customize data, such as Date and Time prompt, Time prompt, and Date prompt. However, there is no prompt type called "Evaluate prompt" in Report Studio.Rate this question:
-
- 9.
In a report studio report,which of the following properties must be set,to add white space around text within a box?
- A.
Size Overflow
- B.
Positioning
- C.
Margin
- D.
Padding
Correct Answer
D. PaddingExplanation
Padding is the correct answer because it is the property that adds space within a box. Padding refers to the space between the content and the border of an element. By setting the padding property, you can add white space around the text within a box in a report studio report. Size Overflow, Positioning, and Margin do not specifically control the space within a box, but rather deal with other aspects of element layout and positioning.Rate this question:
-
- 10.
Which of the following options is the correct steps for a report in report studio?
- A.
A. specifying the data package, choosing a basic report layout, adding data, validating the report, saving the report, running the report
- B.
B. specifying the data package, adding data, validating the report, saving the report, running the report, choosing a basic report layout
- C.
C. specifying the data package, validating the report, saving the report, running the report, choosing a basic report layout, adding data
- D.
D. specifying the data package, validating the report, saving the report, choosing a basic report layout, adding data, , running the report
Correct Answer
A. A. specifying the data package, choosing a basic report layout, adding data, validating the report, saving the report, running the reportExplanation
The correct steps for creating a report in Report Studio are as follows: first, specify the data package; then, choose a basic report layout; next, add the data to the report; after that, validate the report to ensure accuracy; then, save the report for future use; finally, run the report to generate the desired output. This sequence ensures that the necessary data is available, the report layout is selected, the data is added correctly, and the report is validated and saved before running it.Rate this question:
-
- 11.
Which object will be used to create 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.
Singleton
- B.
List
- C.
Crosstab
- D.
Repeater
Correct Answer
D. RepeaterExplanation
A repeater object will be used to create the mailing labels for all of the company's retailers. A repeater is commonly used in reporting tools to repeat a section of a report for each record in a dataset. In this case, the repeater object will repeat the mailing label section for each retailer, allowing the report author to generate mailing labels for all of the company's retailers.Rate this question:
-
- 12.
Which of the following statement is true about detail filter?
- A.
Detail filter is applied to summary data item in a report.
- B.
Applied only to detail items from the data source
- C.
A & B both
- D.
None of A and B
Correct Answer
B. Applied only to detail items from the data sourceExplanation
The correct answer is "Applied only to detail items from the data source". This means that the detail filter is only applied to individual data items in the report, rather than summary data items. It does not affect the summary data in any way.Rate this question:
-
- 13.
The sales department require a report that numerically compares the gross profit generated for all products lines in each territory. In Report Studio, which is the most appropriate report type?
- A.
List
- B.
Chart
- C.
Crosstab
- D.
Repeater
Correct Answer
D. RepeaterExplanation
A repeater report in Report Studio would be the most appropriate report type for comparing the gross profit generated for all product lines in each territory. A repeater report allows for the repetition of a section of the report for each unique value in a specified data item, which in this case would be the product lines. This would allow the sales department to easily compare the gross profit for each product line in each territory in a clear and organized manner.Rate this question:
-
- 14.
Which of the following is true of an OLAP data structure?
- A.
Comprised of normalized dimension and fact structures
- B.
Organizes dimension tables into hierarchies and levels.
- C.
.Allows "real time" analysis against disparate data sources.
- D.
Cardinality must be defined.
Correct Answer
B. Organizes dimension tables into hierarchies and levels.Explanation
An OLAP data structure organizes dimension tables into hierarchies and levels. This means that the data is structured in a way that allows for easy navigation and analysis based on different levels of detail. Dimension tables represent the different attributes or characteristics of the data, and organizing them into hierarchies and levels allows for drill-down analysis and aggregation of data at different levels of granularity. This helps in gaining insights and understanding trends and patterns in the data.Rate this question:
-
- 15.
What does a star schema database structure typically consist of?
- A.
De-normalized hierarchy of dimension tables and fact tables.
- B.
Normalized dimension tables and detailed fact tables.
- C.
Normalized dimension tables and summarized fact tables.
- D.
De-normalized dimension tables and fact tables
Correct Answer
D. 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 are de-normalized, meaning that they contain redundant data to improve query performance. The fact tables contain the measurements or metrics that are being analyzed. This structure is commonly used in data warehousing and allows for efficient and simplified querying of large amounts of data.Rate this question:
-
- 16.
Which of the following objects in the Framework Manager environment acts as a container and provides a unique name for objects?
- A.
Model
- B.
Folder
- C.
Namespace
- D.
Query subject folder
Correct Answer
C. NamespaceExplanation
A namespace in the Framework Manager environment acts as a container and provides a unique name for objects. It helps organize and categorize objects within the environment, ensuring that each object has a distinct name. By using namespaces, objects can be easily identified and accessed, making it easier for users to navigate and work with the objects in the Framework Manager environment.Rate this question:
-
- 17.
What is the extension of a project file created in Framework Manager?
- A.
Pdf
- B.
Mdf
- C.
Cpf
- D.
Xml
Correct Answer
D. XmlExplanation
The extension of a project file created in Framework Manager is xml. Framework Manager is a metadata modeling tool used in IBM Cognos to create and manage business intelligence models. The project file created in Framework Manager stores the metadata information and structure of the model in an XML format. This XML file can be used to import and export the model between different environments or instances of Framework Manager.Rate this question:
-
- 18.
Which is not a type of filter in Framework manager?
- A.
Standalone Filter
- B.
Detail Filter
- C.
Embedded Filter
- D.
None
Correct Answer
B. Detail FilterExplanation
The correct answer is "Detail Filter" because it is not a type of filter in Framework Manager. Framework Manager supports two types of filters: Standalone Filters and Embedded Filters. Standalone Filters are filters that are created separately from the query and can be reused across multiple queries. Embedded Filters are filters that are created within a query and are specific to that query. However, Detail Filter is not a recognized type of filter in Framework Manager.Rate this question:
-
- 19.
Which of the following cognos component is window based?
- A.
Report Studio
- B.
Event Studio
- C.
Framework Manager
- D.
Analysis Studio
Correct Answer
C. Framework ManagerExplanation
Framework Manager is a window-based Cognos component because it is a metadata modeling tool that allows users to create and manage business models. It provides a graphical interface where users can define data sources, create relationships between tables, and define calculations and business rules. This tool is primarily used by administrators and power users to create and maintain the metadata layer for reporting and analysis purposes.Rate this question:
-
- 20.
In Report Studio what is the baseline?
- A.
A value in a list report that other values are compared against.
- B.
A border in a crosstab that seperates measures from aggregate totals.
- C.
A constant value drawn on a chart to indicate major divisions in the data.
- D.
A break point that lets you keep part of a report stationary while you scroll.
Correct Answer
C. A constant value drawn on a chart to indicate major divisions in the data.Explanation
The baseline in Report Studio refers to a constant value that is drawn on a chart to indicate major divisions in the data. It helps to visually represent the divisions and provide a reference point for understanding the data.Rate this question:
-
- 21.
In Report Studio, which chart lets the report author plot a third measure?
- A.
Area
- B.
Bubble
- C.
Scatter
- D.
Progressive column
Correct Answer
B. BubbleExplanation
The Bubble chart in Report Studio allows the report author to plot a third measure. This type of chart is useful when comparing three different variables simultaneously. The size of the bubbles represents the value of the third measure, while the x and y axes represent the other two measures. This chart helps visualize the relationships and patterns between the three measures in a clear and concise manner.Rate this question:
-
- 22.
Which of the following security is not applied in framework manager?
- A.
Row level security
- B.
Report level security
- C.
Object level security
- D.
Package level security
Correct Answer
B. Report level securityExplanation
Report level security is not applied in framework manager. Framework manager is a metadata modeling tool used to create and manage business models for reporting purposes. It allows users to define and enforce security at different levels such as row level, object level, and package level. However, report level security is not a security option available in framework manager. Report level security is typically applied in reporting tools or platforms, such as Cognos Report Studio, to control access and visibility of reports for different users or user groups.Rate this question:
-
- 23.
Which statement is true about using burst key to burst reports?
- A.
A burst key can be added to a crosstab report.
- B.
A burst key can be added to a list report.
- C.
A burst key can be added to a chart report.
- D.
A burst key can be added to a Map
Correct Answer
B. A burst key can be added to a list report.Explanation
A burst key can be added to a list report. This means that the list report can be configured to automatically generate and distribute multiple versions of the report based on a specified key. The burst key determines the criteria for splitting the report into different versions, such as by department, region, or customer. Each version of the report will contain data specific to the corresponding burst key value, allowing for personalized and targeted distribution of the report to different recipients.Rate this question:
-
- 24.
Which is not a type of relationship in framework manager?
- A.
One-to-one
- B.
One-to many or zero-to-many
- C.
Zero-to-zero
- D.
Many-to-many
Correct Answer
C. Zero-to-zeroExplanation
Zero-to-zero is not a type of relationship in framework manager. In a zero-to-zero relationship, there is no connection or association between two entities. It means that neither entity has any relationship with the other. This type of relationship is not commonly used or defined in database management systems or framework managers as it does not provide any meaningful information or connection between entities.Rate this question:
-
- 25.
In Report Studio, Why would an author use the Page Structure View?
- A.
To move object in a report
- B.
To change the underlying query
- C.
To add a new page to the report.
- D.
To drive page layout using a query.
Correct Answer
A. To move object in a reportExplanation
The Page Structure View in Report Studio allows authors to easily move objects within a report. This view provides a visual representation of the report's layout and structure, allowing authors to drag and drop objects to different positions on the page. This feature is useful for organizing and rearranging report elements to improve the overall design and readability of the report.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Aug 27, 2023Quiz Edited by
ProProfs Editorial Team -
Jul 05, 2012Quiz Created by
Cvktech
Back to top