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. The Attribute Form Expression that maps to a single column - no matter the number of tables






2. It contains the ID column of the parent attribute






3. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters






4. More storage - Complex SQL - Simple ETL






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






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






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






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






9. The Attribute Form maps to different column names in multiple tables






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






11. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






12. Columns - Tables






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






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






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






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






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






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






19. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field






20. Homogeneous - Heterogeneous






21. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format






22. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations






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






24. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






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






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






27. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions






28. Subtotals reflect accumulations at selected attribute levels






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






30. Template - Filter - View of a Report






31. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)






32. Schema Objects - Application Objects - Configuration Objects






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






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






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






36. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h






37. Enables you to lock column headers so that they always appear when scrolling






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. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






40. Store info about attributes - including IDs and any descriptions. Used for easier browsing.






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






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






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






44. What tool do you use to create the Metadata shell?






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






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






47. Enables you to search for a specific Object or group of Objects that meet a certain criteria.






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






49. You must select "Other directions" when drilling attributes while viewing a report






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