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

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.