Free C2090-621 Exam Dumps PDF Preview

Question 1

Single choice

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

Reveal answer details Close answer details

Correct answerD

Explanation

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

Question 2

Single choice

A company's marketing report tracks performance of various advertising campaigns. All of the advertising media files are stored on an internal file server and can be accessed directly in the URI form file://adserver/ adnnnnnn.mov (where nnnnnn is the same advertisement ID that's used in the marketing performance report).

How can the report author provide users with a clickable download link for the media file in the report performance list?

A
Add a Layout Calculation to the list as a new column with expression definition `file://adserver/ad' +
[PerformanceQuery].[AdID] + `.mov'.
B
Add a pair of HTML Items to the Ad Name list cell, using a Report Expression that includes `file://
adserver/ad' + [PerformanceQuery].[AdID] + `.mov'.
C
Add a Drill-through definition to the Ad Name list cell, using a Bookmark target with Report Expression
of: `file://adserver/ad' + [PerformanceQuery].[AdID] + `.mov'.
D
Insert an Image object into the Ad Name list cell, with URL Source Type set to Report Expression and
using expression: `file://adserver/ad' + [PerformanceQuery].[AdID] + `.mov'.

Reveal answer details Close answer details

Correct answerD

Question 3

Single choice

A report author would like to create multiple variable connections in a report that contains one control and two Lists in order to compare data.

Which statement is true?

A
It is not possible to create two connections unless there are two different controls and two Lists.
B
The report author should be able to create two connections only if the values have the same data type.
C
The report author should be able to create one or more connections but the variable's Behavior should be the same.
D
The report author should be able to create multiple connections on one control by creating new connections, both variables can also show different Behavior.

Reveal answer details Close answer details

Correct answerD

Question 4

Single choice

A report author is asked to create a list report and add data by loading it in Cognos Analytics ?Reporting.

Which option can be loaded?

A
Packages or Data Modules
B
Packages and Data Models
C
Query Modules and data Items
D
Dynamic Query Mode or Compatible Query Mode

Reveal answer details Close answer details

Correct answerA

Explanation

Explanation: Add data to a report by loading packages or data modules in IBM Cognos Analytics -
Reporting.
References:
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/c_cr_rptstd_intrd_creating_a_report.html

Question 5

Single choice

A report author has created this join relationship:

The Order number by product query includes only orders that contain a specific product selected at run time.

What must the report author do to ensure that the joined query will only contain Order numbers that appear in both of the queries?

A
Select "+" from the Operator drop down list.
B
Select "=" from the Operator drop down list.
C
Select "in" from the Operator drop down list.
D
Select ">=" from the Operator drop down list.

Reveal answer details Close answer details

Correct answerB

Question 6

Single choice

A report needs to modify the Interactive Behavior within an Active Report.

Which button can be used?

A
B
C
D

Reveal answer details Close answer details

Correct answerD

Explanation

References:
https://www.ironsidegroup.com/wp-content/uploads/2012/04/ar-3.png

Question 7

Single choice

A report author wants to conditionally format data depending on a parameter value a user specifies at run time.

How can this be done?

A
By applying parameters directly in a variable.
B
By using an HTML item to implement the parameter.
C
By referencing a query item that uses the parameter.
D
By applying the parameter in the color and background section of the properties.

Reveal answer details Close answer details

Correct answerA

Question 8

Single choice

A report author is going to develop a report and wants to ensure that the layout if defined correctly.

What should be done first?

A
Modify the global class definitions for the specific objects.
B
Select the objects that require changes and modify the properties.
C
Add a table to control the position of each object on the report page layout.
D
Choose the proper template and theme before starting the report development.

Reveal answer details Close answer details

Correct answerD

Question 9

Single choice

A report author creates the following filter in a report:

[Region] in (`Americas','Asia Pacific')

Which type of filter was created?

A
Advanced
B
Combined
C
Parameterized
D
Custom based on data item

Reveal answer details Close answer details

Correct answerD

Question 10

Single choice

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.

Reveal answer details Close answer details

Correct answerA

Question 11

Single choice

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.

Reveal answer details Close answer details

Correct answerC

Explanation

References:
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 12

Single choice

The sales department has requested the report author to build a report which combines a list with a chart.
The list must contain product lines and the chart should show details for each product line. The report author decided to use a Master detail relationship to build this report.

Which statement about Master detail relationships is true?

A
Calculations across Master detail queries can be performed.
B
Parent data in the child frame or child data in the parent frame can be displayed.
C
Master detail relationships must appear in nested frames to produce the correct results.
D
When working with an SAP BW Data source, a data item from the master query that contains non-ASCII values can be used.

Reveal answer details Close answer details

Correct answerC

Explanation

References:
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_cr_rptstd_modrep_create_master_detail_relationship_rel.html

Question 13

Single choice

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

Reveal answer details Close answer details

Correct answerA

Explanation

References:
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 14

Single choice

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.

Reveal answer details Close answer details

Correct answerD

Explanation

References:
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 15

Single choice

A customer has a bar chart in a report that displays a steady increase in revenue by product line over time.
The requirement is to graphically illustrate this progression in the data series without significantly the report.

How can this be done?

A
Add a linear trendline to the chart.
B
Add a polynomial trendline to the chart.
C
Create and insert graphics to highlight the data points.
D
Hide data values within the chart and make the bars larger.

Reveal answer details Close answer details

Correct answerC

Question 16

Single choice

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.

Reveal answer details Close answer details

Correct answerD

Free C2090-621 Exam Dumps Preview

IBM Cognos Analytics Author V11

PREVIEW CONTENTS · 1 VOLUME

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11

QUESTION 12

QUESTION 13

QUESTION 14

QUESTION 15

QUESTION 16