C2090-621 IBM Cognos Analytics Author V11
Test information:
Number of questions: 60
Time allowed in minutes: 90
Required passing score: 70%
Languages: English
Related certifications:
IBM Certified Designer – IBM Cognos Analytics Author V11
The IBM Certified Designer – IBM Cognos Analytics Author V11 (as of R3) is responsible for building advanced reports, active reports and dashboards using relational data and/or uploaded files, as well as enhancing, customizing, and managing professional reports. This individual has project related experience authoring complex and intermediate level reports and dashboards, and is capable of participating in project implementations as an effective team member.
Dashboards (15%)
Explain designing for mobile use
Describe how to create simple Dashboards
Describe how to create complex interactive Dashboards
Describe how to modify Dashboards
Demonstrate how to control Dashboard data
Reports (45%)
Describe how to create list reports
Describe how to apply filters
Describe how to use prompts
Describe using conditional formatting
Describe using calculations and macros
Describe how to use markers
Demonstrate presenting data graphically
Demonstrate using HTML and XML
Describe using Crosstabs
Explain designing for mobile use
Describe using reusable objects
Describe using layout control
Demonstrate combining multiple related objects
Explain using interactivity
Active Reports (16%)
Describe how to create report connections
Describe using using Charts, Visiualizations and Decks
Describe designing for mobile use
Demonstrate managing controls and variables
Data (20%)
Explain connecting to the Data source
Describe how to use Data sources
Explain the differences between using Data modules and Framework Manager packages on a report
Describe using data shaping
Explain creating reports using an SQL statement�
Distributing Reports (4%)
Describe using bursting
IBM Certified Designer – IBM Cognos Analytics Author V11
Job Role Description / Target Audience
The IBM Certified Designer – IBM Cognos Analytics Author V11 (as of R3) is responsible for building advanced reports, active reports and dashboards using relational data and/or uploaded files, as well as enhancing, customizing, and managing professional reports. This individual has project related experience authoring complex and intermediate level reports and dashboards, and is capable of participating in project implementations as an effective team member.
Recommended Prerequisite Skills
Before preparing for this certification, the described level of skill is recommended and assumed (but not tested) :
– Experience using a modern web
– Basic knowledge of database concepts and SQL
– Basic knowledge of how to visually present data
– Basic knowledge of Java script
QUESTION: No: 1
A customer wants to have a report with a bar chart, which is going to be displayed on a tablet. By
changing a filter on the report, the chart should change dynamically. The report output size should be as
small as possible.
How can this be achieved?
A. Create an Active Report using visualizations. Check that the render method is set to Client.
B. Create an Active Report using visualizations. Check that the render method is set to Server.
C. Using a legacy chart with a conditional block around it. The block will be switched depending on the
selected filters.
D. Using a default chart with a conditional block around it. The block will be switched depending on the
selected filters. Set the render method to Dynamic.
Answer: B
QUESTION: No: 2
An author has finished working on a Dashboard and wants to make it available to other authors.
Where should the Dashboard be located?
A. My content folder
B. Team content folder
C. Administration console, Mobile tab
D. Administration console, Library tab
Answer: B
QUESTION: No: 3
A report author wants to nest a chart within a list and filter the chart data to relate to the row of the list that
it is displayed in.
How can this be done?
A. Enable share result set on the list object.
B. Create a join in the Query explorer to merge the data.
C. Select the list and define a Master detail relationship.
D. Select the chart and define a Master detail relationship.
Answer: D
QUESTION: No: 4
How can a package be created?
A. By combining Data modules.
B. By using content administration.
C. By publishing from a subset of a model.
D. By using any valid non-relational Data source.
Answer: C
QUESTION: No: 5
A report author wants to enhance a report by having the ability to display the data by region and filter by
Order method (where Order method includes: Email, Fax, Post, Sales rep, Promo, Phone, Web site).
How can this be accomplished?
A. Select On-demand toolbar > Select checkbox group> Add default values
B. Select Button Bar control >Go to properties> Change User interface to checkbox
C. Create a parameterized filterfrom the order_method > ManuaIIy populate the parameterized
D. Select the Button Bar control > From the on-demand toolbar > Click the ellipsis > Point to convert
controI> Click check box group
Answer: A
Click here to view complete Q&A of C2090-621 exam
Certkingdom Review
Best IBM C2090-621 Certification, IBM C2090-621 Training at certkingdom.com