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. Grid View - Graph View - Grid/Graph View - SQL View






2. OLTP data storage measure






3. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell






4. Used to "fine-tune" your Project






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






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






7. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






8. Compound - Homogeneous - Heterogeneous






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






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






11. Subtotals reflect accumulations at selected attribute levels






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






13. MS Excel - MS Word - MS Access - PDF - HTML - Plain text






14. Used to create or edit complex attributes - facts - hierarchies - and logical tables






15. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts






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






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






18. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...






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






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






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. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)






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






24. It contains links to specific folders in the Folder List






25. Tables - Facts - Attributes - Hierarchies






26. Facts associated to different column names in 2 or more tables






27. Facts associated to the same column name in 1 or more tables






28. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)






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






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






31. Store info on relationships between 2 or more tables (attributes) - like an Index table.






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






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






34. The logical associations between attributes that exist based on a business rule






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






36. The actual column name for a fact. Every fact must have at least 1 expression.






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






38. Enables you to format report values based on a condition - such as highlights - font colors - etc.






39. OLAP data storage measure






40. It creates the System Hierarchy - when you define Attributes and their corresponding relationships






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






42. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier






43. It contains the ID and DESC columns of all higher-level attributes






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






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






46. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)






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






48. Reduced number of JOINS in the generated SQL






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






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