C2090-621: IBM Cognos Analytics Author V11 - Free download from ExamHUB

A report author wants to enhance a report by having the ability to display the data by region and filter by Order method (where Order method includes: Email, Fax, Post, Sales rep, Promo, Phone, Web site).

How can this be accomplished?

Select On-demand toolbar > Select checkbox group > Add default values
Select Button Bar control > Go to properties > Change User interface to checkbox
Create a parameterized filter from the order_method > Manually populate the parameterized
Select the Button Bar control > From the on-demand toolbar > Click the ellipsis > Point to convert control > Click check box group

Correct answer: A

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

What should be done first?

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

Correct answer: D

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

Which mode allows this task?

Run
View
Priority
Review

Correct answer: B

A report author has applied one style in specific cells, and another style for the overall report.

Which style will be applied?

The style on the specific cell is applied.
The style on the overall report is applied.
The last style in the Conditional styles property is applied.
The first style in the Conditional styles property is applied.

Correct answer: C

Explanation:

Reference: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_8.4.0/com.ibm.swg.im.cognos.ug_rptstd_fin.8.4.0.doc/ug_rptstd_fin_id3759cr_rptstd_modrep_highlight_data_con.html

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?

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

Correct answer: C

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?

Select “+” from the Operator drop down list.
Select “=” from the Operator drop down list.
Select “in” from the Operator drop down list.
Select “>=” from the Operator drop down list.

Correct answer: B

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?

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

Correct answer: C

Explanation:

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

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?

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

Correct answer: C

Which statement is true when a report author wants to optimize reports for mobile users?

Set objects to a fixed size.
Use margins between report objects.
Size objects as a percentage of the available space.
Use percentage sizes greater than one hundred percent (100%).

Correct answer: C

An author wants to include a corporate graphic in the Dashboard.

Which image format is supported?

SVG
BMP
TIFF
JPEG

Correct answer: D

Explanation:

Reference: http://www.wou.edu/datawarehouse/files/2016/06/IBM_Cognos_Workspace_Advanced_User_Guide.pdf (page 155)

Vendor:	IBM
Exam Code:	C2090-621
Exam Name:	IBM Cognos Analytics Author V11
Date:	Dec 04, 2018
File Size:	507 KB

Download IBM Cognos Analytics Author V11.C2090-621.PassCertification.2018-12-04.35q.vcex

How to open VCEX files?

Demo Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

ProfExam at a 20% markdown