IBM IBM Certified Developer - Cognos Analytics V11.1.x C1000-065 Questions & Answers

• Question 31:

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

  A. repetitive master-detail requests

  B. drill through reports

  C. reports with multiple queries

  D. drill down reports

  Correct Answer: A

• Question 32:

  Which dashboard formatting option would be used to take several images and text objects and combine them into one object to enable ease of movement and/or alignment?

  A. Group objects

  B. Layer objects

  C. Combine objects

  D. Pack objects

  Correct Answer: A

• Question 33:

  How might a report output type of PDF be secured?

  A. by setting a password in the schedule PDF options

  B. by giving the PDF a name that starts with "confidential'

  C. by selecting the "Secure this Report" option in the report properties

  D. by specifying a PDF encryption code in the schedule settings

  Correct Answer: C

• Question 34:

  After adding a prompt to a relational sourced report it is decided that the consumers require multi- select functionality instead of a single-select. What two modifications must be made to the report?

  A. Change the Filter property Multi-select to Yes

  B. Change the Cascade source property of the Prompt to represent more than one value.

  C. Change the Prompt property Usage to Select-many.

  D. Change the Filter expression of the Query from "=" to use "in".

  E. Change the Prompt property Multi-select to Yes.

  Correct Answer: CD

• Question 35:

  A dashboard developer notices that Age is available in the sourced data module. A request has been made to 'bucket' those age values into 5 groups, Ages 0-6, 7-12, 13-21, 22-55, and 55 and over. How would one define this logic in the source data module?

  A. set range values in the data module

  B. use the Create new table feature

  C. select the Age column, and select Create data group

  D. define a Case..When calculated attribute in the dashboard

  Correct Answer: A

• Question 36:

  A developer is given the task of creating an information panel to be displayed in the foyer of the office. Which Cognos Analytics capability gives the best impact with minimal work?

  A. Story played in Kiosk mode with a loop

  B. Bespoke report using JavaScript

  C. Cognos Viewer Report

  D. Dashboard based on Exploration content

  Correct Answer: C

• Question 37:

  What is the effect of changing the Default measure property of a Crosstab in a report if a measure is already set by one of the existing edges?

  A. the Crosstab values remain the same and the Crosstab comer displays the Default measure's name

  B. the Default measure replaces the existing measure in the Crosstab edges

  C. the Default measure is displayed in the Crosstab intersections

  D. an error is produced

  Correct Answer: A

• Question 38:

  What is the significance of 'Clothes' in the following filter expression of a report query? [Product Group] = # sq( prompt( 'productgroups', 'token', 'Clothes' ) )#

  A. 'Clothes' is the default text to include in the generated query at runtime.

  B. The string 'Clothes' will precede the text of the prompt value selected at runtime.

  C. The string 'Clothes' will be appended to the end of the text of the prompt value selected at runtime.

  D. 'Clothes' is a required value to include in the generated query at runtime.

  Correct Answer: C

• Question 39:

  A. Weather data can be used from the Jupyter service to enrich information and help identify trends Example: Ice cream sales on sunny days.

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

  C. A Developer can add notes to content to better describe to an end user what data is available and how calculations work.

  D. Cognos Analytics does not integrate with Jupyter Notebooks.

  Correct Answer: D

• Question 40:

  What advantage does multidimensional report writing have on query maintenance for complex queries?

  A. There is no need to use calculations as the data source contains all the required data items.

  B. Fewer queries are required and the need for unions of queries is reduced due to the flexibility of MDX.

  C. Unions and Joins are always required for queries making it easier for a developer to understand the query intent.

  D. There is no advantage and multidimensional query constructs should be avoided.

  Correct Answer: B