IBM IBM Certifications C2090-621 Questions & Answers

• Question 61:

  An author has created a dashboard and added a filter. The author anticipated this filter to be applied to all visualizations on the dashboard but it was only on some of them.

  Why did this happen?

  A. The local filter sync was not enabled.

  B. The global filters property was disabled.

  C. The filter was not created as a data set filter.

  D. The filter was not applied to the default visualization.

  Correct Answer: C

  Reference: https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/ com.ibm.swg.ba.cognos.ug_ca_dshb.doc/wa_an_interactive_filtering.html

• Question 62:

  A report author has run a report and found issues with the variables that resulted from Active Report connections, and the variables need to be reset.

  How can this be done?

  A. Right click the report> Reset variables

  B. Click File> Report Properties> Variables> Reset variables

  C. Right click the report> More options> Set variable values> Reset variables

  D. Select report> Click on More options> Set variable values > Reset variables

  Correct Answer: A

• Question 63:

  A report author has to create a Crosstab report with Region and Product data in the rows of the Crosstab. The Crosstab can be created in two different ways as shown below.

  

  Which Crosstab/Crosstabs is/are discontinuous Crosstab/Crosstabs?

  A. Crosstab A

  B. Crosstab B

  C. Crosstab A and Crosstab B

  D. neither Crosstab A nor Crosstab B

  Correct Answer: A

  Reference: https://www.ibm.com/support/knowledgecenter/SSRL5J_1.0.1/ com.ibm.swg.ba.cognos.ug_cr_rptstd.10.1.1.doc/t_cr_rptstd_reptyp_discontinuous_crosstab.html

• Question 64:

  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.

  Correct Answer: D

• Question 65:

  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.

  Correct Answer: A

• Question 66:

  Which Data source can a report author connect to directly when creating a Dashboard?

  A. a report

  B. a Data set

  C. a relational Data source

  D. a locally saved Excel file

  Correct Answer: B

• Question 67:

  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

  Correct Answer: D

• Question 68:

  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.

  Correct Answer: D

• Question 69:

  A report author has been asked to create a report that needs to be distributed in PDF format. The report has to let users navigate quickly to a desired report page and information within the report.

  How can this be accomplished?

  A. Using a Hyperlink button.

  B. Creating an Active Report.

  C. Using a layout component reference.

  D. Using drill-through definitions and bookmarks for navigation.

  Correct Answer: D

  Reference: https://www.ibm.com/developerworks/data/library/cognos/reporting/active_report/page593.html

• Question 70:

  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.

  Correct Answer: B