Swati Lathia

Learning ways

One Mark Questions

  1. EDW stands for _____
  2. What is Data Warehouse?
  3. What is Data Warehousing?
  4. List different Data Warehousing Tools
  5. List characteristics of Data Warehouse
  6. List types of Data mart
  7. List 4 tiers of Data warehouse
  8. What is First Party Data?
  9. What is Second Party Data?
  10. What is Third Party Data?
  11. What is Independent Data Mart?
  12. What is Dependent Data Mart?
  13. What is Fact Table?
  14. What is Dimension Table?
  15. ___ type of data is stored in fact table
  16. ___ type of data is stored in dimension table
  17. Draw a logical model of Data Warehouse
  18. Draw a physical model of Data Warehouse
  19. ETL stands for _________
  20. What is ETL?
  21. CSV stands for ________
  22. SSIS stands for _______
  23. DTS stands for ______
  24. DTSX stands for ______
  25. BIDS stands for ________
  26. SCD stands for ______
  27. List different types of SCD
  28. List types of Dimensions
  29. SSMS stands for ______
  30. List different Containers in SSIS
  31. MDM stands for _____
  32. CRM stands for_____
  33. OLAP stands for ____
  34. OLTP stands for _____
  35. DSS stands for _____
  36. SOA stands for _____
  37. ROLAP stands for ____
  38. MOLAP stands for ____
  39. UID stands for _____
  40. SSAS stands for _____
  41. SSRS stands for _____
  42. SSDT stands for ____
  43. DQS stands for _____
  44. BIML stands for _____
  45. DQAF stands for _____
  46. List architectural components of Data Warehouse
  47. What is Data Flow?
  48. What is Control Flow?
  49. What is Data Cleansing?
  50. What is Data Matching?
  51. Auto correction & auto suggestion values are parts of _______ Cleansing
  52. suggested & invalid values are parts of _____ Cleansing
  53. List the components of Data Flow Task?
  54. List different Event Handlers
Scroll to top