Top 10 Microstrategy Admin Interview Questions & Answers
By Bigclasses.com
Name the licenses that can be bought for Microstrategy? We can buy only two Microstrategy license. They are users and CPU license.
Define a Joint Child? The joint child is a part of Microstrategy where it handles composite keys. These composite keys constituted with two or maybe more columns. These act together as a unique identifier. These cases are handled set of columns with composite keys.
How is VLDB beneficial for Microstrategy? VLDB stands for Very Large Data Base properties and is beneficial to Microstrategy in many ways. It handles the database and generates the report to SQL. There are many VLDB properties and few of them are attribute join types, cross join check, intermediate tables, and more.
Define the object prompt? The object prompt will allow you to choose the type of Microstrategy objects for the report, attribute, metrics, and more. These also determine the definition of the report template.
How can you configure the project sources in MSTR Office? You can configure the project sources in the MSTR office by editing projects sources.ml. Also, new project sources can be added. Mention the way to optimize the reports VLDB properties are the type of properties that will allow you to customize the SQL generated by the Microstrategy. You can determine the data processing method by the analytical engine.
Mention the correct order for VLDB properties Reports – Project – Database Instance – DBMS
What is the way to resolve attribute roles? You can resolve by creating explicit tables and enable them for Automatic Attribute Roles recognition.
Mention the types of report caches There are 4 types of caches and they are as follows Matching Caches History Caches Matching –History Caches XML Caches
Give the difference between project merges and object manager The object manager is able to move only limited no. of objects in the folders. While the project merge is able to move unlimited objects in the project. The object manager locates the dependents of all copied objects. It can also determine their differences before performing the copy operations. While the project merge isn’t into dependency search. Lately, project merge is able to run command prompt in Windows.
To know more details on Microstrategy click here :https://bigclasses.com/microstrategy-online-training.html For regular Updates on Microstrategy please like our Facebook page:Facebook:- https://www.facebook.com/bigclasses/Twitter:https://twitter.com/bigclassesLinkedIn:https://www.linkedin.com/company/bigclasses Google+: https://plus.google.com/+BigclassesonlineContact us: - India +91 800 811 4040 USA +1 732 325 1626 Email us at: - info@bigclasses.com