CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. IBM
  5. C2090-621

Free C2090-621 Exam Braindumps (page: 7)

Page 6 of 27
PDF with 104 Questions

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

  1. Microsoft Excel formatted single sheet worksheets.
  2. Any text or Microsoft Excel spreadsheet (xlsx or xls).
  3. Text files with data separated by commas, colons, tabs or semi-colons.
  4. Text files with data separated by commas, tabs, semi-colons or pipes.
  5. 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



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?

  1. Repeater table
  2. Conditional fact
  3. Model Query subject
  4. Conformed dimension

Answer(s): C



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?

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

Answer(s): D



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?

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

Answer(s): B






Post your Comments and Discuss IBM C2090-621 exam with other Community members:

C2090-621 Discussions & Posts