Microstrategy Interview Questions - part 7

  1. What is metadata?
  2. What is two-tier connection?
  3. What is three-tier connection?
  4. What is difference between 2, 3 and 4 tier connections?
  5. How do you achieve schema object version control (similar to VSS)?
  6. What are different kinds of objects in MicroStrategy?
  7. What’s fact table?
  8. Where is Administrator’s password stored? Is it stored in encrypted?
  9. Why do we use dimensional modeling in DW? Why not Relational?
  10. What is a batch?
  11. Differences between ROLAP, MOLAP and HOLAP?
  12. What is ETL?
  13. What types of DW’s are most common?
  14. How many MSTR projects have you worked?
  15. What are the types of MSTR objects available?
  16. Explain the step-by-step technical approach after you get the Requirements from the Client.
  17. What’s a System call error? Have you seen Object variable error?
  18. Have you ever manually edited the metadata? why?