C2090-621 Online Practice Questions and Answers

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?

A. Select On-demand toolbar > Select checkbox group > Add default values

B. Select Button Bar control > Go to properties > Change User interface to checkbox

C. Create a parameterized filter from the order_method > Manually populate the parameterized

D. Select the Button Bar control > From the on-demand toolbar > Click the ellipsis > Point to convert control > Click check box group

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

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. Source tab

C. Functions tab

D. Parameter tab

A company is using a model that was created in Compatible Query Mode (CQM). 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 that reference multiple Data sources.

B. The report author can add multiple packages to the reports as Data sources and create the report as needed.

C. The report author must use SQL nodes for all queries that reference the data items in the two packages and join them appropriately to get the desired results within the report.

D. The report author can use user-defined SQL to develop the query from one of the packages and the other package to develop the other query and then join them appropriately to get the desired results within the report.

A user is creating a Dashboard from an uploaded file and an additional Data source is needed. From which source can the additional data be used directly?

A. Pivot files

B. Crosstabs

C. Data Modules

D. Published packages

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. Build two charts next to each other.

C. Map Quantity to a y axis with a different scale.

D. Multiply Quantity by 1000000 and set the scale to -6 to display.

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

A. Set all objects to Portrait views.

B. Set all report objects to Portrait aware.

C. Set the Mobile alignment property to Automatic.

D. Size the object as a percentage of the available space.

A report author created the following list report and wants to filter all order methods which generated total revenue less than one billion.

Which filter should be used?

A. A detail filter as [Revenue] >= 100000000 with application set to before auto aggregation.

B. A detail filter as [Revenue] >= 100000000 with application set to after auto aggregation.

C. A detail filter for Total([Revenue]) >= 100000000 with application set to before auto aggregation.

D. A detail filter for Total([Revenue]) >= 100000000 with application set to after auto aggregation.

A company has a Product Returns report. The Return Comments query item is present in the list query but was left out of the list due to space constraints on the report page. The users have asked to see this information interactively.

How could the report author add this functionality with only minimal changes to the existing report?

A. Add HTML Items to the Product Name cell that use Report Expression to assign [Return comments] to HTML span title.

B. Add Product Description as a list column and use the Render Variable property and a prompt to conditionally render the column.

C. Add a Drill-through definition to the Product name cell and set the Target to Label and Data Item to the [Return comments] query item.

D. Insert a master-detail single row microchart to the Product column cell with transparency on and chart Tooltips property set to Absolute.

Which file type can be uploaded in Cognos Analytics?

A. Fixed width text file.

B. Tab separated value text file.

C. Colon separated value text file.

D. Microsoft word document (.docx).