Business Intelligence Interview Questions

1. You have two tables Table1 and Table2 and value saved in the corresponding column of the tables are as under -
   Table1
   Column1
   1
   2
   3
   None
   Table2
   2
   3
   None
   None
   > How many none you will get with left outer join?
   > How many none you will get with full outer join?


2. Difference between delete and Truncate? Which one is faster and why?


3. You have a table with column name Gender that holds only two value - Male or Female. What will you do to defect if some wrong value is entered?


4. RS: How to create cascading parameters?


5. RS: What all are different caching available in Reporting services?


6. RS: What will happen to bar graph, if we export report to csv format? How to fix it?


7. RS: What are drill through actions?


8. AS: How to implement partitions?


9. What are KPI? Why a KPI in SSAS?


10. What is zero error?


11. AS: What is diff between ROLAP and MOLAP?


12. IS: Moslty used containers in SSIS?


13. IS: Look up and its caching features?


14. RS: How to implement security features in Reporting service?


15. RS: What is PeriodToState function?


16. Commonly used MDX functions?


17. RS: Difference between Table and Matrix in SSRS?


18. RS: What all types of reports you have created?


19. AS: In Dimension Usage TAB, What all are relationships available?


20. AS: What is diff between many to many and reference?