1. What are the options to deploy SSAS cube in production?
2. In which scenario, you would like to go for materializing dimension?
3. How many types of dimension are possible in SSAS?
4. What do you understand by dynamic named set (SSAS 2008)?
5. How many types of actions available in the Cube?
6. DSV stands?
7. MDX stands?
8. Define dimension usage in SSAS Cube?
9. Define role play dimensions?
10. How many container tasks available in SSIS?
11. What does mean by data auditing?
12. How to rename file using SSIS tasks?
13. Define synchronous transformations?
14. Define Lookup transformation?
15. SSIS 2008 configuration types?
16. Explain event handlers?
17. What does a control flow do?
18. Difference between for loop and for each loop container?
19. Explain ETL process?
20. What are the basic functions system databases?
21. Define having clause?
22. What command do we use to rename db, table, and column?
23. Define Index?
24. What is BCP?
25. What are the advantages of using stored procedure?
26. What are different types of joins?
27. What is Normalization? Types of normalization?
28. Define Row Number function?
29. What is the difference between UNION and UNION ALL?
XBRL
CMMI: Capability Maturity Model Integration
X Code
Management Information Systems (MIS)
Web Application
Adobe Animate
Related MCQ's