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. It contains the ID column of the parent attribute






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






3. Tables - Facts - Attributes - Hierarchies






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






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






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






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






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






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






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






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






12. Allow you to interact with the BI system - logically organize data to analyze complex relationships






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






14. Simple - Derived






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






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






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






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






19. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships






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






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






22. A user interface for creating and maintaining a BI environment






23. A shortcut to an existing Object in a Project






24. Template - Filter - View of a Report






25. A subset of a report that users can manipulate without altering the SQL


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






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






28. Compound - Homogeneous - Heterogeneous






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






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






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






32. View Filters can only ___________.






33. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.






34. Used to modify a Report






35. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report






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






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






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






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






40. ID columns - Description columns - Fact columns






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






42. Schema Objects - Application Objects - Configuration Objects






43. Descriptive data that provides context for Facts.






44. Must have Subtotals enabled - or you won't see any data for higher-level attributes






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






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






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






48. Used to "fine-tune" your Project






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






50. Folder List - Object Viewer - Shortcut Bar