IBM C2090-621 Online Practice Questions and Exam Preparation

IBM C2090-621 Online Questions & Answers

• Question 1:

  A customer wants to report the product types with the largest average revenue. In addition, the total revenue should be shown and all product types with revenue less than three percent (>3%) in a single bar. Targeting this result:

  

  How can this be done?

  A. Using a visualization, because it is not possible in the default chart engine.
  B. Using the property "summarize small items" on the chart, the type total and setting the item label. Set the order on the default measure.
  C. Using the property "summarize small items" on the chart, the type average and setting the item label. Set the order on the chart node member.
  D. Writing a new query where you summarize the Product types and create a new "My small value" item based on the calculated average. Order the values in the query.
  B. Using the property "summarize small items" on the chart, the type total and setting the item label. Set the order on the default measure.

• Question 2:

  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.
  A. Reports based on packages.

  ---

  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 3:

  A business manager wants to set the current Dashboard as the home page.

  Which mode allows this task?

  A. Run
  B. View
  C. Priority
  D. Review
  B. View

• Question 4:

  A report author needs the label in a List column title to be dynamic.

  How can this be implemented with a dynamic value?

  A. Pivot the List to a Crosstab.
  B. Create a Master detail relationship to the data.
  C. Unlock the report and insert a data item into the List column title.
  D. Select the List column title and change the Source type to Data item label.
  D. Select the List column title and change the Source type to Data item label.

• Question 5:

  Which option is true when a report author is designing report for mobile users?

  A. Use fixed size objects.
  B. Set all objects to Portrait view.
  C. Set margins between objects in the report.
  D. Size the objects as a percentage of the available.
  D. Size the objects as a percentage of the available.

• Question 6:

  A report author has applied a Union set operation on two queries with the resultant query named Main_Query containing the data items: Product line, Order method/Region, Revenue and Unit Sale Price. The report author added the data items to the list, grouped on Product line and Order method/Region. The screenshot below shows the result:

  

  What must the report author do for the report to look like the following?

  

  A. Set the detail aggregation property to Automatic for each field.
  B. Set the detail aggregation property to None for product line and order method. Total for Revenue. Average for Unit Sale Price.
  C. Set the detail aggregation property to None for only Product Line and Order Method. Automatic for Revenue. Average for Unit Sale Price.
  D. Set the detail aggregation property to Default for product line and Order method. Default for Revenue and Average for Unit Sale Price.
  C. Set the detail aggregation property to None for only Product Line and Order Method. Automatic for Revenue. Average for Unit Sale Price.

• Question 7:

  A report developer is tasked to create a drill-through definition in a report. Which are the generalized steps?

  A. Create the target report> Add parameter to target report> Save the target report> Set drill-through behavior
  B. Set drill-through behavior on each report> Select the correct package> Map parameter values passed to target report> Define source report
  C. Create a drill-through definition that will allow users navigate from the targeted report to other created reports> Enable report variables for drill-through definitions> Save report
  D. Create the target report> Create a drill-through definition that will allow users navigate from the targeted report to other created reports> Enable the drill behavior in the source report
  D. Create the target report> Create a drill-through definition that will allow users navigate from the targeted report to other created reports> Enable the drill behavior in the source report

• Question 8:

  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.
  D. A detail filter for Total([Revenue]) >= 100000000 with application set to after auto aggregation.

• Question 9:

  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.
  B. A query item that is a property of the Chart.

• Question 10:

  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.
  B. Right click the column header and unlock the cell.