Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home IBM C2090-621

IBM C2090-621 Exam Practice Questions (P. 5)

  • Full Access (105 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #21
A report author uploads files into Cognos Analytics "" Reporting.
Which file formats are supported? (Choose two.)
  1. A
    Microsoft Excel formatted single sheet worksheets.
  2. B
    Any text or Microsoft Excel spreadsheet (xlsx or xls).
  3. C
    Text files with data separated by commas, colons, tabs or semi-colons.
  4. D
    Text files with data separated by commas, tabs, semi-colons or pipes.
  5. E
    Text files must be fixed length without any separator denoting columns.

Correct Answer:
AC
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

Question #22
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. A
    Repeater table
  2. B
    Conditional fact
  3. C
    Model Query subject
  4. D
    Conformed dimension

Correct Answer:
C

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?
  1. A
    Convert the report to use Native SQL statements.
  2. B
    Move the appropriate filters to the underling queries.
  3. C
    Change the Cross Product allowed property to be "Deny".
  4. D
    Modify the Query Execution method to Concurrent to ensure that the underlying queries run at the same time.

Correct Answer:
D

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?
  1. A
    Default selections are missing in the Value prompt.
  2. B
    The Value prompt created based on the filter is a Multi-select prompt.
  3. C
    A prompt based on an existing parameter as Auto-submit cannot be made.
  4. D
    Auto-submit is a property that is only available for select and search prompts.

Correct Answer:
B

Question #25
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. A
    Directory entries must not use the alternate path syntax.
  2. B
    The burst table can be an uploaded file and contain as many columns as needed.
  3. C
    The burst table must contain three columns (Recipient, Recipient type and Data item) to burst on.
  4. D
    The directory entry can use either the alternate path syntax or the internal search path using the CAMID.

Correct Answer:
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

Previous Questions Next Questions

All Pages