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. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema






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






3. The default entry-points.






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






5. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






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






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






8. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts






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






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






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






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






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






14. Extraction - transformation - loading






15. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts






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






17. Metrics you create within a report using only those objects in the report.






18. Creating multiple attributes quickly. Used during the initial project creation.






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






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






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






22. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression






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






24. OLAP Services does not add any ______ to the report query.






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






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






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






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






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






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






31. AND - OR - OR NOT - AND NOT






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






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






34. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner






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






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






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






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






39. Used to modify a Report






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






41. Compound - Homogeneous - Heterogeneous






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






43. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell






44. Create the Project Source - Create the Database Instance






45. Used to "fine-tune" your Project






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






47. Reduced number of JOINS in the generated SQL






48. The System Hierarchy is automatically updated whenever you make a change to an __________________.






49. Level of OLTP integration






50. Grid View - Graph View - Grid/Graph View - SQL View