IBM IBM Certifications C2090-621 Questions & Answers

• Question 11:

  A report author is building a report intended for an iPad on the Cognos Mobile App. The report consists of two Charts that need to be side by side when the tablet is landscape and on top of each other when the tablet is portrait.

  What technique should be used to accomplish this?

  A. Make the size of both Charts a percentage of the page width.

  B. Contain the Charts in two cells of the same table, with a fixed size.

  C. Contain both charts in separate blocks, with fixed widths and box type set as inline

  D. Use a conditional style on one of the Charts to adjust its position based on the orientation of the iPad.

  Correct Answer: B

• Question 12:

  A report author wants to filter a report on two data items, and has decided to use a combined filter rather than two custom filters.

  Why has the report author decided to use a combined filter?

  A. A report author should always use advanced filters instead of combined filters.

  B. Using two custom filters and one combined filter is exactly the same and either one can be used.

  C. A combined filter would allow to combine the values of two data items and then filter on the combined values.

  D. A combined filter will allow the use of two custom filters joined by either `AND', `OR', or `NOT' operators in between.

  Correct Answer: C

• Question 13:

  The user of a Dashboard needs a visualization using three categories and one value.

  Which visualization should be used?

  A. Grid

  B. Heat

  C. Point

  D. Tree map

  Correct Answer: D

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/ com.ibm.swg.ba.cognos.pa_trial.2.0.0.doc/c_visualizations_in_paw.html

• Question 14:

  A report author needs to create an Active Report and consider how connections, variables and interactive behaviors using data controls will be handled in the template.

  How will these be handled?

  A. Connections cannot be removed from templates.

  B. Only connections can be removed or added from templates.

  C. Connections, variables and interactive using data controls will be removed from the template.

  D. Connections, variables and interactive using data controls cannot be removed from the template.

  Correct Answer: A

• Question 15:

  A customer wants to report the product types with the largest average revenue. In addition, the total revenue should be shown and all product types with revenue less than three percent (>3%) in a single bar.

  Targeting this result: How can this be done?

  

  A. Using a visualization, because it is not possible in the default chart engine.

  B. Using the property "summarize small items" on the chart, the type total and setting the item label. Set the order on the default measure.

  C. Using the property "summarize small items" on the chart, the type average and setting the item label. Set the order on the chart node member.

  D. Writing a new query where you summarize the Product types and create a new "My small value" item based on the calculated average. Order the values in the query.

  Correct Answer: B

• Question 16:

  A report author is building an Active Report for mobile use on an iPad. The report contains a list object. The report author wants to ensure the entire list has a consistent size so that it does not affect the report layout.

  Which techniques should be used to ensure this? (Choose two.)

  A. Specify the exact width for all columns in the list.

  B. Specify the exact width for only the measure columns in the list.

  C. Surround the list in a defined size block with "Content is not clipped".

  D. Limit the number of rows returned with the use of a style variable on the list.

  E. Surround the list in a defined size block with the "Use scrollbars only when necessary" property chosen.

  Correct Answer: BD

• Question 17:

  A report author is asked to create a list report with alternating colored rows as shown here: How can this be done?

  

  A. By applying a Theme.

  B. By using the toolbox item Alternating list.

  C. By setting the property in the COLOR and BACKGROUND section of the list.

  D. By using an expression to control the conditional formatting of alternating rows.

  Correct Answer: D

  Reference: https://www.ironsidegroup.com/2012/12/04/highlighting-every-other-row-in-a-report-using-ibmcognos-workspace-advanced-with-a-twist/

• Question 18:

  A report author wants to generate an Active Report with a Chart, and allow the user to highlight a column within the Chart when a radio button is selected.

  

  How should the report be created?

  A. Using a Data deck.

  B. Apply a client side filter.

  C. Setting the Dynamic Chart property.

  D. Setting the local processing property.

  Correct Answer: A

• Question 19:

  A report author needs the label in a List column title to be dynamic.

  How can this be implemented with a dynamic value?

  A. Pivot the List to a Crosstab.

  B. Create a Master detail relationship to the data.

  C. Unlock the report and insert a data item into the List column title.

  D. Select the List column title and change the Source type to Data item label.

  Correct Answer: D

• Question 20:

  Which properties must be set when using a SQL object?

  A. Data source and SQL

  B. Package name and SQL

  C. Cardinality and namespace

  D. Primary Key and namespace

  Correct Answer: A