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. Facts - Attributes - Hierarchies






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






3. ID columns - Description columns - Fact columns






4. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)






5. Enables you to format report values based on a condition - such as highlights - font colors - etc.






6. Folder List - Object Viewer - Shortcut Bar






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






8. View Filters are saved with the _____________.






9. Homogeneous - Heterogeneous






10. Descriptive data that provides context for Facts.






11. Compound - Homogeneous - Heterogeneous






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






13. Extraction - transformation - loading






14. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)






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






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






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






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






19. You can _____________ in the Architect Graphical Interface.






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






21. A shortcut to an existing Object in a Project






22. Simple - Derived






23. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)






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






25. Level of OLAP integration






26. Level of OLTP integration






27. Reduced number of JOINS in the generated SQL






28. Primary keys






29. User management - Security profiles - Server parameters - like report length - idle time and report prioritization






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






31. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked






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






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






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






35. Grid View - Graph View - Grid/Graph View - SQL View






36. OLTP data storage measure






37. User reporting requirements - Query performance - Data volume - DB Maintenance






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






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






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






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






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






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






44. You must select "Other directions" when drilling attributes while viewing a report






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






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






47. Columns - Tables






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






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






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