Saturday, November 10, 2007

MicroStrategy Interview Questions 101

1. What is metadata?

2. What is two-tier connection?

3. What is three-tier connection?

4. What is difference between 2 and 3 tier connection?

5. What is ScanMD?

6. What is MD Doctor?

7. What is clustering?

8. How do you achieve schema object version control (similar to VSS)?

9. What are different kinds of objects in MicroStrategy?

10. How will you reset password of all users?

11. What are different modes you can run I-Server?

12. 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?

13. What is the difference between RW document and HTML document?

14. What are various authentication modes?

15. How can you configure WH authentication?

16. Does DLS affects MicroStrategy? What you need to do incorporate it?

17. What's smart metric?

18. What's fact table?

19. What is fact constellation schema? What is star schema? What is snowflake schema?

20. Should you have DATE as ID attribute form?

21. What is compound key?

22. What is a bridge/relationship table?

23. How will you resolve double counting in M-M relationship between two attributes?

24. What is Object Manager?

25. What will you do when I-Server crashes?

26. Where is Administrator's password stored? Is it stored in encrypted?

27. What will you do if your Administrator has forgotten password or the account is locked?

28. How can you monitor the error received while running I-Server and report?

29. What is a surrogate key?

30. Why do we use a staging area?

31. Why do we need a DW?

32. Why do we use dimensional modeling in DW? Why not Relational?

33. How much history should we have in a DW?

34. What are the most important tables in a DW?

35. What is a fact and an attribute?

36. What is a batch?

37. Diferences between ROLAP, MOLAP and HOLAP?

38. What is a CUBE?

39. Why Kimball? Why not Inmon? Or vice versa? ;)

40. Performance with a relational based query vs dimensional?

41. What is ETL?

42. What types of DW's are most common abroad?

43. How many MSTR projects have you worked? Explain in detail.

44. Tell us about your Roles & Responsibilities in your project.

45. Have you managed any team for MSTR project?

46. What are the two types of schemas available in DW?

47. Difference between Star schema and Snowflake schema.

48. What schema is used in your project? Why?

49. What are conformed dimensions?

50. What are Factless facts?

51. Explain 2-tier and 3-tier Architecture in MSTR including pros and cons.

52. What is 4-tier architecture?

53. What architecture is used in your project? Why?

54. What are the types of MSTR objects available?

55. Explain Schema objects. (One by one)

56. Have you created any Facts, Attributes for your project? How?

57. What are Transformations? Is there any transformations implemented in your project? Explain the example from your project.

58. What are the features available for MSTR Intelligence Server?

59. Explain Fact Structure. (4 types, one by one)

60. Explain Level Extension. How it is used in your project?

61. Explain Fact Relation.

62. Explain Fact Degradation.

63. Difference between View Filter and Report Filter.

64. What are the different types of Filters available? Explain each with example.

65. What is derived metrics? Explain the example from your project.

66. What is Compound Key Attribute? Give example from your project.

67. Explain VLDB properties in detail.

68. Similar to Visual SourceSafe (VSS) for version controlling, HOW can we achieve the same for Objects in MSTR?

69. Give the step-by-step approach followed for Testing MSTR reports, both from MSTR Desktop and MSTR Web.

70. Have you done any Estimation for MSTR reports?

71. How will you differentiate Simple, Medium and Complex reports while doing estimation for MSTR reports?

72. How to use Templates in MSTR?

73. What are Prompted Filters?

74. What is Bridge table?

75. Where will you customize the display for Null Values?

76. Explain the step-by-step technical approach after you get the Requirements from the Client.

Will be updating as and when I think of more questions. This is my list of question I generally ask if ask to interview a candidate. But keep in mind, this is just for initial cut off. Second round will have unique practical questions. Depends upon how much you have got to explore MicroStrategy.

9 comments:

  1. Hi, I was wondering if you know examples of any practical questions that the second level interviewers may ask for MSTR. Thanks

    ReplyDelete
  2. Hi I do know many question, but that is always decided on the level of the person who has come up. There are different types of question.

    I generally go for tricky metric situation. I grill on filtering option.

    Then I ask how to compared two metric based on ApplySimple in Report limit.

    I judge him on his performance tuning ability and try to get more insight about that. He may have done a different tuning that I may not have even come across or even read. So I need to try to evaluate the situation. His knowledge level at that time also matters.

    Many-to-many relationship implementation using Factless fact (Bridge table)

    Slowly changing dimension

    Fact Extension (Can go one for hour sometime)

    will post in main blogs some time.

    ReplyDelete
  3. Hi Ashish..

    Thanks a lot for the 101 Microstrategy Question....

    Could you please update the list....

    Thanks

    ReplyDelete
  4. iam asking a answers pls (101)

    ReplyDelete
  5. 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?
    Can Any one Please answer this question .

    I faced the above problem in my MicroStrategy I-Server clustering we are having two I-Servers in Cluster both are running fine but we are not able to login through M-Web or M-Desktop anyway restart of I-Server resolved the issue.




    2008-09-09 08:16:08.803-08:00 [HOST:xxxxxx][PID:23413][THR:1243941232][Kernel][Error] ClusterManager::SynchronizeMembership() for this server failed -- message can not be sent to all servers: HResult = -2147207433.

    ReplyDelete
  6. hi Ashish...i searched for some query and found the answers on your home page...

    thanks a lot...so how are u?
    dint see u online too...
    cya online...gud day.
    Anurag.

    ReplyDelete
  7. Hi, where can I find the answers, thanks

    ReplyDelete
  8. Thanks! but, these are too simple questions.

    ReplyDelete
  9. Easy or tough, depends upon reader's knowledge. This is an FAQ compilcation for 1st technical round of interview for a MicroStrategy job. Has to be a mixed bag.

    ReplyDelete

Note: Only a member of this blog may post a comment.