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. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.






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






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






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






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






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






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






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






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






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






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






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






13. The Attribute Form maps to the same column name in multiple tables






14. Template - Filter - View of a Report






15. Homogeneous - Heterogeneous






16. Simple - Compound - Nested - Derived






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






18. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View






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






20. Schema Objects - Application Objects - Configuration Objects






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






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






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






24. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded






25. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling






26. The default entry-points.






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






28. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen






29. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field






30. Columns - Tables






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. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications






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






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






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






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






37. Used to "fine-tune" your Project






38. It contains the ID column of the parent attribute






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






40. You can _____________ in the Architect Graphical Interface.






41. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format






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






43. OLTP retains data ________






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






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






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






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






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






49. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships






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