Online Access Free C2090-621 Practice Test

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.Parameter tab
• C.Functions tab
• D.Source tab

A report author wants to show a value that is independent from the rest of the values in the report. For example, the total revenue value in the header of each page in a report.
Which type of object should be used?

• A.Singleton
• B.Session parameter
• C.Repeater
• D.Layout calculation

A report author is using the Quantity fact data item multiple times in a list report. The desired outcome is to prevent double counting and provide predictable results.
From which location should the additional Quantity fact data be selected?

• A.Data Items tab
• B.Page explorer tab
• C.Query tab
• D.Source tab

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. Add a page set that is grouped on sales manager. Save the report.
• B.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.
• C.Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Save the report.
• D.Add a Crosstab data container to the report. Format and sort it appropriately. Delete the list data container and save the report.

A report author must provide a prompt on a report which will accept a start and end date from the user. The report should be filtered on the interval between the two dates.
How can this be accomplished?

• A.Use an interval prompt and set the Auto-submit property to 'Yes'.
• B.Use an interval prompt and change the associated parameterized filter to use the 'in_range' operator.
• C.Set the prompt Auto-submit property to 'Yes' and set the prompt Range property to 'Yes'.
• D.Set the prompt Range property to 'Yes' and change the associated parameterized filter to use the 'in_range' operator.