TOP 40 MSBI Multiple Choice Questions and Answers for Freshers pdf free download

The below list of TOP 40 MSBI Multiple Choice Questions and Answers for Freshers pdf free download 
1. What is the difference between UNION and UNION ALL?
 2. Define Row Number function?
 3. What is Normalization? Types of normalization?
 4. What are different types of joins?
 5. What are the advantages of using stored procedure?
 6. What is BCP?
 7. Define Index?
 8. What command do we use to rename db, table, and column?
 9. Define having clause?
 10. What are the basic functions system databases?
 11. Explain ETL process?
 12. Difference between for loop and for each loop container?
 13. What does a control flow do?
 14. Explain event handlers?
 15. SSIS 2008 configuration types?
 16. Define Lookup transformation?
 17. Define synchronous transformations?
 18. How to rename file using SSIS tasks?
 19. What does mean by data auditing?
 20. How many container tasks available in SSIS?
 21. Define role play dimensions?
 22. Define dimension usage in SSAS Cube?
 23. MDX stands?
 24. DSV stands?
 25. How many types of actions available in the Cube?
 26. What do you understand by dynamic named set (SSAS 2008.?
 27. How many types of dimension are possible in SSAS?
 28. In which scenario, you would like to go for materializing dimension?
 30. What are the options to deploy SSAS cube in production?
 31. Describe Reporting Lifecycle?
 32. What can SQL Server Reporting Services do?
 33. Define reporting processing?
 34. How many default rending options are available in SSRS2008?
 35. What is the usage of Report Builder?
 37. How many architecture components of SSRS 2008?
 38. Explain on SSRS2008 Reporting Items?
 39. What does mean by nested datasets?
 40. How many command line utilities of SSRS2008?