C2090-621 sample questions

Question 1

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

Accepted Answer

Select the List column title and change the Source type to Data item label.

Answer

Pivot the List to a Crosstab.

Answer

Create a Master detail relationship to the data.

Answer

Unlock the report and insert a data item into the List column title.

Question 2

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

Accepted Answer

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

Answer

Create the target report> Add parameter to target report> Save the target report> Set drill-through behavior

Answer

Set drill-through behavior on each report> Select the correct package> Map parameter values passed to target report> Define source report

Answer

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

Question 3

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?

Accepted Answer

The order cannot be defined. All conditions are evaluated and combined in an “AND” logic.

Answer

Go to the “Manage Conditional Styles© menu and click the move up or more down arrow.

Answer

By clicking a condition on a selected column and then clicking the move up or move down arrow.

Answer

The order in which the conditions are evaluated depends on the order of the underlying query item inside the query.

Question 4

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?

Accepted Answer

Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Save the report.

Answer

Add a Crosstab data container to the report. Format and sort it appropriately. Delete the list data container and save the report.

Answer

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.

Answer

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.

Question 5

The sales department has requested the report author to build a report which combines a list with a chart. The list must contain product lines and the chart should show details for each product line. The report author decided to use a Master detail relationship to build this report.

Which statement about Master detail relationships is true?

Accepted Answer

Master detail relationships must appear in nested frames to produce the correct results.

Answer

Calculations across Master detail queries can be performed.

Answer

Parent data in the child frame or child data in the parent frame can be displayed.

Answer

When working with an SAP BW Data source, a data item from the master query that contains non-ASCII values can be used.

Question 6

An author has finished working on a Dashboard and wants to make it available to other authors. Where should the Dashboard be located?

Accepted Answer

Team content folder

Answer

My content folder

Answer

Administration console, Mobile tab

Answer

Administration console, Library tab

Question 7

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?

Accepted Answer

Create a data set filter.

Answer

Create a context filter.

Answer

Modify the exclude value on the column property.

Answer

Add the data item to the visualization and set its display property to hide.

Question 8

A report author is building an Active Report for disconnected mobile use only. Which technique can be used while ensuring the Active Report is fully offline capable?

Accepted Answer

Setting a default value for a variable in the Active Report.

Answer

Creating a drill-through to a different PDF report.

Answer

Using an iFrame within the Active Report to another report.

Answer

Adding a search and select prompt on a prompt page for the report consumer to filter the report on the iPad offline.

Question 9

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?

Accepted Answer

Preview data

Answer

Filter the columns

Answer

Manage external data

Answer

Select the columns that will be visible

C2090-621 Sample Questions & Answers

Free C2090-621 Sample Questions with Answers

Ready for the real thing?