IBM IBM Certifications C2090-621 Questions & Answers

• Question 71:

  A report author had created a single select value prompt using the prompt wizard. The end user now needs to select more than one value.

  What should the report author do?

  A. Set the Auto-submit property of the Prompt to `Yes' and change the Multi-select property of the value prompt to `Yes'.

  B. Set the Auto-Submit property of the Prompt to `Yes' and change the parameterized filter associated with the prompt to the `in' operator.

  C. Change the Multi-select property of the value prompt to `Yes' and change the parameterized filter associated with the prompt to the `>' operator.

  D. Change the Multi-select property of the value prompt to `Yes' and change the parameterized filter associated with the prompt to the `in' operator.

  Correct Answer: D

  Reference: https://www.ibm.com/support/knowledgecenter/SSRL5J_1.0.1/ com.ibm.swg.ba.cognos.ug_cr_rptstd.10.1.1.doc/ t_cr_rptstd_wrkdat_allow_users_select_multiple_values_prompt.html

• Question 72:

  A report author has added a Button Bar control to an Active Report that allows users to view data for different regions. The report author now wants to make it possible for users to filter the report on multiple regions at once.

  What should the report author do?

  A. Use the Static version of the Button Bar control.

  B. Use the Data-driven version of the Button Bar control.

  C. Convert the Button Bar control to a Check Box Group control.

  D. Convert the Button Bar control to a Radio Button Group control.

  Correct Answer: C

• Question 73:

  A company would like to implement their own corporate style across all reports using a single Report as a reference. A requirement is to display the year of the data selected in the report in the header. The year is not being resolved correctly as shown below: How can the problem with this report be resolved?

  

  A. The component reference has to be overwritten with a new defined "My Header Title" inside the new report.

  B. The component reference has to be overwritten with a new defined "MyYear Singleton" inside the new report.

  C. A component reference cannot contain a Singleton. The "Corporate Layout Reference" report has to be changed.

  D. A component reference cannot contain a Singleton. The reference cannot be used and the header has to be created manually.

  Correct Answer: B

• Question 74:

  A user is creating a join relationship in a Data module. What benefit can be expected from setting a filter join?

  A. The performance on the join could be improved.

  B. The result set from the join would return less rows.

  C. The result set from the join would return more rows.

  D. The join relationship would work on multiple fields in each table.

  Correct Answer: A

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/ com.ibm.swg.ba.cognos.dyn_query.10.2.2.doc/t_dqm_join_opt.html

• Question 75:

  A report author wants to add calculations that were created in the published package to a report.

  Where can this be done?

  A. Macro tab

  B. Source tab

  C. Functions tab

  D. Parameter tab

  Correct Answer: C

• Question 76:

  An author wants to set a single value that will filter all other visualizations affected by its value.

  Which visualization type should be used?

  A. Summary

  B. Tree map

  C. Data player

  D. Scatter plot

  Correct Answer: C

• Question 77:

  A report author needs to create an offline interactive report that can be filtered by clicking on a list of values. For example, by clicking on Region "A" the List will display only the details from Region "A".

  Which Reaction behavior should be selected?

  A. Enable a control.

  B. Filter an item in a control.

  C. Select an item in a control.

  D. Create a report expression and use it in filters.

  Correct Answer: A

• Question 78:

  A report author needs to verify that the cardinality is set correctly in order to properly group a list report. What is the correct setting?

  A. 1:1 cardinality from left to right

  B. 1:1 cardinality from right to left

  C. 1:n cardinality from left to right

  D. 1:n cardinality from right to left

  Correct Answer: C

• Question 79:

  A report author wants to create an Active Report with a chart that is dynamically rendered in the browser based on user selections.

  How can this be accomplished?

  A. A legacy chart with client side processing.

  B. A legacy chart with server side processing.

  C. A Virtualization with client side processing.

  D. A Virtualization with server side processing.

  Correct Answer: A

• Question 80:

  A report author has the following filter in a report:

  [Product line] in ?pline?

  The report author adds a Value prompt based on the existing parameter `pline'. After adding the prompt,

  the Auto-submit property is defaulted to `No' and cannot be changed to `Yes'. What is the cause of this?

  A. Default selections are missing in the Value prompt.

  B. The Value prompt created based on the filter is a Multi-select prompt.

  C. A prompt based on an existing parameter as Auto-submit cannot be made.

  D. Auto-submit is a property that is only available for select and search prompts.

  Correct Answer: A