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. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition






2. More storage - Complex SQL - Simple ETL






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






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






5. Attribute Creation Wizard - Attribute Editor






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






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






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






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






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






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






12. Subtotals reflect accumulations at selected attribute levels






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






14. Used to limit a possibly overwhelming set of potential prompt answers






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






16. A shortcut to an existing Object in a Project






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






18. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics






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






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






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






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






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






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






25. Template - Filter - View of a Report






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






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






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






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






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






31. View Filters are saved with the _____________.






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






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






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






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






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






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






38. Folder List - Object Viewer - Shortcut Bar






39. You can e-mail reports by going to _____






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






41. It contains the ID and DESC columns of all higher-level attributes






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






43. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






44. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations






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






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






47. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities






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






49. One that uses 2 or more columns as its ID






50. Extraction - transformation - loading