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 simplified version of Desktop - providing interactive "slice-&-dice" capabilities






2. Used to modify a Report






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






4. Extraction - transformation - loading






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






6. Create the Project Source - Create the Database Instance






7. Primary keys






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






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






10. ID columns - Description columns - Fact columns






11. View Filters can only ___________.






12. Columns - Tables






13. Simple - Derived






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






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






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






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






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






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






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






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






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






23. Tables - Facts - Attributes - Hierarchies






24. A user interface for creating and maintaining a BI environment






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






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






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






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






29. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.






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






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






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






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






34. You can _____________ in the Architect Graphical Interface.






35. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types






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






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






38. Facts - Attributes - Hierarchies






39. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.






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






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






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






43. Template - Filter - View of a Report






44. OLTP retains data ________






45. Folder List - Object Viewer - Shortcut Bar






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






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






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






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






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