IBM C1000-065 Online Practice Questions and Exam Preparation

IBM C1000-065 Online Questions & Answers

• Question 11:

  What is a Compare card in a Cognos Analytics Exploration?

  A. A static view/card used to compare and view data across visualizations with different filters.
  B. A view/card that uses a specialized algorithm (XGCompare) to analyse data and generate a driver
  C. A view/card used to allow the interactive comparison of data across two visualizations with different filters.
  D. A view/card used to compare data from one database with a different set of data from another database.
  B. A view/card that uses a specialized algorithm (XGCompare) to analyse data and generate a driver

• Question 12:

  In a report, which of the following is true when enabling the local cache property on a query?

  A. Local cache is only supported on batch re|
  B. Data is cached and may improve performance.
  C. A complete result set is cached for all queries in the model.
  D. The scalability of a report is negatively impacted.
  A. Local cache is only supported on batch re|

• Question 13:

  To create a Layout Component Reference in a report, which object property needs to be provided?

  A. Conditional Reference
  B. Label
  C. Name
  D. Render Variable
  C. Name

• Question 14:

  What is the difference between a Cognos Analytics Story and Dashboard?

  A. Stories use report objects to present information in an exported format whilst a dashboard is interactive.
  B. A dashboard is a Cognos Analytics story.
  C. Dashboards are live and interactive whereas a Story is the notes attached to the dashboard that help explain the content of a widget.
  D. A story adds to a dashboard's capability by augmenting it with animation and scene changes.
  A. Stories use report objects to present information in an exported format whilst a dashboard is interactive.

• Question 15:

  Which technique is most likely to improve query performance?

  A. Set the auto-sort property to maximum.
  B. Set the detail aggregation to 'Calculated' for measures.
  C. Avoid functions in filters.
  D. Add more joins between queries.
  B. Set the detail aggregation to 'Calculated' for measures.

• Question 16:

  In which two places is Al used in a dashboard line chart visualization?

  A. The legend
  B. Forecast
  C. Data point shape
  D. Axis tick marks
  E. Meaningful differences
  D. Axis tick marks
  E. Meaningful differences

• Question 17:

  Which two statements are true when creating navigation paths?

  A. A data module can have multiple navigation paths.
  B. A modeler must delete the navigation path and re-create it to change the path.
  C. Columns from different tables cannot be added to a navigation path.
  D. A navigation path is a collection of Group Data columns.
  E. A navigation path is a collection of non-measure columns.
  B. A modeler must delete the navigation path and re-create it to change the path.
  E. A navigation path is a collection of non-measure columns.

• Question 18:

  A Framework Manager model may be designed to incorporate Dimensionally Modeled Relational (DMR) objects, designed to offer the end user OLAP behavior when navigating dat

  A. Which of the following statements is valid when designing DMR structures in Framework Manager?
  B. Measures and Dimensions can reside in the same query subject.
  C. The DMR structures need to resemble the objects in the star schema.
  D. The order of the Determinants drives the hierarchy levels.
  E. Each level in a hierarchy must reference a text-based attribute for its caption.
  A. Which of the following statements is valid when designing DMR structures in Framework Manager?

• Question 19:

  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?

  A. All queries are collapsed and a standard join across all three tables (a, b, c) is performed.
  B. 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).
  C. 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.
  D. The joined view (a and b) is evaluated and all results are then post-joined to the other table (c).
  D. The joined view (a and b) is evaluated and all results are then post-joined to the other table (c).

• Question 20:

  A fast and user friendly way to create an initial dashboard is to use the text-based Assistant. When using the Assistant, which option below will develop a dashboard?

  A. In the Assistant, enter 'show data', select a datasource from the list, and enter 'create dashboard' or 'build dashboard1.
  B. In a new dashboard, select a datasource, and enter 'create visualization'.
  C. In a new dashboard, select a template and a datasource.
  D. In a new dashboard, search for data, select a template and enter 'create'.
  D. In a new dashboard, search for data, select a template and enter 'create'.