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. The unique values of an attribute obtained from the data-warehouse






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






3. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar






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






5. Tables - Facts - Attributes - Hierarchies






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






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






8. OLTP retains data ________






9. All report-level options overwrite ___________.






10. Top menu/dropdowns - Toolbar - Right-click popup menus






11. OLAP retains data ________






12. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.






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






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






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






16. Less storage - Simple SQL - Complex ETL






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






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






19. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.






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






21. Primary keys






22. MS Excel - MS Word - MS Access - PDF - HTML - Plain text






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






24. Used to modify a Report






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






26. View Filters are saved with the _____________.






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






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






29. Compound - Homogeneous - Heterogeneous






30. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data






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






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






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






34. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h






35. Level of OLTP integration






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






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






38. Used to "fine-tune" your Project






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






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






41. Descriptive data that provides context for Facts.






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






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






44. Simple - Compound - Nested - Derived






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






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






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






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






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






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