COGNOS 10 INTERVIEW QUESTIONS

Hello every one please do prepare the below questions before appearing any COGNOS interview 

There is a probability of 70% questions coming from the below 

Will post the answers for each question soon .Also please contribute for addition of new questions under each category as comments to this post

Will also post different scenario based questions and transformer related questions soon

Frame work manager interview questions

1. What is a Model?
2. What is a Project?
3. What is a Package?
4. Tell me the cycle from project creation to publishing the model in FM
5. What is query subject and Query item
6. What are the types of Query subjects in Cognos and Explain
7. Explain different layers in FM
8. Types of model's you have used in your FM(dimensional,relational)
9. What is Cardinality?
10. What are joins and types of joins
11. Cardinality for different types of joins
12. What are loops in FM model and how to resolve loops
13. types of shortcuts(reference and alias)
14. what are filters in FM(STAND ALONE AND EMBEDDED)
15. types of security(package ,object, data, row level)
16. governor settings in FM
17. Determinants and what is its significance
18. What are usage properties
19. What is stitched query
20. What are Session parameters
21. Explain about Parameter maps
22. What are Macros
23. What is Model Advisor
24. What are Scope relations in dimensional model
25. Explain Dimensional functions such as set,slice,filter
26. Explain Dimensional functions lead lag parent child
27. Explain Dynamic query mode
28. Explain Model design accelerator
29. Difference between CQM  vs DQM
30. New functionalities added to FM in Cognos 10 from Cognos 8
31. Multiuser models (linking segmenting branching etc.)
32. Types of Schemas used in your project
33. Tools tab properties like show object dependencies, model reports etc.
34. Differences between cubes(OLAP) and DMR
35. Scope relationship in DMR
36. What is MUN and tree prompt
37. What is drill up drill down slice and dice
38. What are the types of hierarchies? In dimensional model
39. What are query processing types(limited to local limited to DB)

Report studio interview questions

1. Explain Complex reports you have worked on
2. What is drill through and how many types you can achieve(pass by dataitem,pass by parameter)
3. What is master detail why is it used
4. Difference between master detail and drill through
5. Types of filters in Report studio and explain(detail,summary)
6. What is before aggregation and after aggregation?
7. What is aggregation and rollup aggregation?
8. What are conditional blocks?
9. Various types of variables in report studio
10. Explain the components like style variable render variable block variable
11. What is text source variable
12. What is repeater table and why are repeaters used
13. What is singleton and what is its significance
14. What is conditional formatting how you implemented it in your project?
15. Which chart you can plot two measures (bubble)
16. Types of prompts
17. Can you convert crosstab to list and vice versa
18. How can you increase performance of the report
19. What is cascaded prompt
20. What is re prompt and auto submit
21. Explain Display value vs use values and its significance
22. What are static choices in prompts and why are they used
23. What are page breaks and page sets in report
24. What is group span
25. What is difference between group by and order by
26. How can you display two measures in a cross tab report
27. what are the ways in which can you establish a relation between queries in your report(join union)
28. what is union of two queries how can you achieve
29. what is MDX,SQL
30. what is Bursting have you implemented it in your project
31. difference between bursting and scheduling
32. what is CAMID
33. How can you limit rows in report where will you change the property
34. What are active reports
35. What are the active report components you have used
36. What is a variable and event in active report
37. Ancestor button in report studio
38. What is box type property and why it is used
39. What are data containers
40. What is data format how did you use this in your reports
41. Row level security?
42. What are query processing types(limited to local limited to DB)
43. What is source type property
44. Snapshot  and report view differences
45. What is hyperlink and why it is used in reports
46. how to get the all values from a prompt using 'ALL'
47. Can u drill through report from report studio to analysis studio and vice versa
48. Can u Edit Cognos SQL in Report and how
49. Difference between count and running count
50. How to test reports
51. What is layout calculation and its significance
52. How can I change reports to another package
53. Can we use 2 packages in report studio at a time is there any alternative for this
54. what is the difference between group and association
55. Can you apply grouping on crosstab?
56. How will you migrate your reports to QA environment?
57. diff b/w layout calculation and query calculation
58. What is meant by Thumbnails on Cognos?
59. What is level span? How it is used in cognos? What is the main advantage of level span. 

SQL level interview questions for Cognos

1. What are Cognos SQL, native SQL, and Pass through SQL?
2. What is primary key and foreign key
3. What is a sid (surrogate key)?
4. What are types of joins
5. What is sub query and types of sub-quires
6. What is difference between join and sub query
7. What is difference between Where and Having
8. What is difference between group by and order by
9. What is the use of With clause
10. Real time examples for all types of joins
11. Difference between equi join and inner join
12. What is difference between union and union all
13. What is difference between union and join
14. How will you remove duplicates from a table
15. What is self-join and real time significance with example
16. How do you get the latest updated record from the table which is not having any timestamp
17. Nth highest salary of an employee from top and from bottom
18. What is difference b between MDX and SQL
19. What is an index and how many types of indexes you know and significance of indexing
20. what is the difference between group and association

Warehouse level Cognos interview questions

1. Types of schemas
2. What is OLAP and What are the types of OLAPs?
3. What is OLTP and difference between OLAP and OLTP
4. What is relational model and Dimensional model
5. What are facts and dimensions
6. What are regular dimensions and measure dimensions
7. Types of FACT’s
8. Types of Dimensions
9. What best schema star or snow flake and why
10. What is junk dimension,factless fact
11. What is role playing dimension give an example
12. What is Data warehouse and its significance
13. What is the difference between database and data warehouse
14. What is Data mart
15. What is metadata?
16. What is materialized view?
17. What is schema?

Very Important questions and Miscellaneous questions asked in every interview

1. What is Cognos Architecture
2. What is content Store and Content manager
3. How can you increase performance of report at Report studio level
4. What is ETL and what is the ETL tool used in your project
5. What is complete process going on in background  when you run report
6. How can you enhance the performance of a report?(at all levels)
7. How can you tune performance of report at FM level?
8. Best practices of FM
9. Best practices to be followed while designing the report
10. Difference between Business insight and Business insight Advanced
11. Difference between Query studio and Report studio
12. What is metric studio and explain its significance
13. What is analysis studio and what is context filter in analysis Studio.
14. Difference between Group and Role in Cognos for Users