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. Metrics aggregate on the lowest-level attribute __________.






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






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






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






5. Compound - Homogeneous - Heterogeneous






6. Used to "fine-tune" your Project






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






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






9. Level of OLAP integration






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






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






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






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






14. A new tool for project design tasks - used for fine-tuning a project after initial creation






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






16. Simple - Derived






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






18. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data






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






20. You can _____________ in the Architect Graphical Interface.






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






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






23. View Filters can only ___________.






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






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






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






27. Facts associated to different column names in 2 or more tables






28. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.






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






30. Simple - Compound - Nested - Derived






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






32. OLAP retains data ________






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






34. Create the Project Source - Create the Database Instance






35. Formula - Level (Dimensionality) - Conditionality - Transformation






36. Enables you to select which tables from the data-warehouse to store in the Metadata database






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






38. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data






39. Facts - Attributes - Hierarchies






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






41. AND - OR - OR NOT - AND NOT






42. Extraction - transformation - loading






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






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






45. OLAP data storage measure






46. It contains the ID column of the parent attribute






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






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






49. All Attributes must have an _______.






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