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. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






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






3. Simple - Compound - Nested - Derived






4. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.






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






6. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling






7. What tool do you use to create the Metadata DSN connection?






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






9. ID columns - Description columns - Fact columns






10. OLTP data storage measure






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






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






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






14. It contains the ID column of the parent attribute






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






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






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






18. Facts associated to different column names in 2 or more tables






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






20. Schema Objects - Application Objects - Configuration Objects






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






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






23. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)






24. Less storage - Simple SQL - Complex ETL






25. Extraction - transformation - loading






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






27. Folder List - Object Viewer - Shortcut Bar






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






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






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






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






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






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






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






35. The default entry-points.






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






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






38. Create the Project Source - Create the Database Instance






39. Level of OLAP integration






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






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






42. The Attribute Form Expression that maps to a single column - no matter the number of tables






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






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






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






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






47. Specifies a condition data must meet in order to be included in a report






48. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships






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






50. You can _____________ in the Architect Graphical Interface.