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. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






2. To define the level of aggregation for a specific metric - Used for qualifications






3. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types






4. Simple - Compound - Nested - Derived






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






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






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






8. Template - Filter - View of a Report






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






10. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression






11. Extraction - transformation - loading






12. Homogeneous - Heterogeneous






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






14. 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






15. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.






16. More storage - Complex SQL - Simple ETL






17. Direct: 2-tier - Server: 3-tier






18. AND - OR - OR NOT - AND NOT






19. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.






20. You can _____________ in the Architect Graphical Interface.






21. View Filters are saved with the _____________.






22. User requirements - Existing source data - Technical and performance considerations






23. Specifies what info to retrieve from a data-warehouse - and how to display it






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






25. Enables you to select and display subsets of a report as separate pages.






26. Used to modify a Report






27. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).






28. A condition data must meet in order to be included in a report. Does affect the SQL.






29. Top menu/dropdowns - Toolbar - Right-click popup menus






30. Filter definition prompts - Object prompts - Value prompts - Level prompts






31. Create the Project Source - Create the Database Instance






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






33. Reduced number of JOINS in the generated SQL






34. Compound - Homogeneous - Heterogeneous






35. 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.






36. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.






37. OLAP data storage measure






38. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents






39. Specifies a condition data must meet in order to be included in a report






40. It contains the ID column of the parent attribute






41. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy






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






43. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse






44. A development environment to create BI applications - allowing users to edit the Metadata database






45. Metrics you create within a report using only those objects in the report.






46. Facts - Attributes - Hierarchies






47. A new tool for project design tasks - used for fine-tuning a project after initial creation






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






49. How users can share comments for reports to other users






50. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded