C2090-621 Latest Certification Tests

By Author: Dennis Ng
Total Articles: 67
Comment this article

Question: 1

A report author has been asked to create a list report with multiple facts from across the business. The desired outcome must ensure correlated and predictable results.
Which item must be included in the list report?

A. Repeater table
B. Conditional fact
C. Model Query subject
D. Conformed dimension

Answer: C

Question: 2

A user is creating a join relationship in a Data module.
What benefit can be expected from setting a filter join?

A. Theperformance on the join could be improved.
B. The result set from the join would return less rows.
C. The result set from the join would return more rows.
D. The join relationship would work on multiple fields in each table.

Answer: A

Question: 3

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

Answer: D

Question: 4

A report author had created ...
... a single select value prompt using the prompt wizard. The end user now needs to select more than one value.
What should the report author do?

A. Set the Auto-submit property of the Prompt to ‘Yes’ and changethe Multi-select property of the value prompt to ‘Yes’.
B. Set the Auto-Submit property of the Prompt to ‘Yes’ and change the parameterized filter associated with the prompt to the ‘in’ operator.
C. Change the Multi-select property of the value prompt to‘Yes’ and change the parameterized filter associated with the prompt to the ‘>’ operator.
D. Change the Multi-select property of the value prompt to ‘Yes’ and change the parameterized filter associated with the prompt to the ‘in’ operator.

Answer: A

Question: 5

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

Answer: A

Question: 6

A report author uploads files into Cognos Analytics – Reporting.
Which file formats are supported? (Choose two.)

A. Microsoft Excel formatted single sheet worksheets.
B. Any text or Microsoft Excel spreadsheet (xlsx or xls).
C. Text files with data separated by commas, colons, tabs or semi-colons.
D. Text files with data separated by commas, tabs, semi-colons or pipes.
E. Text files must be fixed length without any separator denoting columns.

Answer: A,C