Cognos Online Test

25 Questions | Total Attempts: 376

SettingsSettingsSettings
Please wait...
Cognos Quizzes & Trivia

Total 25 Questions,each one carry 1 mark and duration is 30 min.


Questions and Answers
  • 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

  • 2. 
    In Report Studio, which chart lets the report author plot a third measure?
    • A. 

      Area

    • B. 

      Bubble

    • C. 

      Scatter

    • D. 

      Progressive column

  • 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

  • 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.

  • 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

  • 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

  • 7. 
    What is the format in which a report specification is saved in cognos connection?
    • A. 

      HTML

    • B. 

      XML

    • C. 

      .XLS

    • D. 

      PDF

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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.

  • 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

  • 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

  • 17. 
    What is the extension of a project file created in Framework Manager?
    • A. 

      Pdf

    • B. 

      Mdf

    • C. 

      Cpf

    • D. 

      Xml

  • 18. 
    Which is not a type of filter in Framework manager?
    • A. 

      Standalone Filter

    • B. 

      Detail Filter

    • C. 

      Embedded Filter

    • D. 

      None

  • 19. 
    Which of the following cognos component is window based?
    • A. 

      Report Studio

    • B. 

      Event Studio

    • C. 

      Framework Manager

    • D. 

      Analysis Studio

  • 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.

  • 21. 
    In Report Studio, which chart lets the report author plot a third measure?
    • A. 

      Area

    • B. 

      Bubble

    • C. 

      Scatter

    • D. 

      Progressive column

  • 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

  • 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

  • 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

  • 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.