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 for - Initially populating the Metadata - Creating schema objects






2. The unique values of an attribute obtained from the data-warehouse






3. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View






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






5. The actual column name for a fact. Every fact must have at least 1 expression.






6. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report






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






8. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics






9. Extraction - transformation - loading






10. Enables you to lock column headers so that they always appear when scrolling






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






12. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)






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






14. Grid View - Graph View - Grid/Graph View - SQL View






15. A method of organizing the appearance of report results in a Grid report based on a criteria






16. Simple - Compound - Nested - Derived






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






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






19. A shortcut to an existing Object in a Project






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






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






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






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






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






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






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






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






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






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






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






31. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.






32. Columns - Tables






33. It contains the ID column of the parent attribute






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






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






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






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






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






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






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






41. Specifies what info to retrieve from a data-warehouse - and how to display it






42. OLTP retains data ________






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






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






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






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






47. All report-level options overwrite ___________.






48. Compound - Homogeneous - Heterogeneous






49. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships






50. OLAP data storage measure