IBM c1000-065 practice test

IBM Cognos Analytics Developer V11.1.x Exam


Question 1

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'.
Answer:

D

Discussions

Question 2

When selecting the Layout positioning property for a dashboard, which is the correct option for
dashboards that will be presented on different mobile devices?

  • A. Unbounded
  • B. Relative
  • C. Conditional
  • D. Absolute
Answer:

C

Discussions

Question 3

A developer has a source system provided by another company. One of the columns in a table has
spaces before each piece of data and is in uppercase which makes the reports unreadable. How can
this be solved in a data module?

  • A. there is no built in capability for this in a data module and the developer needs to create a calculation for this
  • B. there is no built in capability for this in a data module and the report needs Trim and Lower calculations added to it
  • C. using the 'Clean' menu item on the data item
  • D. using the 'Prepare' menu item on the data item
Answer:

A

Discussions

Question 4

To optimize the user experience for dashboards and explorations. Framework Manager packages
must be enriched. Which statement is true about enriching Framework Manager packages?

  • A. A developer can't enrich a package that includes dimensionally modeled (DMR) relational objects.
  • B. Framework Manager packages are automatically enriched when published to Cognos Analytics.
  • C. To access the enrich package functionality, you need read/execute/traverse permissions for the package.
  • D. In order to have enough data to support the Al-functions in your dashboards and explorations, the entire Framework Manager package must be enriched.
Answer:

D

Discussions

Question 5

What is a Cognos Analytics data set?

  • A. The data that is returned from the datasource and displayed within a report, dashboard or exploration.
  • B. The Cognos Analytics name for a Python DataFrame in a Jupyter Notebook.
  • C. An extract from a package or data module compressed, locally stored and refreshed periodically or manually.
  • D. A realtime set of data held in a streaming cache on the Cognos Analytics server.
Answer:

C

Discussions

Question 6

Which of the following is done for a report to use a Data set as a data source?

  • A. Ask the administrator to add the file as an external data source.
  • B. Add the Data set to a Data Module.
  • C. Add the Data set to a Framework Manager package.
  • D. Add the Data set as a source on the report.
Answer:

A

Discussions

Question 7

A developer may improve the look and feel of a dashboard or story by adding images and shapes
from the Widgets panel. Which statement is true when adding widgets to a dashboard?

  • A. The widgets panel may contain an Image library tab that the administrator made available
  • B. Images may only be made available by URL reference.
  • C. Images can be uploaded to the Image through the upload option on the widgets panel.
  • D. Text widgets may only be positioned vertically or horizontally.
Answer:

D

Discussions

Question 8

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.
Answer:

B

Discussions

Question 9

When developing a report, which two should be defined for a JOIN query?

  • A. a reference to two queries
  • B. only cached results
  • C. an expression editor
  • D. an intersection of two queries
  • E. a relationship defining cardinality
Answer:

AD

Discussions

Question 10

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.
Answer:

A

Discussions
To page 2