IBM C2090-621 Exam Questions

Question 6 of 105

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

Before starting report development, it is crucial to choose the proper template and theme. This ensures that the layout, style, and overall design of the report are consistent and align with the desired visual standards. Templates and themes provide a foundation that simplifies and streamlines the subsequent steps in report creation, such as defining object positions and modifying properties.

Question 7 of 105

A business manager wants to set the current Dashboard as the home page.
Which mode allows this task?

Run

View

Priority

Review

Correct Answer: A

The mode required to set the current Dashboard as the home page is typically termed 'Run.' This mode allows users to execute certain tasks and make modifications to settings such as setting the home page. Other options like 'View,' 'Priority,' and 'Review' do not generally correspond to the functionality of setting a home page.

Question 8 of 105

An Active Report contains a data deck with the following values on multi select controls:
Exam C2090-621: Question 8 - Image 1

How many cards would be generated?

Correct Answer: D

Question 9 of 105

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

When multiple styles are applied in a report, the style applied to the specific cells takes precedence over the style applied to the entire report. This is because specific styles generally have a higher priority than general styles, ensuring that the particular appearance settings for those cells are retained.

Question 10 of 105

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:
Exam C2090-621: Question 10 - Image 1

What must the report author do for the report to look like the following?
Exam C2090-621: Question 10 - Image 2

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

To achieve the desired report format, the report author must set the detail aggregation properties appropriately. Specifically, setting the aggregation property to None for the Product Line and Order Method prevents them from being aggregated. Setting the aggregation to Total for Revenue ensures that the values are summed up correctly. Lastly, setting the aggregation to Average for Unit Sale Price provides the expected average values. This adjustment will give the report a detailed aggregation of Revenue totals and an average Unit Sale Price for each Order Method/Region within the Product Line.