C2090-621 Online Practice Questions and Answers

A report author has applied one style in specific cells, and another style for the overall report.

Which style will be applied?

A. The style on the specific cell is applied.

B. The style on the overall report is applied.

C. The last style in the Conditional styles property is applied.

D. The first style in the Conditional styles property is applied.

A company's marketing report tracks performance of various advertising campaigns. All of the advertising media files are stored on an internal file server and can be accessed directly in the URI form file://adserver/ adnnnnnn.mov (where nnnnnn is the same advertisement ID that's used in the marketing performance report).

How can the report author provide users with a clickable download link for the media file in the report performance list?

A. Add a Layout Calculation to the list as a new column with expression definition `file://adserver/ad' + [PerformanceQuery].[AdID] + `.mov'.

B. Add a pair of HTML Items to the Ad Name list cell, using a Report Expression that includes `file:// adserver/ad' + [PerformanceQuery].[AdID] + `.mov'.

C. Add a Drill-through definition to the Ad Name list cell, using a Bookmark target with Report Expression of: `file://adserver/ad' + [PerformanceQuery].[AdID] + `.mov'.

D. Insert an Image object into the Ad Name list cell, with URL Source Type set to Report Expression and using expression: `file://adserver/ad' + [PerformanceQuery].[AdID] + `.mov'.

An author wants to set a single value that will filter all other visualizations affected by its value.

Which visualization type should be used?

A. Summary

B. Tree map

C. Data player

D. Scatter plot

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?

A. Creating a drill-through to a different PDF report.

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

C. Using an iFrame within the Active Report to another report.

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

A company has upgraded all of the models and packages to use Dynamic Query Mode (DQM). There is a report that must reference query subjects from two different packages.

How can this be accomplished?

A. The report author cannot create reports against multiple packages.

B. The report author can add multiple packages as Data sources and write the report appropriately.

C. The report author must use SQL nodes for all queries that reference the different query subjects and join them appropriately to get the desired results.

D. The report author must use one SQL node of the queries and the package for the other query and join them appropriately to get the desired results.

A report author wants to use a calculation which is not a string function to manipulate text. Which function can be used?

A. trim()

B. lower()

C. extract()

D. substring()

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. 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 soft the Crosstab appropriately. Add a page set that is grouped on sales manager.

D. 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.

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. Set the prompt Auto-submit property to `Yes' and set the prompt Range property to `Yes'.

C. Use an interval prompt and change the associated parameterized filter to use the `in_range' operator.

D. Set the prompt Range property to `Yes' and change the associated parameterized filter to use the `in_range' operator.

An author wants to add a visualization to a Dashboard that will allow users to explore correlations between different measures.

Which type of visualization should be used?

A. Pie

B. Heat

C. Radial

D. Scatter plot

A report author was asked to create a report that displays Order method data within a List with a guide pointing to each Order method.

How can this be accomplished?

A. By creating a grouped list by Order method.

B. By creating data decks with lists filtering Order method.

C. By creating page breaks based on a data item and defining a grouping structure for the page set.

D. By adding a table of contents and a table of contents entry next to the order within the List.