Online Access Free C2090-621 Exam Questions

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.Repeater
• B.Session parameter
• C.Singleton
• D.Layout calculation

A report author has a requirement to create a data set from an available spreadsheet. Prior to uploading the data, the author needs to customize the data to show only the columns needed.
What option would be used?

• A.Select the columns that will be visible
• B.Manage external data
• C.Filter the columns
• D.Preview data

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 change the associated parameterized filter to use the 'in_range' operator.
• B.Set the prompt Auto-submit property to 'Yes' and set the prompt Range property to 'Yes'.
• C.Set the prompt Range property to 'Yes' and change the associated parameterized filter to use the 'in_range' operator.
• D.Use an interval prompt and set the Auto-submit property to 'Yes'.

A report author wants to display Revenue and Quantity by Product line in one chart and use a combination chart. A bar chart is used for revenue and a line chart for quantity. While the bar chart is clear and easy to understand, the lines are almost missing and are different to read.
What can be done to solve the problem?

• A.Use a conditional scale.
• B.Map Quantity to a y axis with a different scale.
• C.Multiply Quantity by 1000000 and set the scale to -6 to display.
• D.Build two charts next to each other.

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.Hide data values within the chart and make the bars larger.
• B.Add a linear trendline to the chart.
• C.Add a polynomial trendline to the chart.
• D.Create and insert graphics to highlight the data points.