Cognos Assessment Test For Developers! Trivia Quiz

30 Questions | Total Attempts: 955

SettingsSettingsSettings
Please wait...
Cognos Quizzes & Trivia

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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 10. 
    In Cognos Connection, RSS news feeds may be specified by a URL address.
    • A. 

      True

    • B. 

      False

  • 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

  • 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

  • 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

  • 14. 
    For what purpose are custom views used in Transformer?
    • A. 

      Point-In-Time Reporting

    • B. 

      Security

    • C. 

      Manage Languages

    • D. 

      Performance Optimization

  • 15. 
    Can SQL code be added directly into a Report Studio report?
    • A. 

      Yes

    • B. 

      No

  • 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

  • 17. 
    In Report Studio, which of the following is not a valid prompt button?
    • A. 

      Execute

    • B. 

      Back

    • C. 

      Cancel

    • D. 

      Reprompt

    • E. 

      Next

  • 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

  • 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

  • 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

  • 21. 
    Are Metric Studio metrics part of the Content Store?
    • A. 

      Yes

    • B. 

      No

  • 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

  • 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

  • 24. 
    In an Oracle SQL insert statement, is it necessary to designate the column names?
    • A. 

      Yes

    • B. 

      No

  • 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