IBM C2090-621 Online Practice Questions and Exam Preparation

IBM C2090-621 Online Questions & Answers

• Question 61:

  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
  C. 1:n cardinality from left to right

• Question 62:

  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.
  A. Using a Data deck.

• Question 63:

  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.
  A. The performance on the join could be improved.

  ---

  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 64:

  When using a SQL object, what is the property SQL syntax by default?

  A. Native
  B. IBM Cognos
  C. Limited Local
  D. Pass-Through
  A. Native

  ---

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

• Question 65:

  A report author is asked to create a page break on a List.

  What are the initial steps to be taken?

  A. Click on Navigate> Click Report Pages> Add Page set> Associate the data item to the page.
  B. Select report> Click on properties> Select Report tab> Report options> Add page break> Associate the data item to the page.
  C. In the properties pane, under Data click Pages set> From the data items pane, drag the data item page break is based on.
  D. Click on Navigate> Click Report Pages> From Toolbox, and Page set to the Report pages pane> In properties pane, under DATA point the preferred query to the query list.
  B. Select report> Click on properties> Select Report tab> Report options> Add page break> Associate the data item to the page.

• Question 66:

  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 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.
  B. Contain the Charts in two cells of the same table, with a fixed size.

• Question 67:

  A report author has applied one style in specific cells, and another style for the overall report. Which style will be applied?

  A. The style on the specific cell is applied.
  B. The style on the overall report is applied.
  C. The last style in the Conditional styles property is applied.
  D. The first style in the Conditional styles property is applied.
  C. The last style in the Conditional styles property is applied.

  ---

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_8.4.0/com.ibm.swg.im.cognos.ug_rptstd_fin.8.4.0.doc/ug_rptstd_fin_id3759cr_rptstd_modrep_highlight_data_con.html

• Question 68:

  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
  D. Tree map

  ---

  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 69:

  A report author has run a report and found issues with the variables that resulted from Active Report connections, and the variables need to be reset. How can this be done?

  A. Right click the report> Reset variables
  B. Click File> Report Properties> Variables> Reset variables
  C. Right click the report> More options> Set variable values> Reset variables
  D. Select report> Click on More options> Set variable values > Reset variables
  A. Right click the report> Reset variables

• Question 70:

  A report author has been asked to create a list report with multiple facts from across the business. The desired outcome must ensure correlated and predictable results. Which item must be included in the list report?

  A. Repeater table
  B. Conditional fact
  C. Model Query subject
  D. Conformed dimension
  C. Model Query subject