IBM C2090-621 Online Practice Questions and Exam Preparation

IBM C2090-621 Online Questions & Answers

• Question 51:

  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.
  A. Objects have to be sized appropriately.

• Question 52:

  A company is using a model that was created in Compatible Query Mode (CQM). 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 that reference multiple Data sources.
  B. The report author can add multiple packages to the reports as Data sources and create the report as needed.
  C. The report author must use SQL nodes for all queries that reference the data items in the two packages and join them appropriately to get the desired results within the report.
  D. The report author can use user-defined SQL to develop the query from one of the packages and the other package to develop the other query and then join them appropriately to get the desired results within the report.
  D. The report author can use user-defined SQL to develop the query from one of the packages and the other package to develop the other query and then join them appropriately to get the desired results within the report.

• Question 53:

  A report author renders an Active Report as an TML file on the local computer.

  Where are the Charts Created?

  A. All Charts are rendered in the client.
  B. All Charts are rendered on the server.
  C. Non-prompted Charts are rendered in the client.
  D. Only prompted Charts are rendered on the server.
  A. All Charts are rendered in the client.

• Question 54:

  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.
  C. Map Quantity to a y axis with a different scale.

• Question 55:

  A report author is building an Active Report for disconnected mobile use only.

  Which technique can be used while ensuring the Active Report is fully offline capable?

  A. Creating a drill-through to a different PDF report.
  B. Setting a default value for a variable in the Active Report.
  C. Using an iFrame within the Active Report to another report.
  D. Adding a search and select prompt on a prompt page for the report consumer to filter the report on the iPad offline.
  B. Setting a default value for a variable in the Active Report.

• Question 56:

  A user wants to ensure that the visualizations in a tabbed Dashboard appear exactly as they were sized and placed, regardless of the screen size of the device that they are viewed in. Which template should be used?

  A. Canvas
  B. Freeform
  C. Infographic
  D. Single page
  B. Freeform

  ---

  Reference: https://www.ibm.com/support/knowledgecenter/en/SS4QC9/com.ibm.solutions.wa_an_overview.2.0.0.doc/wa_an_templates.html

• Question 57:

  An author wants to add a visualization to a Dashboard that emphasizes the magnitude of change in data over time. Which type of visualization should be used?

  A. Pie
  B. Area
  C. Tree map
  D. Word cloud
  B. Area

  ---

  Reference:http://cognosexp.blogspot.com/2015/07/rave-introduction-comparing-ibm-cognos.html (stacked area chart)

• Question 58:

  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
  C. Functions tab

• Question 59:

  A report author wants to create an Active Report with a Data deck that only prompts for Product line and Year. For each card created, the Order method type broken down by revenue should be shown. What needs to be done to ensure the data on each card reflects the correct year and Product line?

  A. Use a Repeater table in the Card deck.
  B. Each card should have a separate query.
  C. Filters should be copied from the Data deck to the cards.
  D. Use a Master detail relationship between the cards and the Data deck.
  D. Use a Master detail relationship between the cards and the Data deck.

• Question 60:

  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()
  B. lower()

  ---

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