IBM C1000-065 IBM Cognos Analytics Developer V11.1.x Exam Exam Practice Test Questions

• Question 1

  Which of the following is a reason to use a Conditional block on a report?

  • To allow users to select values that will filter the report for certain data types
  • To allow a report to run during certain blocks of time based on conditions set by the user
  • To show or hide report objects based on prompt selections a user made at run time
  • To block defined groups of users from accessing a folder of reports based on a condition

  Show Answer Answer: 4 Next

• Question 2

  After upgrading from Cognos version 10 what needs to be selected in order to create a data module on a data server?

  • Select 'Allow web-based modeling' in Cognos Configuration when starting the server
  • Select 'Allow web-based modeling' in the Cognos installer when upgrading the server components.
  • Under the Data Server Connection in the Administration Console configuration select 'Allow Framework Manager'.
  • Under the Data Source Connection in the Administration Console configuration select 'Allow web-based modeling'.

  Show Answer Answer: 2 Next

• Question 3

  Which of the following is an example of when the query cache would avoid roundtrips to the database?

  • Repetitive master-detail requests
  • Drill through reports
  • Reports with multiple queries
  • Drill down reports

  Show Answer Answer: 1 Next

• Question 4

  What property needs to be set to ensure that any JavaScript and Prompt APIs are executed when a report is run as HTML?

  • Ensure Enable bidirectional support is checked
  • Run with full interactivity is set to No
  • Enable drill up and drill down in the report output
  • Guided report layout is checked

  Show Answer Answer: 4 Next

• Question 5

  In a Data Module a developer creates a joined view from two tables (a and b) and then joins this to another table (c). What would be the execution logic in the database?

  • All queries are collapsed and a standard join across all three tables (a, b, c) is performed.
  • The columns used in table (c) are are joined on the key to table (b) first and then the results are post-joined to table (a).
  • It makes no difference to the execution as a joined view is only used to group data items in a logical manner to help the business user find their data.
  • The joined view (a and b) is evaluated and all results are then post-joined to the other table (c).

  Show Answer Answer: 4 Next