C2090-621 시험 - IBM실제시험문제와 답 - 104문항

Question No : 1

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

정답:
Explanation:
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 No : 2

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

정답:

Question No : 3

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

정답:

Question No : 4

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.

정답:

Question No : 5

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.

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

Question No : 6

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.

정답:

Question No : 7

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.

정답:

Question No : 8

A report author had created a single select value prompt using the prompt wizard. The end user now needs to select more than one value.
What should the report author do?

A.Set the Auto-submit property of the Prompt to ‘Yes’ and change the Multi-select property of the value prompt to ‘Yes’.
B.Set the Auto-Submit property of the Prompt to ‘Yes’ and change the parameterized filter associated with the prompt to the ‘in’ operator.
C.Change the Multi-select property of the value prompt to ‘Yes’ and change the parameterized filter associated with the prompt to the ‘>’ operator.
D.Change the Multi-select property of the value prompt to ‘Yes’ and change the parameterized filter associated with the prompt to the ‘in’ operator.

정답:
Explanation:
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_wrkdat_allow_users_select_multiple_values_prompt.html

Question No : 9

A company would like to implement their own corporate style across all reports using a single Report as a reference. A requirement is to display the year of the data selected in the report in the header.
The year is not being resolved correctly as shown below:

How can the problem with this report be resolved?

A.The component reference has to be overwritten with a new defined “My Header Title” inside the new report.
B.The component reference has to be overwritten with a new defined “MyYear Singleton” inside the new report.
C.A component reference cannot contain a Singleton. The “Corporate Layout Reference” report has to be changed.
D.A component reference cannot contain a Singleton. The reference cannot be used and the header has to be created manually.

정답:

Question No : 10

A report author has added a Button Bar control to an Active Report that allows users to view data for different regions. The report author now wants to make it possible for users to filter the report on multiple regions at once.
What should the report author do?

A.Use the Static version of the Button Bar control.
B.Use the Data-driven version of the Button Bar control.
C.Convert the Button Bar control to a Check Box Group control.
D.Convert the Button Bar control to a Radio Button Group control.

정답:

Question No : 11

An author wants to set a single value that will filter all other visualizations affected by its value.
Which visualization type should be used?

A.Summary
B.Tree map
C.Data player
D.Scatter plot

정답:

Question No : 12

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

정답:
Explanation:
Note that the analytic operations available depend on the data source you are using. Reference: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/ com.ibm.swg.ba.cognos.ug_cr_qstd.10.2.2.doc/t_create_a_custom_calculation.html

Question No : 13

A user is creating a join relationship in a Data module.
What benefit can be expected from setting a filter join?

A.The performance on the join could be improved.
B.The result set from the join would return less rows.
C.The result set from the join would return more rows.
D.The join relationship would work on multiple fields in each table.

정답:
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/ com.ibm.swg.ba.cognos.dyn_query.10.2.2.doc/t_dqm_join_opt.html

Question No : 14

A report author wants to create an Active Report with a chart that is dynamically rendered in the browser based on user selections.
How can this be accomplished?

A.A legacy chart with client side processing.
B.A legacy chart with server side processing.
C.A Virtualization with client side processing.
D.A Virtualization with server side processing.

정답:

Question No : 15

A report author needs to verify that the cardinality is set correctly in order to properly group a list report.
What is the correct setting?

A.1:1 cardinality from left to right
B.1:1 cardinality from right to left
C.1: n cardinality from left to right
D.1: n cardinality from right to left

정답:

IBM C2090-621 시험