Can You Pass This Cognos Test? Trivia Quiz.

10 Questions | Total Attempts: 155

SettingsSettingsSettings
Please wait...
Can You Pass This Cognos Test? Trivia Quiz.

Cognos has been in existence for a while now. In 2008, IBM acquired it. Today, Cognos is used by various companies all around the world to test the performance management of their employees. The software is one of the best performance testing software. This quiz will test how vast your performance knowledge is using Cognos.


Questions and Answers
  • 1. 
    What can be done when using a SQL object when not using a stored procedure?
    • A. 

      Delete rows in a database.

    • B. 

      Insert rows into database.

    • C. 

      Select rows from a database

    • D. 

      Update a database.

  • 2. 
    A report author creates the following filter in a report: [Region] in (' Americas',' Asia Pacific') Which type of filter was created?
    • A. 

       Advanced

    • B. 

      Parameterized

    • C. 

      Custom based on data item

    • D. 

      Combined

  • 3. 
    How can an Uploaded file be combined with data from a database?
    • A. 

      Use a Master detail relationship.

    • B. 

      Include the Uploaded file and a package as a Data source to the report

    • C. 

      Create a Data module.

    • D. 

      Nest a List using the Uploaded file with another List from a package

  • 4. 
    A report author wants to display the report name on the report page. Which type of calculation should be used?
    • A. 

      Layout calculation

    • B. 

      Query calculation

    • C. 

      Singleton

    • D. 

      Field se

  • 5. 
    Which statement is true about using a 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 map report.

    • C. 

      A burst key can be added to a chart report.

    • D. 

      A burst key can be added to a list report.

  • 6. 
    In Report Studio, an author creates a list report containing columns for Staff Name, Order number, and Revenue. The author wants to burst this report to various sales staff members. Each member should see only data relating to sales they have made. What must the author do to specify that the burst report output will contain only data for the appropriate sales staff member?
    • A. 

      In the burst options for the report, use the Staff Name data item to specify the Burst Groups.

    • B. 

      In the burst options for the report, use the Staff Name data item to specify the Burst Recipients.

    • C. 

      In the report layout, create a master-detail relationship on the Staff Name data item.

    • D. 

      In the report layout, add the Staff Name data item as a property of the List object.

  • 7. 
    An author creates a report for bursting. In Report Studio, the author sets the burst type for the report to Directory entries. In Cognos Connection, the author sets the run options to burst the report and send the report by email. If the email addresses for the burst recipients are accessible by IBM Cognos BI, what is the expected result?
    • A. 

      A warning message appears indicating a conflict in the run options.

    • B. 

      The report is burst to both email addresses and directory entries.

    • C. 

      The report is burst to directory entries only.

    • D. 

      The report is burst to email addresses only.

  • 8. 
    In Report Studio, an author creates a weekly sales report and modifies the global class setting in the report. Which reports will this modifications affects?
    • A. 

      All reports

    • B. 

      Report created using the same package

    • C. 

      Reports created within the log on section

    • D. 

      Only the current report

  • 9. 
    In a Report Studio, an author wants the report title to appear in the language in which the report is run.  What property of the report header must the author define to create this variable?
    • A. 

      Style Variable

    • B. 

      Text Source Variable

    • C. 

      Render Variable

    • D. 

      String Variable

  • 10. 
    In Report Studio, for which task would an author create a query calculation?
    • A. 

      Derive additional information from data source

    • B. 

      Let users choose which filter to apply to a report

    • C. 

      Add report run-time information a report

    • D. 

      None of the above