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. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)






2. Tables - Facts - Attributes - Hierarchies






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






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






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






6. Level of OLTP integration






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






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






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






10. ID columns - Description columns - Fact columns






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






12. Schema Objects - Application Objects - Configuration Objects






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






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






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






16. Subtotals reflect accumulations at selected attribute levels






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






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






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






20. Template - Filter - View of a Report






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






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






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






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






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






26. Enables you to select and display subsets of a report as separate pages.






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






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






29. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.






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






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






32. Descriptive data that provides context for Facts.






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






34. View Filters can only ___________.






35. Primary keys






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






37. OLAP data storage measure






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






39. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies






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






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






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






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






44. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






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






46. You can _____________ in the Architect Graphical Interface.






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






48. The System Hierarchy is automatically updated whenever you make a change to an __________________.






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






50. A shortcut to an existing Object in a Project