Readers:Today, I am featuring an interview with Filippo Mastroianni. Filippo was born in Milan, Italy. He is a Data Analyst and Consultant for The Information Lab Italy. Filippo helps organizations make data-driven decisions, helping clients make sense of their data and embracing a new analytical culture. Filippo graduated with a thesis on Data Journalism and discovered […]
Readers: To make it easier to find all of the MicroStrategy Interview Questions I posted, I have added a new page that contains a quick reference to all of them (see screenshot below). I will update this page after every five new interview questions have been added. Best Regards, Michael
Question Which of the following VLDB properties govern the length of a SQL string as well as the time a SQL pass takes to execute? (Select all that apply). A. SQL Time Out (Per Pass) B. Preserve All Lookup Table Elements C. Result Set Row Limit D. Maximum SQL/MDX Size E. Allow Index on Metric […]
Question Which of the following issues can result from many-to-many relationships? A. Exclusion of some attribute elements when drilling B. Multiple join paths to fact tables C. Missing values on reports including all attributes from the hierarchy D. Multiple counting when aggregating data from base fact tables E. Lost analytical capability Answer Both D. Multiple counting […]
Question As a MicroStrategy developer, you are constantly using Object Manager to migrate objects that you develop inside the Subject Areas folder in your project. To save time, what object can you create to enable you to go straight to this folder when you open Object Manager? A. Layout B. Project Source C. Script D. […]
Question If you want to analyze the average length of time users must wait for their documents or reports to process, as well as the number of errors that were received in Enterprise Manager, which area of analysis would enable you to track this information? A. Performance Analysis B. Operations Analysis C. Real-Time Analysis D. […]
Question Which type of Slowly Changing Dimension (SCD) would you use if your data was time dependent and you do not require historical comparisons? A. Like vs. Like B. As Is vs. As Was (Type II) C. As Is vs. As Is (Type I) D. As Is vs. As Was Answer C. As Is vs. […]
Question Can you always convert a consolidation to a custom group and vice versa? Answer You can always convert a consolidation to a custom group, but you can only convert a custom group to a consolidation when the custom group filters are from the same table or very similar tables.