support@Free-Braindumps.com
Register Login
Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
CrowdStrike
Anthropic
All Vendors
  1. Home
  2. Exams
  3. IBM
  4. C2090-621

Free C2090-621 Exam Braindumps
IBM Cognos Analytics Author V11 Questions 21–25 (page: 6)

Page 6 of 22
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



A company would like to distribute reports to users via an email address or a directory entry. How should the burst table be defined for this to work appropriately?

  1. Directory entries must not use the alternate path syntax.
  2. The burst table can be an uploaded file and contain as many columns as needed.
  3. The burst table must contain three columns (Recipient, Recipient type and Data item) to burst on.
  4. The directory entry can use either the alternate path syntax or the internal search path using the CAMI

Answer(s): C


Reference:

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



  PDF
Viewing page 6 of 22
Viewing questions 26 - 30 out of 104 questions


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

AI Tutor AI Tutor 👋 I’m here to help!