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?
29. What are the options to deploy SSAS cube in production?