IBM IBM Certifications C2090-621 Questions & Answers

• Question 31:

  The HR department has requested the report author to change the formatting of a report. The fact cells of the crosstab need to have a different font color.

  How can this be done?

  A. Click a row, click the select ancestor button in the title bar of the Properties pane and then click Crosstab fact sells.

  B. Click a fact cell, click the select ancestor button in the title bar of the Properties pane and then click Crosstab fact cells.

  C. Click a column, click the select ancestor button in the title bar of the Properties pane and then click Crosstab fact cells.

  D. Click a row, Ctrl-click a column, click the select ancestor button in the title bar of the Properties pane and then click Crosstab fact cells.

  Correct Answer: C

• Question 32:

  A report author would like to reuse a logo across all existing reports. Which object should be used?

  A. Template

  B. Bookmark

  C. Global Class

  D. Layout Component Reference

  Correct Answer: D

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/ com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/ t_cr_rptstd_frmat_rep_reuse_object.html#cr_rptstd_frmat_rep_reuse_object

• Question 33:

  A report author is considering which SQL syntax to use for accessing various Data sources.

  What is the advantage of using one type of SQL syntax above another?

  A. Cognos SQL can use non-standard SQL.

  B. Cognos SQL works on any supported database.

  C. The performance is optimized across all related query subjects with Pass Through SQL.

  D. With Pass Through SQL and Native SQL, the SQL may not work on a different database.

  Correct Answer: C

• Question 34:

  A report author wants to reduce the number of columns in a list by moving the related information into a single column.

  What is the first action that needs to be performed?

  A. Insert a block into the column header.

  B. Right click the column header and unlock the cell.

  C. Modify the column header properties and unlock it.

  D. Click on the more button on the Application bar to unlock the report.

  Correct Answer: B

• Question 35:

  A company has upgraded all of the models and packages to use Dynamic Query Mode (DQM). There is a report that must reference query subjects from two different packages.

  How can this be accomplished?

  A. The report author cannot create reports against multiple packages.

  B. The report author can add multiple packages as Data sources and write the report appropriately.

  C. The report author must use SQL nodes for all queries that reference the different query subjects and join them appropriately to get the desired results.

  D. The report author must use one SQL node of the queries and the package for the other query and join them appropriately to get the desired results.

  Correct Answer: B

• Question 36:

  A report author wants to create an Active report with a Static Deck/ Each card should show a Chart with differently-filtered data.

  What should the Chart for each card be based on?

  A. An item that is a property of the page.

  B. A query item that is a property of the Chart.

  C. A unique query with a filter applied to the query.

  D. Reuse the same query with a filter applied to the query.

  Correct Answer: B

• Question 37:

  A user needs to display information using multiple graphics on a single page that is scrollable.

  Which Dashboard template should be used?

  A. Tabbed

  B. Stacked

  C. Infographic

  D. Single page

  Correct Answer: C

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/ com.ibm.swg.ba.cognos.ug_ca_dshb.doc/wa_an_assembling_a_dashboard.html

• Question 38:

  A report needs to modify the Interactive Behavior within an Active Report.

  Which button can be used?

  A.

  B.

  C.

  D.

  

  Correct Answer: D

  Reference: https://www.ironsidegroup.com/wp-content/uploads/2012/04/ar-3.png

• Question 39:

  A report author wants to use a calculation which is not a string function to manipulate text. Which function can be used?

  A. trim()

  B. lower()

  C. extract()

  D. substring()

  Correct Answer: B

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/ com.ibm.swg.ba.cognos.ug.cogtr.doc/c_textfunctions_tr.html

• Question 40:

  An author wants to include new data in an existing Dashboard.

  Which type of Data source can be used?

  A. Pivot tables

  B. Data Modules

  C. Published packages

  D. Framework Manager models

  Correct Answer: B