Microstrategy Advanced Interview Questions And Answers
Are you planning to attend an interview for Microstrategy Advanced role but confused on how to crack that interview and also what would be the most probable Microstrategy Advanced Interview Questions that the interviewer may ask? Well, you have reached the right place. Tekslate has collected the most frequently asked Microstrategy Advanced Interview Questions And Answers which are often asked in multiple interviews.
Q1) What are Logical Views used for?
Ans: Logical Views allows application architects to create any desired view using MicroStrategy, without DBA involvement. Once these Logical views are created, they are available to the report designer in a way similar to any other table. This allows developers to model attributes and facts whose expressions span multiple tables.
Q2) How will Project Sources be configured in MSTR Office?
Ans: By editing the projectsources.xml, new project sources can be added.
Q3) Difference between standard, absolute, and ignore condition in metrics?
- Standard filtering allows the report filter to affect the metric.
- Absolute filtering raises the report filter to the level of the target, so all subcategories in the categories included in the report are added together.
- Ignore filtering disregards filtering criteria based on the attribute in the target and its related attributes (both parents and children).
Q4) Comparison between Consolidations and Custom Groups?
Ans: A custom group is a set of special filters that can be placed on a template. It is made up of an ordered collection of elements called custom group elements. Consolidations are used to specify the data you want to view in your report. They allow you to group attribute elements in new ways without changing the metadata and warehouse definitions.
Q5) What is an object prompt?
Ans: An object prompt allows you to select which MicroStrategy objects to include in a report, such as attributes, metrics, custom groups, and so on. Object prompts can either determine the definition of the report template or the report filter.
Q6) How the reports are optimized?
Ans: VLDB properties allow you to customize the SQL that MicroStrategy generates, and determine how data is processed by the Analytical Engine.
Q7) Define the order of precedence of VLDB properties?
Ans: Reports>Project>Database Instance>DBMS
Q8) What is Metric Formula Join Type? How it is different from the Metric Join Type?
- This is basically used for Compound Metrics and determines how the different tables used in the metric formula are joined.
- Whereas the Metric Join Type determines how the metrics are joined to other metrics.
Q9) What are attribute roles?
Ans: A user defines two attributes that have the same definition but play different roles in the business model. In this example, attribute Origin Airport and Destination Airport are defined using the same Lookup Table and Column (Airport_ID). Both attributes share the same forms, or information about them (Description, Location, etc.). In the fact table, however, a separate column exists for each of their roles (Origin_Airport_ID and Destination_Airport_ID).
Q10) How do we resolve attribute roles?
Ans: By creating explicit table alias for the same or enabling the Automatic Attribute Role recognition.
Inclined to build a profession as MicroStrategy Developer? Then here is the blog post on, explore MicroStrategy Training
Q11) What are statistics tables and how do you configure the project statistics?
Ans: Statistics tables contain data on the MicroStrategy system’s usage and performance and are populated by all projects that are configured to log statistics.
Set up the Enterprise Manager.
Define the statistics and enterprise warehouse database.
Create the statistics database instance
Go to the project configuration wizard of the project
Select statistics and define what you want to log
Q12) What is the Command Manager?
Ans: MicroStrategy Command Manager lets you perform various administrative and application development tasks by using text commands that can be saved as scripts. For example: – server management, user management, security, database management.
Q13) Difference between project merge and object manager?
- Object Manager can move just a few objects or just the objects in a few folders. Project Merge moves all the objects in a project.
- Object Manager must locate the dependents of the copied objects and then determine their differences before performing the copy operation. Project Merge does not do a dependency search, since all the objects in the project are to be copied.
- Project Merge can be run from the command prompt in Microsoft Windows.
Q14) How conflicts occur and what the ways to resolve them?
Ans: When copying objects across projects with Object Manager, if an object with the same ID as the source object exists anywhere in the destination project, a conflict occurs. There are various ways to resolve depending upon the conditions like use existing, replace, keep both, use newer, use older, update in the same path, update in a new path, and merge privileges.
Q15) How many types of MicroStrategy licenses can be bought?
Ans: Two types: – named users or CPU license.
Q16) What are report caches and how many types are there?
Ans: A report cache is a result set from an executed report that is stored on MicroStrategy Intelligence Server. 4 types: matching caches, history caches, matching-history caches, and xml caches.
Q17) While establishing a relationship between attributes how do you decide which attribute qualifies as a child and which one as parent?
While establishing the relationship between attributes one can either look from a business hierarchy point of view and the attribute higher in the hierarchy becomes the parent of the attribute lower in the hierarchy. Parent and Child follow a one-to-many relationship. Example Time hierarchy Year > Month > Date. Here Year would-be parent of Month and Date and Month parent of Date.
We can also identify the Parent-Child relationship from a database design point of view. Here is a table the Primary Key uniquely identifies the other columns in the table and hence qualifies as the child of all the other attributes from the table, in the same ways as a child in the real-world identifies his father (at least the biological one).
Q18) What is a joint child?
Ans: A joint child is a Microstrategy way of handling Composite Keys. Composite keys are constituted of two or more columns that together act as a unique identifier. To handle this case in Microstrategy we make this set of columns, constituting composite keys, as a joint child.
Q19) What is the logical size of a table and what does it depend on?
Logical size is the Microstrategy way of generating the best suitable/optimized SQL to fetch the required data. Microstrategy follows an algorithm to calculate the logical size of a table, which depends on the no of attributes and facts based on the table and also the position of those attributes in the system hierarchy.
The logical size does not depend on the actual data (no of rows) in the database. If the candidate answers this then his concept is wrong.
Q20) What are Level Metrics? And why are they required?
Ans: Level metrics are advanced metrics that are set to be evaluated at a specified attribute level. These are required when in the same report you need to roll up a metric at two different levels side by side. An example is a comparison of “Revenue from a Region” to “Revenue from a Country”. Here Region and Country are the two different levels.
Q21) What is the difference in the way Microstrategy Handles Consolidations and Custom Group? Any advantage of using one over the other?
Ans: Custom Groups are handled at the database end whereas Consolidations are handled at the Analytical Engine end. As a result, the Consolidations are not an overhead for the database as there is a single pass in the query. On the other hand, Custom Groups are an overhead on the database as they fire a separate SQL pass for every Custom group element.
Q22) What are VLDB properties?
Ans: VLDB stands for Very Large Data Base Properties. This is a Microstrategy way of handling database-specific preferences while generating the report SQL. There are a number of them. A few common ones are for Attribute or Metric join types, cross join check, type of intermediate table, etc.
Q23) At which levels you can set the VLDB properties? Which level has the highest precedence?
Ans: VLDB Properties can be set at various levels like Report, Template, Metric, Project, Database Instance, and DBMS level. Out of this Report, the level has the highest priority. It overrides all other levels.
Q24) Define various ways of incorporating security in Microstrategy?
Ans: In Microstrategy security can be incorporated using a mix of any of the following ways:
- Putting user-specific restrictions at the database end and using user-specific connection mapping. This is for column-level security.
- Applying folder and object-level security to restrict access to a certain set of reports/objects
- Applying Security filters to the user. This provides row-level security.
Q25) What are pass-through functions and why they are so-called? Give some examples.
Ans: Pass-through functions are a Microstrategy way of generating database-specific SQL construct which otherwise is not possible. These are called pass-through functions because Microstrategy does not check the actual SQL construct and dumps it as is on the database. Examples include ApplySimple, ApplyComparison, etc.
Q26) Please write a query to get “All the departments, and the count of employees in those departments, which have more than 50 employees and are based out of State New York. Following are the table structures:
Ans: Department table: Department_ID, Department_Name, State (Note: Department ID is Unique here and more than one department can belong to one State)
Employee Table: Employee_ID, Employee_Name, Department_ID (Note: Employee ID is unique here and more than one Employee can belong to one department, but one employee does not belong to more than one department)
Following should be the query
FROM department dept
JOIN employee emp
ON dept.department_id = emp.department_id
WHERE dept.state = “new york”
GROUP BY dept.department_id
HAVING Count(emp.employee_id) > 50
Q27) What is star schema and snowflake schema?
Ans: Star Schema is a highly denormalized schema whereas snowflake schema is a highly normalized schema. Star schema is characterized by a large number of rows in a table and fewer joins between tables. A snowflake schema is characterized by fewer few of rows in a table while more joins between tables.
Q28) What are the advantages and disadvantages of star and snowflake schema?
- Star Schema Advantages: Reduces the number of joints between the tables and hence faster performance
- Star Schema Disadvantages: Requires the Most amount of storage space. Snowflake Schema Advantages: Minimum storage space and minimum data redundancy
- Snowflake Schema Disadvantages: Requires more joins to get information from lookup tables hence slow performance.
Q29) What are adhoc reports and static reports?
Adhoc reports run in real-time based on the input parameters provided by the user at the run time. In Microstrategy, adhoc reports are created using Prompts.
In static reports, users won't provide any input parameters. These reports are usually scheduled to run overnight and ready to view immediately in the mornings using cache.
Q30) What is a filter?
Ans: A filter is a public object. It is used to restrict the data retrieved by the report from the database tables. From an SQL perspective, it corresponds to the "WHERE" Clause.
Q31) What are the VLDB properties?
Ans: Using VLDB properties we can change the way how the SQL is generated. Some of them are below:
- Perform full outer joins
- Check for Zeros and Nulls in the denominator while performing divisions in Metrics. Creating Subqueries
- Creating temporary tables.
Q32) What are Consolidations?
Ans: Consolidations enable grouping together attribute elements and create a virtual attribute. They perform Row-level maths.
Q33) What are custom groups?
Ans: Custom groups are used to create different filters for different rows of a report. For example, a report can be created to display the top 5 customers as well as the bottom 5 customers in one report using a custom group.
Q34) What are Pass-through Functions?
Ans: Pass through functions are used to utilize various special functions specific to databases. Some of the passes through functions available are Applysimple and Applycomparision.
Q35) What is a Security filter?
Ans: A security filter is used to apply security at the database data level. Whenever a user’s associated with the security filter runs a report, a WHERE clause is always included in the report SQL with the condition defined in the Security Filter.
Q36) What is Microstrategy Desktop?
Ans: Microstrategy Desktop™ is a Windows client-server software application that provides integrated monitoring, reporting, and analysis capabilities.
Q37) What does Microstrategy Desktop allow users to do?
Ans: Using Microstrategy Desktop, users can easily access and share critical corporate information they need to make cost-cutting decisions and improve business processes. The information found in databases can also be used to help increase revenue and boost profits. Users can access this database and SAP data without having to learn technical database query (SQL) or multi-dimensional expression (MDX) syntax.
Q38) What can users do with the information they access using Microstrategy Desktop?
Ans: Users can analyze the information using standard aggregations and more sophisticated functions such as average, summation, percentage contribution, standard deviation, and net present value. Investigative reporting, using pivoting, sorting, slicing, and drilling to more detail, can be performed with simple mouse clicks. Users can also format reports to their specifications and view the data as intuitive charts and graphs to identify trends and anomalies quickly.
Q39) What are the benefits of using Microstrategy Desktop?
Ans: Users can obtain critical information immediately without waiting for IT departments to create reports. The software is easy to use and provides context-sensitive help, thus eliminating the need for extensive support and maintenance staff.
Q40) Are the reports created using Microstrategy Desktop available to other products such as Microstrategy Web?
Ans: Yes. Reports created using Microstrategy Desktop are immediately available to other Microstrategy products because of our centralized metadata architecture.
Q41) Can Microstrategy Desktop access SAP data?
Ans: Yes. With the release of Microstrategy 8, Microstrategy Desktop incorporates a new dynamic data access engine designed to access multi-dimensional databases
(MDDBs or OLAP Cube Databases) such as those from SAP Business Information Warehouse (BW) databases.
Q42) Can Microstrategy Desktop access operational data systems?
Ans: Yes. Microstrategy Desktop users can use a new Operational SQL Engine to include data from any operating system using completely free-form SQL, including stored procedures and views.
Q43) How fast is the performance on Microstrategy Desktop?
Ans: Microstrategy Desktop provides instant access and analysis of information. This high performance is enabled through Intelligence Cubes™, caches, incremental fetches, and advanced analytic features.
Q44) How long does it take to learn Microstrategy Desktop?
Ans: Microstrategy Desktop preserves the look and feel of popular desktop software such as Microsoft® Windows® Explorer and Microsoft Office. As such, users are immediately comfortable with Microstrategy Desktop. A customized interface using HTML can be created, simplifying navigation, and report execution.
Q45) Can I make my data and graphs look professional?
Ans: Yes. Users can format their data into appealing reports using various formatting styles and graphs for maximum visual impact. Users can choose from more than 30 different charting options to present information in the best layout possible.
Q46) Is it possible to display multiple reports, images, and information on the same page?
Ans: Yes, users can easily combine tables, images, graphs, and other information onto the same page in a document. Visually impressive and compelling documents can be printed out and shared with corporate executives. Business users can now rearrange the organization of any report with simple drag and drop actions or by clicking on the new toolbar icons to get entirely new views of the data, all from the same report and without requiring assistance from IT.
Q47) What printing capabilities are available in Microstrategy Desktop?
Ans: Microstrategy Desktop offers advanced printing capabilities. Features include repeating row/column headers, customizable headers and footers, and a comprehensive page setup menu. Users can preview reports before sending them to the printer.
Q48) What subtotaling features does Microstrategy Desktop contain?
Ans: Microstrategy Desktop has more than 10 different subtotaling functions that aid the analysis of the data. Subtotals can be presented at any level in the rows, columns, and pages on the report.
Q49) What are the minimum requirements for Microstrategy Desktop?
Ans: Minimum requirements are a computer with at least a 450MHZ Pentium- compatible CPU, 256MB of RAM, and 500MB of the hard disk.
Q50) Is Microstrategy Desktop available in other languages?
Ans: Microstrategy Desktop is available in English, French, German, Spanish, Korean, Italian, Swedish, Japanese and Portuguese.
Q51) How long does it take to get Microstrategy Desktop up and running?
Ans: Microstrategy Desktop installs in minutes and automatically presents a list of available Microstrategy Intelligence Servers. Within an hour, the installation and setup are completed.
Q52) How does Microstrategy Desktop integrate with the rest of the Microstrategy platform?
Ans: Microstrategy Desktop is the intuitive client-server interface used by business analysts and application developers. Microstrategy Desktop interacts with the Intelligence Server to build metrics, create and format reports, and retrieve timely, accurate information to the desktop to enhance the decision-making process.
Q53) What security is provided with Microstrategy Desktop?
Ans: Microstrategy Desktop provides a host of security options to ensure that data is kept confidential and private. To facilitate easy deployment and minimal maintenance, Microstrategy Desktop integrates with Windows NT and 2000 security and with Novell directory. As a result, users who have logged into these systems will not need to log on again.
Q54) To what extend can Microstrategy Desktop be personalized?
Ans: Each Microstrategy Desktop user has a security profile defined by their administrator. This profile controls access to application functionality, specific reports or particular data for individual users or groups of users. The Desktop interface will adapt and display only what this user is allowed to see.
Q55) Is the Microstrategy MDX engine certified by SAP?
Ans: Yes. This new Dynamic MDX Engine generates optimized MDX syntax that is fully certified with SAP BW using SAP's high-performance BAPI interfaces.
Q56) Can users join data across SAP BW Info Cubes and Query Cubes?
Ans: Yes. Users can use Microstrategy Desktop to create reports that access SAP data and join data across SAP BW Info Cubes and Query Cubes as well as access multiple instances of SAP BW at once.
Q57) Can Microstrategy Desktop join data across heterogeneous data sources?
Ans: Yes. Microstrategy 8 extends the Microstrategy data modelling flexibility to include integrated views of data across heterogeneous data stores. By mapping conforming dimensions from different sources, Microstrategy Desktop can automatically join data from multiple different sources in the same report document. Data can come from any source accessible by Microstrategy 8, including the data warehouse, data marts, SAP BW, and any number of operational system databases
Q58) Does Microstrategy provide predictive modelling capabilities commonly available in data mining tools?
Ans: Yes. Microstrategy 8 can calculate four of the primary data mining functions including neural network algorithms, clustering algorithms, regression algorithms, and tree algorithms.
Q59) Can Microstrategy incorporate best-of-breed data mining insight into mainstream business reports and analysis?
Ans: Yes. Microstrategy 8 has extended its analytic engine with "Data Mining Services" capability that allows reports and analyses to include predictive capabilities in every Microstrategy report or analysis. Microstrategy 8 includes the new ability to import data mining models directly from best-of-breed data mining products from vendors like IBM, Teradata, SAS, and SPSS using the new PMML or predictive modelling mark-up language standard.
Q60) Can Microstrategy Desktop export data to other software applications?
Ans: You can export information from Microstrategy Desktop to text files, Microsoft Word, Microsoft Excel, Microsoft Access, and HTML files. The formatting of the tables and data is preserved when you export to these file formats.
Q61) What data sources does Microstrategy Desktop support?
Ans: You can access data in all the major databases including Oracle, IBM DB2, Informix, NCR Teradata, Microsoft Access, Microsoft SQL Server, Red Brick, Sybase and Non-Stop SQL.
Q62) To save time, can many reports be run at the same time?
Ans: Microstrategy Desktop can execute multiple reports simultaneously. Report results are saved in a personal History folder when ready.
Q63) Can a report be executed in off-peak periods?
Ans: Reports can be attached to time-based or event-based schedules that are defined by the administrator. These schedules automatically trigger the report execution and place a notification message in the History folder on completion.
Q64) What is Microstrategy OLAP Services?
Ans: Microstrategy OLAP Services is an extension to Microstrategy Intelligence Server that allows Microstrategy Web and Desktop users to manipulate Intelligent Cubes™. With OLAP Services end users can add or remove report objects, add derived metrics and modify the filter -- all with speed-of-thought response time against Intelligent Cubes. OLAP Services enables full multi-dimensional OLAP analysis within Intelligent Cubes while retaining users' ability to seamlessly drill through to the full breadth and depth of the data warehouse.
Q65) What are the Intelligent Cubes used by OLAP Services?
Intelligent Cubes are user or administrator created multi-dimensional cubes that operate within Microstrategy Intelligence Server™. On Microstrategy's BI platform, creating an Intelligent Cube is as easy as creating a report. Intelligent Cubes enable
Microstrategy to combine the speed and interactivity of multi-dimensional OLAP analysis and the analytical power and depth of relational OLAP.
Q66) What specific features and functionality do I get with OLAP Services?
Ans: With OLAP Services Microstrategy Web, Desktop and Office users can:
Create unique report views based on an Intelligent Cube.
With OLAP Services, users can create unique report views by adding or removing attributes and metrics contained within the Intelligent Cube. This allows speed-of-thought report creation and modification with no need to extract data from the data warehouse.
Create new on-the-fly metric calculations from existing metrics in an Intelligent Cube.
The new calculation is performed without submitting a new request to the data warehouse.
Filter their view of the data within an Intelligent Cube.
The filtering will be performed on Microstrategy Intelligence Server within the Intelligent Cube.
Q67) How are Intelligent Cubes different from ordinary cubes?
Ans: Intelligent Cubes are created automatically when a new report is run against the data warehouse. Subsequent requests by other users can seamlessly hit this new Intelligent Cube. The logic to match user requests with the appropriate Intelligent Cube is automatically handled within the Microstrategy platform. Users don't have to specify the cube to which they want to connect.
Benefits of Intelligent Cubes include:
- Greater Efficiency - Intelligent Cubes are automatically generated and shared among all users whenever a report is executed by a user or pre-cached by the administrator or a user.
- Easy to Use - Intelligent Cubes can be designed by mainstream BI users, using the same interface and the same operations as are used with basic OLAP analysis.
- More Scalable Cubes - Intelligent Cubes do not need massive pre-calculations or pre-aggregations. The mid-tier Intelligence Server can do these calculations on-the-fly as the cubes are being used.
- Increased Manageability and Reliability - Intelligent Cubes can be configured to expire or refresh automatically whenever underlying data or definitions change.
- Increased Power for End-Users - Users can seamlessly drill through to the full depth of the data warehouse, or slice and dice with speed-of-thought response time within the Intelligent Cube.
Q68) What end-user products leverage OLAP Services?
Ans: Microstrategy Web (Analyst and Professional versions), Microstrategy Desktop (Analyst and Designer versions), and Microstrategy Office all leverage the functionality enabled by OLAP Services.
Q69) What does an end-user need to do to take advantage of this?
Ans: The usage of OLAP Services is transparent to end-users. Users do not need to know the name and location of an Intelligent Cube, or even if it exists. OLAP Services works with Microstrategy Intelligence Server to automatically use the appropriate Intelligent Cube or create a new one to satisfy the end-user request.
Q70) How is security handled?
Ans: Intelligent Cubes used by OLAP Services automatically inherit all of the security provisions of every report object used within the Intelligent Cube, and those provisions are dynamically applied to each user's security profile when the cube is accessed. If a user only has privileges to use four of the five metrics contained in an Intelligent Cube, that restriction will automatically and seamlessly apply when the user accesses the Intelligent Cube. The user will still have access to the Intelligent Cube for the four metrics he or she has privileges to use.
Q71) Can I access Intelligent Cubes without OLAP Services?
Ans: Yes, with the appropriate version of Microstrategy Web or Desktop, certain functions leverage the Intelligent Cubes. These functions include: report formatting down to cell level, column aliasing, drilling, pivoting, page-by, adding metric thresholds, adding subtotals, ranking and sorting. Please see the Web and Desktop version comparisons to determine exactly which Web or Desktop version includes the desired functionality.
Q72) Is OLAP Services sold as a separate product?
Ans: Yes, OLAP Services is sold as a separate product that is installed with Microstrategy Intelligence Server. It is licensed either on a per-user or per-CPU basis.
Q73) What is Microstrategy Narrowcast Server?
Ans: Microstrategy Narrowcast Server is a software product that monitors and delivers individualized information to users via email, web portals, and wireless devices such as PDAs, pagers, and phones. Through an easy-to-use web page, users specify what information they want, when, and how they want to receive it.
Q74) What are the business benefits of Microstrategy Narrowcast Server?
Ans: Microstrategy Narrowcast Server provides an easy and inexpensive way to send corporate information to untrained employees, partners, and customers. As a result, decision-makers have the information they need to maximize revenue generation and streamline business processes that cut operating costs.
Q75) What kinds of applications can Microstrategy Narrowcast Server support?
Ans: Microstrategy Narrowcast Server supports enterprise reporting applications, executive information portals, corporate information dissemination, sale force automation, working capital management, supply chain management, extranet portals, secure business to business portals, customer service applications, and intelligent alerting applications.
Q76) Why do businesses need to send information out to users proactively?
Ans: People do not have time to search through information to identify information that requires immediate action. An intelligent alerting system understands and constantly monitors the information users need and delivers information only when users need it. Users save time and take action when required.
Q77) How do current Microstrategy Narrowcast Server customers use Intelligent Alerting?
Ans: Customers use Microstrategy Narrowcast Server to deliver inventory alerts, business performance alerts, supply chain alerts, customer activity alerts, stock, and personal finance alerts, last-minute travel alerts, data load alerts, customer account activity alerts, and fraud alerts. New uses are constantly being developed for intelligent alerting.
Q78) How do users receive only the information that they want?
Ans: Through an easy-to-use subscription web page, users specify what information they want. Some personalization options include language choices and specific information criteria such as certain products. Using this user profile, Microstrategy Narrowcast Server sends only the information that the user has requested.
Q79) Can users turn off the information delivery?
Ans: Yes, users can switch on and off their own information delivery. Administrators can also set up some ‘non-optional’ information delivery so that everyone receives the information. As a result, users can obtain information without having to wait for IT to develop the reports.
Q80) What kinds of information can users receive?
Ans: Users can receive both tables and charts from the Microstrategy platform, and content from current information sources such as transaction processing systems, Enterprise Resource Planning systems, databases, XML files, and web servers.
Q81) What formatting can be applied to the information that is sent out by Microstrategy Narrowcast Server?
Ans: Information can be formatted into HTML, plain text, Microsoft® Excel, or PDF files. The size and display of these files are adjusted to suit the email type or the wireless device for different users.
Q82) To which devices can Microstrategy Narrowcast Server deliver information?
Ans: Narrowcast Server can deliver information to email, mobile phones, pagers, faxes, PDAs, intranet, and extranet web portals. Businesses can also build and plug in their own Information Transmission Module to support their own devices.
Q83) How does the Microstrategy Narrowcast Server support enterprise-wide mission-critical applications?
Ans: Microstrategy Narrowcast Server's world-class clustering and fail-over ensure support for mission-critical 24x7 systems. Rigorous in-house testing has proven that Narrowcast Server can personalize and deliver millions of messages a day. The system tracks fail-over down to each message.
- What is a fact constellation schema?
- What is star schema?
- What is the snowflake schema?
- What is a surrogate key?
- Why do we use a staging area?
- Why do we need a DW?
- How much history should we have in a DW?
- What are the most important tables in a DW?
- Why Kimball? Why not Inmon? Or vice versa?
- Performance with a relational based query vs dimensional?
- What schema is used in your project? Why?
- What are conformed dimensions?
- General Knowledge (Applies to all roles)
- What is metadata?
- What is a two-tier connection?
- What is a three-tier connection?
- What is the difference between 2, 3, and 4 tier connections?
- How do you achieve schema object version control (similar to VSS)?
- What are the different kinds of objects in MicroStrategy?
- What’s the fact table?
- Where is the Administrator’s password stored? Is it stored in encrypted?
- Why do we use dimensional modelling in DW? Why not Relational?
- What is a batch?
- Differences between ROLAP, MOLAP, and HOLAP?
- What is ETL?
- What types of DW’s are most common?
- How many MSTR projects have you worked with?
- What are the types of MSTR objects available?
- Explain the step-by-step technical approach after you get the Requirements from the Client.
- What’s a System call error? Have you seen the Object variable error?
- Have you ever manually edited the metadata? why?
- Should you have dated as ID attribute form?
- What is the compound key?
- What are a fact and an attribute?
- What are the Factless facts?
- What are Transformations? Are there any transformations implemented in your project?
- Explain Fact Structure(types, one by one)
- Explain Level Extension. How it is used in your project?
- Explain Fact Relation.
- Explain Fact Degradation.
- What is Compound Key Attribute? Give example from your project.
- Can you update a table in Warehouse using MicroStrategy?
- How will you resolve an issue when (by chance) an aggregate table at higher level has a higher LTS than an aggregate table at lower level?
- What happens if LTS is high for a higher level table?
- What are the criteria used by the MicroStrategy SQL Engine to build the join tree of a report’s SQL?
- Can MicroStrategy's logical primary keys and the true (warehouse) primary keys differ?
- Does Oracle have a pseudo column named ROWID which is not “directly” exposed to the front-end? Can this table be used in MicroStrategy? Why one would do that?
- Can you create Schema objects in 2 tier connection? Is it recommended?
- What is the difference between the RW document and the HTML document?
- What’s a smart metric?
- What is a bridge/relationship table?
- How will you resolve double-counting in the M-M relationship between two attributes?
- What is a CUBE?
- What are the differences between the View Filter and Report Filter?
- What are the different types of Filters available? Explain each with an example.
- What are the derived metrics? Explain the example from your project.
- What are Prompted Filters or cascaded prompts?
- How will you customize the display for Null Values?
- Can you enable/disable the thresholds based on some condition/prompt answers?
- In a Document, there are 5 reports, and 5 out of them need to have a prompt so that
- 10 user can select the first day of the week for which user want to execute the report.
- How many prompts would be required to be made?
- What’s XML Cache?
- What’s a Bulk export report?
- Can you have a prompt in free form SQL report?
- What will happen when the network connection between the web server and one of the
- clustered I-server is lost? Will the report run smoothly?
- Can you prioritize report execution?
- What is ScanMD?
- What is MD Doctor?
- What is clustering?
- How will you reset the password of all users?
- What are the different modes you can run I-Server?
- 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?
- What are the various authentication modes?
- How can you configure WH authentication?
- Does DLS affect MicroStrategy? What do you need to do to incorporate it?
- What is Object Manager?
- What will you do when I-Server crashes?
- What will you do if your Administrator has forgotten a password or the account is locked?
- How can you monitor the error received while running I-Server and report?
- Attribute role, Security role, Security filter, and Access control?
- How to create an event-based schedule?
- Can MicroStrategy be installed on Solaris or UNIX w/o Root access? Can such a server be (re)started?
- If you have a Quad-core CPU and MSTR license to use CPUs, can you set to use two particular cores dedicatedly for I-Server (As other core may have been programmed for some other dedicated work) Drawbacks on 4GT switch?
- Can you cap the number of reports run at a time by users? What happens when this limit is breached?
- Can you somehow disable Web users to use only one I-Server?
- Can you make a floating window in MicroStrategy Web?
- How do have two images on the MicroStrategy login page?
- Can you apply themes to MicroStrategy Web? How to create a one?
- After a bulk export report is run, NCS puts it on an ftp location? Can this location be directly made available on the MSTR web?
For an in-depth understanding of MicroStrategy click on