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. A shortcut to an existing Object in a Project






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






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






4. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






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






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






7. OLAP retains data ________






8. Folder List - Object Viewer - Shortcut Bar






9. OLAP data storage measure






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. It contains links to specific folders in the Folder List






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






13. Attribute Creation Wizard - Attribute Editor






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






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






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






17. All report-level options overwrite ___________.






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






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






20. Schema Objects - Application Objects - Configuration Objects






21. Tables - Facts - Attributes - Hierarchies






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






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






24. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts






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






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






27. Metrics aggregate on the lowest-level attribute __________.






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






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






30. The actual column name for a fact. Every fact must have at least 1 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. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform






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






34. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending






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






36. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound






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






38. Descriptive data that provides context for Facts.






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






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






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






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






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






44. Used to "fine-tune" your Project






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






46. Used to modify a Report






47. Simple - Derived






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






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






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