IBM C2090-621 Online Practice Questions and Exam Preparation

IBM C2090-621 Online Questions & Answers

• Question 81:

  What should a report author do to use data from two tabs of an Excel file (.xlsx) together in a single object in a Dashboard?

  A. Upload each tab as one upload file and merge together within a data module.
  B. Upload each tab as separate upload files and merge together within a data module.
  C. Create separate Excel files for each tab, upload the files as one upload file and merge together within a data module.
  D. Create separate Excel files for each tab, upload the files as separate upload files and merge together within a data module.
  C. Create separate Excel files for each tab, upload the files as one upload file and merge together within a data module.

• Question 82:

  A company distributes a monthly email to the sales managers at the beginning of each month that shows how well they are doing using a tabular formatted report. The report is delivered in Excel format and the sales managers would like the report to be in a Crosstab format.

  How should the report be changed?

  A. Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Save the report.
  B. Add a Crosstab data container to the report. Format and sort it appropriately. Delete the list data container and save the report.
  C. Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Add a page set that is grouped on sales manager. Save the report.
  D. Add a repeater to the report. Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Place the Crosstab within the repeater. Create a Master detail relationship between the Crosstab and the repeater on sales manager. Save the report.
  A. Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Save the report.

• Question 83:

  How can a report author ensure that a report changes automatically when rotating a mobile device between Landscape and Portrait views?

  A. Set all objects to Portrait views.
  B. Set all report objects to Portrait aware.
  C. Set the Mobile alignment property to Automatic.
  D. Size the object as a percentage of the available space.
  D. Size the object as a percentage of the available space.

  ---

  Reference: https://www.ibm.com/developerworks/analytics/library/ba-pp-reporting-active_report-page672/ba-pp-reporting-active_report-page672-pdf.pdf (page 1 and 2)

• Question 84:

  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.
  B. Add Product Description as a list column and use the Render Variable property and a prompt to conditionally render the column.

• Question 85:

  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.
  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.

  ---

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

• Question 86:

  What can be done when using a SQL object when not using a stored procedure?

  A. Update a database.
  B. Insert rows into database.
  C. Delete rows in a database.
  D. Select rows from a database.
  A. Update a database.

• Question 87:

  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.

  ---

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

• Question 88:

  A report author has created a Dashboard visualization and needs to filter it on a data item that is not displayed. How can this be accomplished?

  A. Create a context filter.
  B. Create a data set filter.
  C. Modify the exclude value on the column property.
  D. Add the data item to the visualization and set its display property to hide.
  B. Create a data set filter.

• Question 89:

  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.
  C. The performance is optimized across all related query subjects with Pass Through SQL.

• Question 90:

  What happens when a report is run with full interactivity?

  A. Consumers cannot drill-through.
  B. Consumers can drill-down in Lists.
  C. Consumers are able to make changes to the report.
  D. Report consumers cannot save changes that are made.
  B. Consumers can drill-down in Lists.

  ---

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