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. You must select "Other directions" when drilling attributes while viewing a report






2. Filter definition prompts - Object prompts - Value prompts - Level prompts






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






4. To see data at completely different levels - other than that of the original Grid or Graph






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






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






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






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






9. You can _____________ in the Architect Graphical Interface.






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






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






12. Primary keys






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






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






15. Create the Project Source - Create the Database Instance






16. Level of OLTP integration






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






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






19. Descriptive data that provides context for Facts.






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






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






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






23. OLTP retains data ________






24. Compound - Homogeneous - Heterogeneous






25. Folder List - Object Viewer - Shortcut Bar






26. Reduced number of JOINS in the generated SQL






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






28. All report-level options overwrite ___________.






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






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






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






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






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






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






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






36. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending






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






38. A method of organizing the appearance of report results in a Grid report based on a criteria






39. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.






40. Used to create or edit complex attributes - facts - hierarchies - and logical tables






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






42. Tables - Facts - Attributes - Hierarchies






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






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






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






46. The logical associations between attributes that exist based on a business rule






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






48. Template - Filter - View of a Report






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






50. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema