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. More storage - Complex SQL - Simple ETL






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






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






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






5. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling






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






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






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






9. All report-level options overwrite ___________.






10. Store info about attributes - including IDs and any descriptions. Used for easier browsing.






11. Reduced number of JOINS in the generated SQL






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






13. OLAP retains data ________






14. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data






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






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






17. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.






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






19. Attribute Creation Wizard - Attribute Editor






20. Create the Project Source - Create the Database Instance






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






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






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






24. User reporting requirements - Query performance - Data volume - DB Maintenance






25. Template - Filter - View of a Report






26. Metrics aggregate on the lowest-level attribute __________.






27. An environment in which the MSTR Desktop connects directly to the Metadata database.






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






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






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






31. Columns - Tables






32. Folder List - Object Viewer - Shortcut Bar






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






34. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy






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






36. Primary keys






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






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






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






40. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.






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






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






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






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






45. MS Excel - MS Word - MS Access - PDF - HTML - Plain text






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






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






48. View Filters are saved with the _____________.






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






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