Getting people excited about their data one visual at a time™

Interview Questions

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 […]

Question Which of the following is possible only when History List messages are stored in a database? A. History List Messages are available in a two-tier environment. B. When deleting History List messages using a schedule, a single session is created on the Intelligence Server. C. History List messages can be shared across cluster nodes. […]

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 Which of the following options in the Warehouse Tables pane would you use to view the first 100 rows of data in a table? A. Show Table Structure B. Show Top 100 Rows C. Show Sample Data D. Select Database Instance E. You cannot accomplish this in the Warehouse Tables pane. Answer C. Show […]