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

• Question 41:

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

  Correct Answer: D

• Question 42:

  Which is true about creating a context filter for a crosstab report using a dimensional data source?

  A. it changes the measure values and the items in the rows and columns

  B. it is applied after aggregation and changes the rows and columns

  C. it changes the measure values and suppresses zeros

  D. it filters only the measure values, not the items in the rows and columns

  Correct Answer: C

• Question 43:

  To display HTML report output directly in the body of an emailed report, which of the following is required in the delivery options pane?

  A. Select "Attach the report" and leave the email body blank.

  B. Select "Save report".

  C. In the email body, choose "Display a report" and follow the dialog box instructions

  D. Select "Include a link to the report''

  Correct Answer: C

• Question 44:

  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

  Correct Answer: C

• Question 45:

  The default output Format for a report may be set on which of the following two items?

  A. Query

  B. Visualization

  C. Report

  D. Report Folder

  E. Report View

  Correct Answer: A

• Question 46:

  To change the text item in a list column title or the data in the column body of a list object in a report, what first needs to happen?

  A. Select the cell and change the data format.

  B. Click on the Lock Page Objects icon to unlock the report.

  C. Select one of the cells and from the menu click Select Columns Style or Select Columns body style.

  D. Select the cell and change the Box Type to None.

  Correct Answer: C

• Question 47:

  When Insights are turned on what are all of the generated outcomes, depending on the visualization selected ?

  A. Average, Predictive Strength, Fit Line, Meaningful Difference and most frequent values

  B. Average, Standard Deviation, Best Fit values

  C. Average, Max and Min values

  D. Top five and Bottom Five values

  Correct Answer: B

• Question 48:

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

  A. the ability to export the dashboard to Excel

  B. the ability to generate the HTML to create an iFrame and reference the dashboard

  C. the ability to export the dashboard directly to SharePoint.

  D. the ability to send a notification to a phone

  Correct Answer: D

• Question 49:

  Which of the following is true about integration with collaboration platforms?

  A. Integration with any collaboration platform can be used with report objects but not dashboard objects.

  B. Integration with IBM Connections is si

  C. A link to a report in "my content" can be shared to a team Slack channel if the integration is enabled.

  D. Integration with Slack is supported.

  Correct Answer: D

• Question 50:

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

  A. the statistical strength of the relationship between the data items

  B. the flow of information between categories, ie. money transfers between countries

  C. the cardinality of one data item when grouped by another, ie. thicker signifies more unique values

  D. the weighted average of each measure value compared with other measures

  Correct Answer: A

  https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_explor ations.doc/ca_explore_relationship_diagram.html