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. OLTP data storage measure






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






3. Creating multiple attributes quickly. Used during the initial project creation.






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






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






6. Used to modify a Report






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






8. Primary keys






9. The unique values of an attribute obtained from the data-warehouse






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






11. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition






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






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






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






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






16. A shortcut to an existing Object in a Project






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






18. You can _____________ in the Architect Graphical Interface.






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






20. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns






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






22. It contains the ID column of the parent attribute






23. Reduced number of JOINS in the generated SQL






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






25. Groupings of directly related attributes. Also commonly known as "dimensions".






26. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data






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






28. Extraction - transformation - loading






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






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






31. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.






32. Contains info that facilitates the transfer of data from the source systems to the data-warehouse






33. Schema Objects - Application Objects - Configuration Objects






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






35. Used for - Initially populating the Metadata - Creating schema objects






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






37. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen






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






39. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships






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






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






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






43. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save






44. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform






45. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.






46. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.






47. Must have a one-to-one relationship with all other forms.






48. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.






49. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar






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