IBM C2090-621 Online Practice Questions and Exam Preparation

IBM C2090-621 Online Questions & Answers

• Question 1:

  A report author needs to create filters in Cognos Analytics ?Reporting. What arte the three different types of filtering?

  A. Required, Optional and Disabled
  B. Detailed, Summary and Parameterized
  C. Custom based in data item, Combined and Advanced
  D. Before Auto-Aggregation, After Auto-Aggregation and with Scope
  C. Custom based in data item, Combined and Advanced

• Question 2:

  A report author has a requirement to create a data set from an available spreadsheet. Prior to uploading the data, the author needs to customize the data to show only the columns needed. What option would be used?

  A. Preview data
  B. Filter the columns
  C. Manage external data
  D. Select the columns that will be visible
  A. Preview data

• Question 3:

  Which Data source can be used when a report author wishes to create a Data module?

  A. a report
  B. a Data server
  C. an uploaded PDF file
  D. a Framework Manager package
  B. a Data server

  ---

  explanation:

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

• Question 4:

  A report author wants to show a value that is independent from the rest of the values in the report. For example, the total revenue value in the header of each page in a report. Which type of object should be used?

  A. Repeater
  B. Singleton
  C. Layout calculation
  D. Session parameter
  B. Singleton

• Question 5:

  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

  ---

  explanation:

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

• Question 6:

  A report author was asked to create a report that displays Order method data within a List with a guide pointing to each Order method. How can this be accomplished?

  A. By creating a grouped list by Order method.
  B. By creating data decks with lists filtering Order method.
  C. By creating page breaks based on a data item and defining a grouping structure for the page set.
  D. By adding a table of contents and a table of contents entry next to the order within the List.
  C. By creating page breaks based on a data item and defining a grouping structure for the page set.

• Question 7:

  An author wants to add a visualization to a Dashboard that will allow users to explore correlations between different measures. Which type of visualization should be used?

  A. Pie
  B. Heat
  C. Radial
  D. Scatter plot
  D. Scatter plot

  ---

  explanation:

  Reference: https://community.watsonanalytics.com/wp-content/uploads/2016/06/HowtoaddextensiblevisualizationtoCognosActiveReports-AllVisualizations.pdf

• Question 8:

  A report author is using the Quantity fact data item multiple times in a list report. The desired outcome is to prevent double counting and provide predictable results. From which location should the additional Quantity fact data be selected?

  A. Query tab
  B. Source tab
  C. Data Items tab
  D. Page explorer tab
  C. Data Items tab

• Question 9:

  Which file type can be uploaded in Cognos Analytics?

  A. Fixed width text file.
  B. Tab separated value text file.
  C. Colon separated value text file.
  D. Microsoft word document (.docx).
  C. Colon separated value text file.

  ---

  explanation:

  Reference: https://www-01.ibm.com/support/docview.wss?uid=swg21974196

• Question 10:

  A report author must provide a prompt on a report which will accept a start and end date from the user. The report should be filtered on the interval between the two dates. How can this be accomplished?

  A. Use an interval prompt and set the Auto-submit property to `Yes'.
  B. Set the prompt Auto-submit property to `Yes' and set the prompt Range property to `Yes'.
  C. Use an interval prompt and change the associated parameterized filter to use the `in_range' operator.
  D. Set the prompt Range property to `Yes' and change the associated parameterized filter to use the `in_range' operator.
  D. Set the prompt Range property to `Yes' and change the associated parameterized filter to use the `in_range' operator.

  ---

  explanation:

  Reference: https://it.toolbox.com/question/how-to-set-up-filter-between-start-and-end-dates-011112