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. Must have Subtotals enabled - or you won't see any data for higher-level attributes






2. Descriptive data that provides context for Facts.






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






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






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






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






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






8. ID columns - Description columns - Fact columns






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






10. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.






11. One that uses 2 or more columns as its ID






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






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






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






15. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression






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






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






18. You can _____________ in the Architect Graphical Interface.






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






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






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






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






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






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






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






26. Create the Project Source - Create the Database Instance






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






28. All report-level options overwrite ___________.






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






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






31. Facts - Attributes - Hierarchies






32. Homogeneous - Heterogeneous






33. Less storage - Simple SQL - Complex ETL






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






35. OLAP data storage measure






36. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner






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






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






39. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies






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






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






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






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






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






45. OLTP data storage measure






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






47. All Attributes must have an _______.






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






49. Attribute Creation Wizard - Attribute Editor






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