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. To see data at completely different levels - other than that of the original Grid or Graph






2. Primary keys






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






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






5. Level of OLTP integration






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






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






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






9. Descriptive data that provides context for Facts.






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






11. Extraction - transformation - loading






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






13. Create the Project Source - Create the Database Instance






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






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






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






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






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






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






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






21. OLAP retains data ________






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






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






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






25. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications






26. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






27. Homogeneous - Heterogeneous






28. What tool do you use to create the Metadata DSN connection?






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






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






31. All report-level options overwrite ___________.






32. Tables - Facts - Attributes - Hierarchies






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






34. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports






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






36. Used to "fine-tune" your Project






37. Enables you to rearrange the columns and rows in a report.






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






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






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






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






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






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






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






45. You can _____________ in the Architect Graphical Interface.






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






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






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






49. Reduced number of JOINS in the generated SQL






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