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. Used to create or edit complex attributes - facts - hierarchies - and logical tables






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






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






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






5. ID columns - Description columns - Fact columns






6. Less storage - Simple SQL - Complex ETL






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






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






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






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






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






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






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






14. Contains info that facilitates the transfer of data from the source systems to the data-warehouse






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






16. OLAP data storage measure






17. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations






18. Schema Objects - Application Objects - Configuration Objects






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






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






21. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.






22. A shortcut to an existing Object in a Project






23. Create the Project Source - Create the Database Instance






24. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports






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






26. What tool do you use to create the Metadata shell?






27. More storage - Complex SQL - Simple ETL






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






29. View Filters are saved with the _____________.






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






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






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






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






34. Compound - Homogeneous - Heterogeneous






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






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






37. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending






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






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






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






41. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions






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






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






44. Descriptive data that provides context for Facts.






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






46. Facts - Attributes - Hierarchies






47. Subtotals reflect accumulations at selected attribute levels






48. Direct: 2-tier - Server: 3-tier






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






50. Filter definition prompts - Object prompts - Value prompts - Level prompts