Infosys Certified IBM Cognos Developer
Practice with real exam-pattern questions for Infosys Certified IBM Cognos Developer. Each question includes a detailed explanation to help you understand the concept, not just memorise the answer. Try 10 questions free — no login required.
Full question bank for this exam + 1,357+ others. Cancel anytime.
Join Premium10 Infosys Certified IBM Cognos Developer practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified IBM Cognos Developer certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
Roll up processing property of a query is used for which of the following purposes?
- ✓ To specify how the data will be grouped Correct
- B To specify whether the data will be grouped or not
- C To specify where the aggregation of data will be performed, whether in the data base or in the cognos server
- D None of the above Choices
- Question 2
A crosstab report can have more than one data items in the columns or in the rows section but only one measure
- ✓ True Correct
- B False
- Question 3
What can be done to ensure faster run time of the report?
- ✓ Set the use SQL with clause property of the query to yes Correct
- B Set the use Local Cache property of the query to No
- C Use summary level filters
- D None of the above Choices
- Question 4
Which of the following are TRUE regarding charts
a)At least one Query item and at least one measure/fact is required to create a chart
b)A maximum of two Query items and any number of measures/facts can be included in a chart
- ✓ a) and b) Correct
- B only b)
- C only a)
- D neither a) nor b)
- Question 5
Which of the following are TRUE with regards to Grouping?
a) Group span can be set even if there is one grouped column in the report
b) When a data item is grouped, it is grouped in the report layout as well as in the query
- ✓ a) and b) Correct
- B only b)
- C only a)
- D neither a) nor b)
- Question 6
Which of the following are TRUE regarding queries in report studio?
a)A query is automatically created by the report studio when we insert data items into a data container
b)A query contains only the data items which have been dragged from the package into the report layout and not the data items which the user adds in the report layout for example a calculated data item
- ✓ a) and b) Correct
- B only b)
- C only a)
- D neither a) nor b)
- Question 7
Swapping rows with columns and vice-versa is not possible for which type of report?
- ✓ List report Correct
- B Chart report
- C Crosstab report
- D None of the above Choices
- Question 8
When creating a crosstab report in query studio, what can be done to turn off automatic summarization of values?
- ✓ Go to the Advanced Options in the Run Report tab and uncheck the required property Correct
- B Go to the Summarize option in the Edit Data tab and select None in the summary options drop down
- C Either a) or b)
- D Neither a) nor b)
- Question 9
Which of the following are TRUE?
a) Public folder contains the packages, folders and reports usually created by the administrator
b) A user who is not an administrator cannot place his reports in the public folder
- ✓ a) and b) Correct
- B only b)
- C only a)
- D neither a) nor b)
- Question 10
A report requires viewing revenue generated for each product line for each order method and for each quarter in a crosstab. The Products dimension contains product line. The Orders dimension contains order method, order month and revenue. Quarter is being derived from the order month data item. Which type of report is being generated?
- ✓ A repeater table Correct
- B A disconnected crosstab report
- C A nested crosstab report
- D None of the above Choices
More in DNA
Infosys Certified Databricks Analyst
Infosys Certified Snowflake Advanced Developer
Infosys Certified Tableau Desktop Advanced Developer
Pay once. Clear every cert this year.
One subscription, full Telegram channel access, every PDF posted during your membership.
- Full access to all 1,357+ certifications
- Monthly updated question banks
- Telegram private channel access
- Cancel anytime
- Everything in Monthly
- Save ₹2,100 vs monthly billing
- Priority answer key requests
- Best for increasing DQ score fast
- Everything in Quarterly
- Lifetime channel access — no renewals
- All future certifications included
- Priority response from admin team
Common questions, straight answers.
A monthly-updated Telegram channel where we post real exam-pattern question banks and detailed answer keys for 1,357+ Infosys Lex certifications. You join once, you get every PDF posted during your membership.
Right after payment on our Graphy page, you'll receive a private invite link to the Telegram channel. Access is instant — usually under 30 seconds.
We compile question banks from the actual Lex test pattern, sourced and verified by 180K+ community members who've recently cleared these exams. Match rate is consistently 85–95%.
Every single month. When Infosys rolls out new versions of certifications, we post updated dumps within 7–10 days. You'll see channel activity weekly.
Clearing certifications is one of the highest-weighted DQ factors. Members typically clear 3–5 certifications in their first 3 months, which moves DQ scores up by a full band.