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. A method of organizing the appearance of report results in a Grid report based on a criteria






2. Less storage - Simple SQL - Complex ETL






3. Columns - Tables






4. AND - OR - OR NOT - AND NOT






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






6. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






7. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters






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






9. OLTP retains data ________






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






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






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






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






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






15. Simple - Derived






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






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






18. Template - Filter - View of a Report






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






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






21. Primary keys






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






23. OLAP retains data ________






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






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






26. Enables you to search for a specific Object or group of Objects that meet a certain criteria.






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






28. Must have a one-to-one relationship with all other forms.






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






44. All Attributes must have an _______.






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






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






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






48. More storage - Complex SQL - Simple ETL






49. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier






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