IBM IBM Certifications C2090-621 Questions & Answers

• Question 41:

  Data Lineage is supported by which of the following?

  A. Reports based on packages.

  B. Only on reports based on Lists.

  C. Reports based on Data modules.

  D. Only data items defined in a Master data glossary.

  Correct Answer: A

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

• Question 42:

  A report author is asked to create a list report and add data by loading it in Cognos Analytics ?Reporting.

  Which option can be loaded?

  A. Packages or Data Modules

  B. Packages and Data Models

  C. Query Modules and data Items

  D. Dynamic Query Mode or Compatible Query Mode

  Correct Answer: A

  Explanation: Add data to a report by loading packages or data modules in IBM Cognos Analytics Reporting.

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/

  com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/c_cr_rptstd_intrd_creating_a_report.html

• Question 43:

  A report author would like to create multiple variable connections in a report that contains one control and two Lists in order to compare data.

  Which statement is true?

  A. It is not possible to create two connections unless there are two different controls and two Lists.

  B. The report author should be able to create two connections only if the values have the same data type.

  C. The report author should be able to create one or more connections but the variable's Behavior should be the same.

  D. The report author should be able to create multiple connections on one control by creating new connections, both variables can also show different Behavior.

  Correct Answer: D

• Question 44:

  Which statement is true about adding columns from the source package after modifying a query?

  A. Columns cannot be added from the source package to a report after adding an SQL object.

  B. Columns can be added from the source package to a report after modifying an SQL object.

  C. Columns cannot be added from the source package to a report after deleting an SQL object.

  D. Columns can be added from the source package to a report only before adding an SQL object.

  Correct Answer: B

• Question 45:

  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.

  Correct Answer: B

• Question 46:

  A company has a Product Returns report. The Return Comments query item is present in the list query but was left out of the list due to space constraints on the report page. The users have asked to see this information interactively.

  How could the report author add this functionality with only minimal changes to the existing report?

  A. Add HTML Items to the Product Name cell that use Report Expression to assign [Return comments] to HTML span title.

  B. Add Product Description as a list column and use the Render Variable property and a prompt to conditionally render the column.

  C. Add a Drill-through definition to the Product name cell and set the Target to Label and Data Item to the [Return comments] query item.

  D. Insert a master-detail single row microchart to the Product column cell with transparency on and chart Tooltips property set to Absolute.

  Correct Answer: B

• Question 47:

  A report author wants to ensure a complete mobile experience on an iPad tablet by enabling swipe gesturing between pages of a Data deck.

  What must be done to achieve this?

  A. Connect an Iterator to a Deck with a variable. Set the slide animation direction of the Deck to a direction. Change the property of the Iterator label Area to Page Dots.

  B. Connect a Button bar to a Deck with a variable. Set the slide animation direction of the Deck to a direction. Change the property of the Iterator label Area to Page Dots.

  C. Connect an Iterator to a Deck with a variable. Set the slide animation direction of the Deck to a direction. Change the property of the Iterator label Area to Iterator Number.

  D. Connect a Button bar a Deck with a variable. Set the slide animation direction of the Deck to a direction. Change the property of the Iterator label Area to iterator Number.

  Correct Answer: C

  Reference: https://www.ibm.com/blogs/ba-support-link/wp-content/uploads/2016/05/october-2013-ipad.pdf (page 6)

• Question 48:

  A report author created the following list report and wants to filter all order methods which generated total revenue less than one billion.

  

  Which filter should be used?

  A. A detail filter as [Revenue] >= 100000000 with application set to before auto aggregation.

  B. A detail filter as [Revenue] >= 100000000 with application set to after auto aggregation.

  C. A detail filter for Total([Revenue]) >= 100000000 with application set to before auto aggregation.

  D. A detail filter for Total([Revenue]) >= 100000000 with application set to after auto aggregation.

  Correct Answer: D

• Question 49:

  What does a developer need to know in order to expose Cognos Analytics Dashboards for mobile consumption?

  A. Objects have to be sized appropriately.

  B. Only Active Reports can be viewed on a mobile device.

  C. The interface is not consistent between the desktop and mobile.

  D. The Cognos Mobile App is the only method for accessing a Dashboard.

  Correct Answer: A

• Question 50:

  A report author wants to display Revenue and Quantity by Product line in one chart and use a combination chart. A bar chart is used for revenue and a line chart for quantity. While the bar chart is clear and easy to understand, the lines are almost missing and are different to read.

  What can be done to solve the problem?

  A. Use a conditional scale.

  B. Build two charts next to each other.

  C. Map Quantity to a y axis with a different scale.

  D. Multiply Quantity by 1000000 and set the scale to -6 to display.

  Correct Answer: C