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

When should a dimensional function be used in a report's Query calculation?

• when the data source is a dimensional or dimensionally-modeled data source
• to allow relative date functions to be performed against a non-dimensional data source
• to convert a non-dimensional data source into a dimensionally-modeled data source
• to allow drill up and down on a non-dimensional data source

Which of the following can result in poor report performance?

• reports with filters
• models with outer joins and cross joins
• queries with database only processing
• an optimized metadata model

Which two of the following statements are true when creating a Drill-through for a visualization in a dashboard?

• A developer can create Drill-throughs to a specific story that is created.
• A developer can create a Drill-through to a Webpage.
• One can pass selected data points to the target Drill-through as long as its data source uses the same values.
• A developer can create Drill-throughs to other dashboards and reports.
• Each visualization can only have a single Drill-through.

When a developer needs to share dashboard content with another application, the Share option provides which benefit?

• the ability to export the dashboard to Excel
• the ability to generate the HTML to create an iFrame and reference the dashboard
• the ability to export the dashboard directly to SharePoint.
• the ability to send a notification to a phone

What benefit does the Cognos Analytics integration with Jupyter Notebooks provide a developer?

• Weather data can be used from the Jupyter service to enrich information and help identify trends Example: Ice cream sales on sunny days.
• A Developer can augment Cognos Analytics with Python and data science libraries as well as embed output in a dashboard to provide the end user with greater insight.
• A Developer can add notes to content to better describe to an end user what data is available and how calculations work.
• Cognos Analytics does not integrate with Jupyter Notebooks.

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

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

• Ask the administrator to add the file as an external data source.
• Add the Data set to a Data Module.
• Add the Data set to a Framework Manager package.
• Add the Data set as a source on the report.

When using an OLAP data source, summaries that use 'For' clauses give incorrect results. Which best describes the reason for this?

• Time state rollups against OLAP data sources are not supported
• OLAP data sources do not have detail rows
• The 'For' clause does not generate incorrect summaries.
• Incorporating context filters using MDX functions is not supported.

In an Exploration 'Data relationships' view, what does the thickness of the lines between data items represent?

• the statistical strength of the relationship between the data items
• the flow of information between categories, ie. money transfers between countries
• the cardinality of one data item when grouped by another, ie. thicker signifies more unique values
• the weighted average of each measure value compared with other measures https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_explorations.doc/ca_explore_relationship_diagram.html

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?

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