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. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data






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






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






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






5. Enables you to select which tables from the data-warehouse to store in the Metadata database






6. Facts - Attributes - Hierarchies






7. You can _____________ in the Architect Graphical Interface.






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






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






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






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






12. Using the Prompt Generation Wizard - Inside the Report Editor






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






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






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






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






17. Descriptive data that provides context for Facts.






18. Extraction - transformation - loading






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






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






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






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






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






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






25. A shortcut to an existing Object in a Project






26. OLTP data storage measure






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






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






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






30. All Attributes must have an _______.






31. Tables - Facts - Attributes - Hierarchies






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






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






34. You must select "Other directions" when drilling attributes while viewing a report






35. Used for - Initially populating the Metadata - Creating schema objects






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






37. View Filters can only ___________.






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






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






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






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






42. A development environment to create BI applications - allowing users to edit the Metadata database






43. It contains the ID column of the parent attribute






44. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.






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






46. OLAP retains data ________






47. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form






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






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






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