Cognos Assessment Test For Developers! Trivia Quiz
This quiz is designed to challenge the applicants general and specific knowledge of Cognos applications and some database questions pertaining to Oracle. If the applicant has any disabilities which prevent the applicant from completing this quiz, please notify the recruiter immediately. A high score on this quiz does not ensure an offer will be extended, but rather affirms that the minimum qualifications have been met sufficiently.
This quiz consists of 30 multiple choice questions.
Please do not use any Cognos or Oracle documentation during this quiz.
Questions and Answers
- 1.
Which of the following is NOT a usage property in Framework Manager?
- A.
Fact
- B.
Dimension
- C.
Attribute
- D.
Identifier
- E.
Unknown
Correct Answer
B. DimensionExplanation
A dimension is NOT a usage property in Framework Manager. In Framework Manager, a dimension is a structure that categorizes data and provides context to measures. It is used to analyze and filter data, but it is not considered a usage property. Usage properties in Framework Manager include fact, attribute, identifier, and unknown. Fact is used to represent numeric data that can be aggregated, attribute is used to represent descriptive data, identifier is used to uniquely identify a record, and unknown is used when the data type is not known.Rate this question:
-
- 2.
Within the expression editor of Framework Manager, a quality of service indicator on functions gives a visual clue about the behavior of the function. What quality of service indicator reflects the danger of poor performance on some data sources?
- A.
X
- B.
!!
- C.
!
- D.
&
- E.
No symbol
Correct Answer
C. !Explanation
The quality of service indicator that reflects the danger of poor performance on some data sources is "!". This symbol indicates that the function may cause performance issues when used with certain data sources.Rate this question:
-
- 3.
What is the regular aggregate property of a calculated fact object within Framework Manager?
- A.
Sum
- B.
Total
- C.
Average
- D.
Automatic
- E.
Unsupported
Correct Answer
D. AutomaticExplanation
The regular aggregate property of a calculated fact object within Framework Manager is "Automatic". This means that the aggregation for the calculated fact will be automatically determined based on the aggregation of the underlying measures used in the calculation. For example, if the calculation involves a sum of measures, the calculated fact will be aggregated as a sum. If the calculation involves an average of measures, the calculated fact will be aggregated as an average. This automatic aggregation property allows for flexibility and ensures that the calculated fact is aggregated correctly based on the underlying measures.Rate this question:
-
- 4.
Within Framework Manager, what objects are used to store key-value pairs which create conditional query subjects that allow for substitutions when the report is run?
- A.
Packages
- B.
Parameters
- C.
Filters
- D.
Query Subjects
- E.
Namespaces
Correct Answer
B. ParametersExplanation
Parameters in Framework Manager are used to store key-value pairs which create conditional query subjects. These parameters allow for substitutions when the report is run, enabling users to dynamically change the values used in the query. By defining parameters, users can create flexible and interactive reports that can be customized based on their needs.Rate this question:
-
- 5.
Within Framework Manger, this type of SQL does not process query subjects as subqueries.
- A.
Pass-Through SQL
- B.
Cognos SQL
- C.
Native SQL
- D.
PL SQL
Correct Answer
A. Pass-Through SQLExplanation
Pass-Through SQL is the correct answer because within Framework Manager, this type of SQL is used to directly pass the SQL statements to the underlying database without any modification or processing. It allows the database to handle the query subjects as subqueries, rather than Framework Manager processing them. This can be useful when dealing with complex queries or specific database functions that are not supported by Framework Manager.Rate this question:
-
- 6.
When creating a package in Framework Manager, the following setting allows the data within an object to be used in other objects without the original object itself being available to report users.
- A.
Select
- B.
Traverse
- C.
Unselect
- D.
Hide
Correct Answer
D. HideExplanation
The "Hide" setting in Framework Manager allows the data within an object to be used in other objects without the original object itself being available to report users. This means that the data can still be accessed and utilized in other parts of the package or report, but it will not be visible or directly accessible to the end users. This can be useful in cases where certain data or calculations need to be hidden or protected from direct manipulation by the users.Rate this question:
-
- 7.
In Framework Manager, what object is required to enable drilling up and down in a hierarchy used in Analysis Studio reports?
- A.
Identifier
- B.
Fact
- C.
Dimension
- D.
Attribute
Correct Answer
C. DimensionExplanation
In Framework Manager, a dimension is required to enable drilling up and down in a hierarchy used in Analysis Studio reports. Dimensions provide the structure and context for analyzing data, allowing users to drill down into more detailed levels or drill up to higher levels of aggregation. By defining hierarchies within dimensions, users can navigate through the data and gain insights at different levels of granularity. Therefore, having a dimension is essential for enabling drilling up and down in a hierarchy in Analysis Studio reports.Rate this question:
-
- 8.
In Cognos Connection, which of the following is a valid permission to be granted at the report level?
- A.
Run
- B.
View
- C.
Traverse
- D.
Edit
Correct Answer
C. TraverseExplanation
Traverse is a valid permission to be granted at the report level in Cognos Connection. This permission allows users to navigate through folders and access the report. It does not grant the ability to run, view, or edit the report, but it enables users to locate and access the report within the folder structure.Rate this question:
-
- 9.
Within Cognos Connection, these objects are used to control the display of one or more reports in a single portal page or in a dashboard.
- A.
Calculations
- B.
Global Filters
- C.
NewsItems
- D.
Policies
Correct Answer
B. Global FiltersExplanation
Global Filters are used within Cognos Connection to control the display of one or more reports in a single portal page or in a dashboard. They allow users to apply filters to multiple reports simultaneously, ensuring that the data displayed is relevant and consistent across the reports. By using global filters, users can easily analyze data from different perspectives without having to manually apply filters to each individual report. This helps in streamlining the analysis process and making it more efficient.Rate this question:
-
- 10.
In Cognos Connection, RSS news feeds may be specified by a URL address.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
In Cognos Connection, RSS news feeds can be specified by a URL address. This means that users can provide the URL of the RSS feed they want to subscribe to, and Cognos Connection will retrieve and display the news feed content from that URL. This allows users to stay updated with the latest news and information from various sources by simply specifying the URL of the desired RSS feed.Rate this question:
-
- 11.
When tuning performance, one should remember that the following setting takes precedence over the other two settings:
- A.
Advanced Routing Settings
- B.
Affinity Settings
- C.
Balance Request Settings
Correct Answer
B. Affinity SettingsExplanation
When tuning performance, it is important to remember that the "Affinity Settings" take precedence over the other two settings, namely "Advanced Routing Settings" and "Balance Request Settings". This means that any configuration or adjustments made in the Affinity Settings will have a higher priority and will be prioritized over the other settings when it comes to optimizing performance.Rate this question:
-
- 12.
What is the Cognos 8 service that manages the storage of customer applications, including application-specific security, configuration data, models, metrics, reports, and report output?
- A.
Gateway
- B.
Package
- C.
Namespace
- D.
Content Manager
Correct Answer
D. Content ManagerExplanation
The correct answer is Content Manager. Content Manager is the Cognos 8 service that is responsible for managing the storage of customer applications. It handles various aspects such as application-specific security, configuration data, models, metrics, reports, and report output. Content Manager ensures that all the necessary data and resources are stored and organized efficiently, allowing users to access and manage their applications effectively.Rate this question:
-
- 13.
In Transformer, alternate drill-down paths / alternate hierarchies must have the a convergence level that is:
- A.
Unique
- B.
Ordered
- C.
Open
- D.
Set
Correct Answer
A. UniqueExplanation
In Transformer, alternate drill-down paths or alternate hierarchies must have a convergence level that is unique. This means that each level in the hierarchy should have a distinct value and there should be no repetition or duplication of levels. This ensures that the drill-down paths are well-defined and can be easily navigated without any ambiguity or confusion. Having a unique convergence level also helps in maintaining data integrity and consistency within the hierarchy.Rate this question:
-
- 14.
For what purpose are custom views used in Transformer?
- A.
Point-In-Time Reporting
- B.
Security
- C.
Manage Languages
- D.
Performance Optimization
Correct Answer
B. SecurityExplanation
Custom views are used in Transformer for security purposes. Custom views allow users to define their own views of the data, specifying which dimensions and measures they can access. By using custom views, administrators can control the level of data access and ensure that sensitive information is only visible to authorized users. This helps in maintaining data security and preventing unauthorized access to confidential data.Rate this question:
-
- 15.
Can SQL code be added directly into a Report Studio report?
- A.
Yes
- B.
No
Correct Answer
A. YesExplanation
SQL code can be added directly into a Report Studio report. This allows users to write custom SQL queries to retrieve specific data from the database and display it in the report. This feature provides flexibility and control over the data that is included in the report.Rate this question:
-
- 16.
When working with dimensional data in Report Studio, an intersection is useful for obtaining a value from the combination of two or more members that you specify. This intersection is called:
- A.
A Singleton
- B.
A X Axis Measurement
- C.
A Visual Angle
- D.
A Position
- E.
A Tuple
Correct Answer
E. A TupleExplanation
A tuple is the correct answer because it refers to the combination of two or more members in dimensional data. In Report Studio, a tuple is used to obtain a value from the intersection of these members. A tuple can be thought of as a coordinate point where the dimensions intersect, allowing for specific data points to be retrieved and analyzed.Rate this question:
-
- 17.
In Report Studio, which of the following is not a valid prompt button?
- A.
Execute
- B.
Back
- C.
Cancel
- D.
Reprompt
- E.
Next
Correct Answer
A. ExecuteExplanation
The given question asks for a prompt button that is not valid in Report Studio. The correct answer is "Execute." This button is not a valid prompt button because it is used to execute or run the report, rather than to prompt the user for input or selection. The other options, Back, Cancel, Reprompt, and Next, are all valid prompt buttons that allow the user to navigate through the prompts and make selections or changes before executing the report.Rate this question:
-
- 18.
In Report Studio, what function would be useful in implementing alternate line shading within a list box?
- A.
Char_length
- B.
CurrentMember
- C.
Mod
- D.
Exp
- E.
Order
Correct Answer
C. ModExplanation
The mod function would be useful in implementing alternate line shading within a list box in Report Studio. The mod function returns the remainder of a division operation, and it can be used to determine if a line number is even or odd. By using the mod function with a value of 2, the shading can be applied to alternate lines based on whether the line number is even or odd.Rate this question:
-
- 19.
In Report Studio, what property may be set to prevent the object from being rendered and prevent its space from being reserved in the report?
- A.
Box Type
- B.
Visible
- C.
No Data Object
- D.
Contents Height
Correct Answer
A. Box TypeExplanation
The correct answer is Box Type. In Report Studio, the Box Type property can be set to prevent the object from being rendered and prevent its space from being reserved in the report. This means that the object will not be displayed in the report and its space will be freed up, allowing other objects to be displayed in that area.Rate this question:
-
- 20.
In Report Studio, at what level must the query be specified?
- A.
List
- B.
List Cell
- C.
List Column
- D.
List Column Body
- E.
List Header
Correct Answer
A. ListExplanation
In Report Studio, the query must be specified at the "List" level. This means that the query is defined for the entire list object, which includes all the list cells, list columns, list column bodies, and list headers. Specifying the query at the list level ensures that the data retrieved from the database is consistent and applicable to all the elements within the list.Rate this question:
-
- 21.
Are Metric Studio metrics part of the Content Store?
- A.
Yes
- B.
No
Correct Answer
B. NoExplanation
Metric Studio metrics are not part of the Content Store. The Content Store is a repository for storing and managing content items such as reports, dashboards, and packages in IBM Cognos. On the other hand, Metric Studio is a tool within IBM Cognos that allows users to create and manage metrics, which are calculations or aggregations based on data. While both Metric Studio and the Content Store are components of IBM Cognos, they serve different purposes and have separate functionalities.Rate this question:
-
- 22.
In Analysis Studio, what functionality would cause subtotals or totals to result in more than the sum of the rows or columns?
- A.
Custom Set
- B.
Nested Rows
- C.
Hidden Rows
- D.
Custom Filters
Correct Answer
C. Hidden RowsExplanation
Hidden Rows functionality in Analysis Studio can cause subtotals or totals to result in more than the sum of the rows or columns. When certain rows are hidden, the subtotals or totals will not take into account the hidden rows, resulting in an incorrect calculation. This can lead to a higher sum than expected for the subtotals or totals.Rate this question:
-
- 23.
What feature allows reports to run based upon the package at the time the report was last saved?
- A.
Deployment
- B.
Verify
- C.
Versioning
- D.
Preserve
Correct Answer
C. VersioningExplanation
Versioning allows reports to run based upon the package at the time the report was last saved. This means that when a report is saved, a specific version is assigned to it. When the report is run, it will use the package from that specific version, ensuring that the report is based on the correct data and structure that was in place at the time of saving.Rate this question:
-
- 24.
In an Oracle SQL insert statement, is it necessary to designate the column names?
- A.
Yes
- B.
No
Correct Answer
B. NoExplanation
In an Oracle SQL insert statement, it is not necessary to designate the column names. When inserting values into a table, if the column names are not specified, the values will be inserted into the columns in the order they appear in the table. However, it is generally considered good practice to explicitly specify the column names to avoid any confusion or errors, especially when dealing with tables that have many columns or when the table structure may change in the future.Rate this question:
-
- 25.
Without using aggregation (Group By), is it possible to determine the minimum or maximum value of a data set using Oracle SQL?
- A.
Yes
- B.
No
Correct Answer
A. YesExplanation
It is possible to determine the minimum or maximum value of a data set without using aggregation (Group By) in Oracle SQL by using the MIN() and MAX() functions. These functions allow us to find the minimum and maximum values respectively from a column or set of columns in a table. So, we can use these functions to find the minimum or maximum value without the need for aggregation.Rate this question:
-
- 26.
Which of the following is NOT a valid Oracle SQL statement?
- A.
SELECT column1, SUM(column2) "column2" FROM table1 GROUP BY column1 ORDER BY column1
- B.
SELECT column1, SUM(column2) "column2" FROM table1 HAVING SUM(column2) = 0 GROUP BY column1 ORDER BY column1
- C.
SELECT column1, SUM(column2) "column2" FROM table1 GROUP BY column1 HAVING SUM(column2) = 0 ORDER BY column1
- D.
SELECT column1, SUM(column2) "column2" FROM table1 ORDER BY column1 GROUP BY column1
Correct Answer
D. SELECT column1, SUM(column2) "column2" FROM table1 ORDER BY column1 GROUP BY column1Explanation
The given answer is incorrect because the ORDER BY clause should come after the GROUP BY clause in an Oracle SQL statement. In the given answer, the ORDER BY clause is placed before the GROUP BY clause, which is not a valid syntax in Oracle SQL.Rate this question:
-
- 27.
In Oracle SQL, what is the command that returns the first non-null value in a list of values?
- A.
NVL
- B.
DECODE
- C.
COALESCE
- D.
INSTR
- E.
ISNOTNULL
Correct Answer
C. COALESCEExplanation
The COALESCE command in Oracle SQL is used to return the first non-null value in a list of values. It takes multiple arguments and evaluates them in the order they are provided. If any of the arguments are not null, the COALESCE command returns that value. If all the arguments are null, it returns null. Therefore, COALESCE is the correct command to use when you want to retrieve the first non-null value from a list of values.Rate this question:
-
- 28.
In Oracle 11i, which of the following objects does not physically store data?
- A.
Views
- B.
Tables
- C.
Materialized Views
Correct Answer
A. ViewsExplanation
Views in Oracle 11i do not physically store data. They are virtual tables that are created based on the result of a query. Views provide a way to present data from one or more tables in a customized manner without actually storing the data themselves. They can be used to simplify complex queries, restrict access to certain columns or rows, or provide a different perspective on the data.Rate this question:
-
- 29.
If the user desires to retrieve all rows from Table A and all rows from Table B based on a join criteria, what type of join would be necessary?
- A.
Left Outer Join
- B.
Inner Join
- C.
Cross Join
- D.
Cluster Join
- E.
Cartesian Join
Correct Answer
E. Cartesian JoinExplanation
A Cartesian Join, also known as a Cross Join, would be necessary in this case. This type of join returns the Cartesian product of the two tables, meaning it combines every row from Table A with every row from Table B, regardless of any join criteria. It does not consider any conditions for matching rows, resulting in a potentially large number of rows in the output.Rate this question:
-
- 30.
In Oracle 11i, what type of index is used to index low cardinality columns in a warehouse environment?
- A.
Function-based
- B.
Bitmap
- C.
Optimized
- D.
Normal
Correct Answer
B. BitmapExplanation
In Oracle 11i, the type of index used to index low cardinality columns in a warehouse environment is a Bitmap index. A Bitmap index is suitable for columns with a small number of distinct values, as it uses a bitmap to represent the presence or absence of each value in the index. This type of index is efficient for data warehousing scenarios where there are large amounts of data and queries involve range or set operations on these low cardinality columns.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
-
Sep 03, 2023Quiz Edited by
ProProfs Editorial Team -
Jun 21, 2010Quiz Created by
Aubryhenkel
Back to top