IBM C2090-621 IBM Cognos Analytics Author V11 Online Training
IBM C2090-621 Online Training
The questions for C2090-621 were last updated at Nov 19,2024.
- Exam Code: C2090-621
- Exam Name: IBM Cognos Analytics Author V11
- Certification Provider: IBM
- Latest update: Nov 19,2024
A report author uploads files into Cognos Analytics C 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.
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
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?
- A . Convert the report to use Native SQL statements.
- B . Move the appropriate filters to the underling queries.
- C . Change the Cross Product allowed property to be “Deny”.
- D . Modify the Query Execution method to Concurrent to ensure that the underlying queries run at the same time.
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?
- A . Default selections are missing in the Value prompt.
- B . The Value prompt created based on the filter is a Multi-select prompt.
- C . A prompt based on an existing parameter as Auto-submit cannot be made.
- D . Auto-submit is a property that is only available for select and search prompts.
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?
- A . Directory entries must not use the alternate path syntax.
- B . The burst table can be an uploaded file and contain as many columns as needed.
- C . The burst table must contain three columns (Recipient, Recipient type and Data item) to burst on.
- D . The directory entry can use either the alternate path syntax or the internal search path using the CAMID.
A report author needs to create an offline interactive report that can be filtered by clicking on a list of values. For example, by clicking on Region “A” the List will display only the details from Region “A”.
Which Reaction behavior should be selected?
- A . Enable a control.
- B . Filter an item in a control.
- C . Select an item in a control.
- D . Create a report expression and use it in filters.
A report author needs to verify that the cardinality is set correctly in order to properly group a list report.
What is the correct setting?
- A . 1:1 cardinality from left to right
- B . 1:1 cardinality from right to left
- C . 1: n cardinality from left to right
- D . 1: n cardinality from right to left
A report author wants to create an Active Report with a chart that is dynamically rendered in the browser based on user selections.
How can this be accomplished?
- A . A legacy chart with client side processing.
- B . A legacy chart with server side processing.
- C . A Virtualization with client side processing.
- D . A Virtualization with server side processing.
A user is creating a join relationship in a Data module.
What benefit can be expected from setting a filter join?
- A . The performance 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.
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
Latest C2090-621 Dumps Valid Version with 104 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
