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. User requirements - Existing source data - Technical and performance considerations






2. Facts - Attributes - Hierarchies






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






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






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






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






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






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






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






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






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






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






13. A feature that enables users to delivers reports to the history list - cache or mobile






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






15. Level of OLTP integration






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






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






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






19. Simple - Compound - Nested - Derived






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






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






22. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).






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






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






25. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound






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






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






28. Level of OLAP integration






29. Homogeneous - Heterogeneous






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






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






32. Used to "fine-tune" your Project






33. AND - OR - OR NOT - AND NOT






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






35. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations






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






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






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






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






40. View Filters are saved with the _____________.






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






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






43. Extraction - transformation - loading






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






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






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






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






48. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents






49. View Filters can only ___________.






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