QUESTION: 21

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

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

Answer(s): A,C

Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/c_rs_cwa_mng_ext_dta.html

Reveal Solution Next Question

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?

Repeater table
Conditional fact
Model Query subject
Conformed dimension

Answer(s): C

Reveal Solution Next Question

QUESTION: 23

A report contains multiple queries that are joined to form the report, resulting in poor performance. The company’s policy prohibits the use of user-defined SQL statements within reports.
What should be done to improve report performance?

Convert the report to use Native SQL statements.
Move the appropriate filters to the underling queries.
Change the Cross Product allowed property to be “Deny”.
Modify the Query Execution method to Concurrent to ensure that the underlying queries run at the same time.

Answer(s): D

Reveal Solution Next Question

QUESTION: 24

A report author has the following filter in a report:
[Product line] in ?pline?

The report author adds a Value prompt based on the existing parameter ‘pline’. After adding the prompt, the Auto-submit property is defaulted to ‘No’ and cannot be changed to ‘Yes’.

What is the cause of this?

Default selections are missing in the Value prompt.
The Value prompt created based on the filter is a Multi-select prompt.
A prompt based on an existing parameter as Auto-submit cannot be made.
Auto-submit is a property that is only available for select and search prompts.

Answer(s): B

Reveal Solution Next Question

Free C2090-621 Exam Braindumps (page: 7)

QUESTION: 21

Reference:

QUESTION: 22

QUESTION: 23

QUESTION: 24