Free C2090-621 sample questions

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?

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

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

A report author has created a report as shown below: What has been defined during the building of this report?

• List, Crosstab, Header, Microchart
• Section, Singleton, List, Chart, Crosstab
• Crosstab, Master detail relationship, Microchart, Section
• List, Crosstab, Master detail relationship, Section, Microchart

How can a report author ensure that a report changes automatically when rotating a mobile device between Landscape and Portrait views?

• Set all objects to Portrait views.
• Set all report objects to Portrait aware.
• Set the Mobile alignment property to Automatic.
• Size the object as a percentage of the available space.

A report author wants to reduce the number of columns in a list by moving the related information into a single column. What is the first action that needs to be performed?

• Insert a block into the column header.
• Right click the column header and unlock the cell.
• Modify the column header properties and unlock it.
• Click on the more button on the Application bar to unlock the report.

A report author needs the label in a List column title to be dynamic. How can this be implemented with a dynamic value?

• Pivot the List to a Crosstab.
• Create a Master detail relationship to the data.
• Unlock the report and insert a data item into the List column title.
• Select the List column title and change the Source type to Data item label.

A report developer is tasked to create a drill-through definition in a report. Which are the generalized steps?

• Create the target report> Add parameter to target report> Save the target report> Set drill-through behavior
• Set drill-through behavior on each report> Select the correct package> Map parameter values passed to target report> Define source report
• Create a drill-through definition that will allow users navigate from the targeted report to other created reports> Enable report variables for drill-through definitions> Save report
• Create the target report> Create a drill-through definition that will allow users navigate from the targeted report to other created reports> Enable the drill behavior in the source report

A report author requires two conditional styles to be both of which are used on a column. How can the order in which to evaluate the conditions be specified?

• Go to the “Manage Conditional Styles© menu and click the move up or more down arrow.
• The order cannot be defined. All conditions are evaluated and combined in an “AND” logic.
• By clicking a condition on a selected column and then clicking the move up or move down arrow.
• The order in which the conditions are evaluated depends on the order of the underlying query item inside the query.

A report needs to modify the Interactive Behavior within an Active Report. Which button can be used?

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?

• Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Save the report.
• Add a Crosstab data container to the report. Format and sort it appropriately. Delete the list data container and save the report.
• 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.
• 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.