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 detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






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






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






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






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






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






7. To see data at completely different levels - other than that of the original Grid or Graph






8. All report-level options overwrite ___________.






9. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






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






11. OLTP retains data ________






12. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data






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






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






15. Extraction - transformation - loading






16. Grid View - Graph View - Grid/Graph View - SQL View






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






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






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






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






21. OLAP retains data ________






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






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






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






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






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






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






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






29. Reduced number of JOINS in the generated SQL






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






31. Facts - Attributes - Hierarchies






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






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






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






35. The logical associations between attributes that exist based on a business rule






36. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.






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






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






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






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






41. View Filters are saved with the _____________.






42. Used to modify a Report






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






44. Simple - Derived






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






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






47. Create the Project Source - Create the Database Instance






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






49. OLTP data storage measure






50. AND - OR - OR NOT - AND NOT