Free IBM C2090-621 Exam Dumps Questions & Answers

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 layout component reference.
• B.Using a Hyperlink button.
• C.Using drill-through definitions and bookmarks for navigation.
• D.Creating an Active Report.

A report author has created a Dashboard visualization and needs to filter it on a data item that is not displayed.
How can this be accomplished?

• A.Create a data set filter.
• B.Add the data item to the visualization and set its display property to hide.
• C.Create a context filter.
• D.Modify the exclude value on the column property.

The sales department has requested a change to a tabular account report and wants to be able to analyze the monthly amount of each Account name by Year. The report author changed the original report on left to the report on the right.


How was this done?

• A.Select Account name column and then use the toolbar button Pivot List To Crosstab.
• B.Select Amount(month) column and then use the toolbar button Convert to Crosstab.
• C.Select Year column and then use the toolbar button Convert to Crosstab.
• D.Select Year column and then use the toolbar button Pivot List Crosstab.

An author wants to add a visualization to a Dashboard that emphasizes the magnitude of change in data over time.
Which type of visualization should be used?

• A.Area
• B.Tree map
• C.Pie
• D.Word cloud

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.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.
• 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. Save the report.
• D.Use the convert list to Crosstab option. Format and soft the Crosstab appropriately. Add a page set that is grouped on sales manager.