MicroStrategy Interview Questions

General Questions:

  1. Describe your previous experience and the projects you worked on.
  2. Describe your expertise, your strengths and your weaknesses.
  3. What databases have you worked on?
  4. What is the database size that you dealed with? What is the max size of the database that you worked on?
  5. Comfort level on SQL
  6. How to tune a report SQL.
  7. Troubling shooting an issue.
  8. How to you handle the migration process
  9. What is the documentation process that you prefer or followed in the past.
  10. Any experience interacting with Business Users?
  11. Any experience in gathering requirements?
  12. Do you have experience training end users.
  13. When a users reports an issue and complains about the performance, how would you handle this, explain in detail.
  14. Common User issues that you have experienced?
  15. What versions of MicroStrategy have you worked on? What do you like in the latest version?
  16. Tell me one of your favorite feature of MicroStrategy and why do you like it.
  17. What is your current team size.
  18. If you have multiple architects working on same projects, how do you make sure that both of them are not modifying the schema at a time.
  19. How many users did you support?
  20. Describe your experience with NC. List some common issues.

Adminstration & Narrowcast

  1. What is metadata?
  2. Explain 2-tier and 3-tier Architecture in MSTR.
  3. What is ScanMD and MD Doctor?
  4. What is clustering and types of clustering?
  5. How did you achieve or document schema object version control at your previous clients?
  6. What are different modes you can run I-Server?
  7. How can you make sure that I-Server would be running even if the application mode has crashed and how to get back the instance?
  8. What are various authentication modes?
  9. What will you do when I-Server crashes?
  10. Where is Administrator’s password stored? Is it encrypted? How will you reset password of all users?
  11. What will you do if your Administrator has forgotten password or the account is locked?
  12. How can you monitor the error received while running I-Server and report?
  13. What are the features available for MSTR Intelligence Server?
  14. When you wanted to compare two projects in MSTR. What are the tools available and what would you use?
  15. What is the use of command manager?
  16. Types of caches and where are they stored?
  17. Where and how are the report caches saved? When are they used?
  18. On what operating systems can MicroStrategy run?
  19. Have you done any customizations of the tool, if so please describe.
  20. What types of services have you built in Narrowcast.
  21. What is the difference between PPE (Personalized Page Execution) and PRE (Personalized Report Execution)?

Architect and Report Development

  1. What are Factless facts?
  2. Difference between Star schema and Snowflake schema. And what is best suited for MicroStrategy
  3. What is the difference between view and materialized view?
  4. What are OLAP Services. Define couple of them.
  5. What’s fact table, dimension table and relate table?
  6. Should you have DATE as ID attribute form?
  7. What is compound key?
  8. What is a relationship table?
  9. How will you resolve double counting in M-M relationship between two attributes?
  10. What is the difference between RSD document and HTML document?
  11. Have you worked on flash dashboards? Explain few feature of flash?
  12. What are Transformations? Are there any transformations implemented in your project? Explain an example from your project.
  13. Explain Level Metrics. How it is used in your project?
  14. Explain Fact Degradation.
  15. Difference between View Filter and Report Filter.
  16. Explain custom groups and consolidations and the difference between them.
  17. Explain few VLDB properties that you have used in the past and the reason behind them.
  18. What is a role attribute?
  19. What are different null which can occur in a report and how do you mask them?
  20. Talk about best practices in creating dashboards and reports

Database Related

  1. What is a surrogate key? Difference between a primary key and a surrogate key.
  2. Why do we use a staging area?
  3. Why do we use dimensional modeling in DW? Why not Relational?
  4. What are conformed dimensions?