SSAS (SQL Server Analysis Services) 1. What is Data warehouse ? 2. What is Business Intelligence ? 3. What are the tools in SQL Server which serves for Data warehouse and Business Intelligence ? 4. What are the Kinds of Data warehouse ? 5. How do you plan your data warehouse complete project ? 6. What are the benefits of DW and BI ? 7. Can you briefly explain the DW project on your working ? 8. What is OLTP and OLAP ? 9. What is Analysis Services ? 10. What is ODS ? 11. What is Data Mart ? 12. What is Dimension ? 13. What are differences between Dimensional Model and Relational Model of System ? 14. What are the Model of Data ware house ? 15. What are differences between snowflake and star model? 16. What is CUBE ? 17. What is FACT and Dimensions ? 18. What is Dimensions and Measures ? 19. How to Build and Deploy Cubes in SSAS ? 20. What is MDX and D
Connecting, Sharing and Discovering