Test your basic knowledge |

Certified Project Designer Cpd

Instructions:
  • Answer 50 questions in 15 minutes.
  • If you are not ready to take this test, you can study here.
  • Match each statement with the correct term.
  • Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.

This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition






2. Extraction - transformation - loading






3. User reporting requirements - Query performance - Data volume - DB Maintenance






4. The Attribute Form maps to the same column name in multiple tables






5. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form






6. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View






7. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling






8. A feature that enables users to delivers reports to the history list - cache or mobile






9. Attribute Creation Wizard - Attribute Editor






10. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.






11. You can e-mail reports by going to _____






12. The Attribute Form Expression that maps to a single column - no matter the number of tables






13. Descriptive data that provides context for Facts.






14. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)






15. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.






16. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






17. A subset of a report that users can manipulate without altering the SQL

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


18. Primary keys






19. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner






20. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications






21. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations






22. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities






23. Metrics that perform multiple aggregations; one calculation inside of another.






24. Enables you to select which tables from the data-warehouse to store in the Metadata database






25. Using the Prompt Generation Wizard - Inside the Report Editor






26. Used to limit a possibly overwhelming set of potential prompt answers






27. It contains the ID column of all higher-level attributes






28. An environment in which the MSTR Desktop connects directly to the Metadata database.






29. To see data at completely different levels - other than that of the original Grid or Graph






30. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.






31. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.






32. The System Hierarchy is automatically updated whenever you make a change to an __________________.






33. Prompts to select a single value on which to qualify a date - number or text string.






34. A Project Source can house ________ . A single Metadata can be used by multiple Projects.






35. Level of OLAP integration






36. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.






37. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.






38. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts






39. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View






40. A method of organizing the appearance of report results in a Grid report based on a criteria






41. OLTP data storage measure






42. OLTP retains data ________






43. A shortcut to an existing Object in a Project






44. It contains the ID column of the parent attribute






45. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.






46. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






47. More storage - Complex SQL - Simple ETL






48. All Attributes must have an _______.






49. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked






50. Subtotals reflect accumulations at selected attribute levels