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. Simple - Derived






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






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






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






5. View Filters are saved with the _____________.






6. It contains links to specific folders in the Folder List






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






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






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






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






11. Columns - Tables






12. OLTP retains data ________






13. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






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






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






16. It contains the ID column of the parent attribute






17. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






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






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






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






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






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






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






24. Level of OLAP integration






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






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






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






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






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






30. Tables - Facts - Attributes - Hierarchies






31. User management - Security profiles - Server parameters - like report length - idle time and report prioritization






32. Template - Filter - View of a Report






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






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






35. View Filters can only ___________.






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. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts






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






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






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






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






42. You can e-mail reports by going to _____






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






44. Folder List - Object Viewer - Shortcut Bar






45. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.






46. A development environment to create BI applications - allowing users to edit the Metadata database






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






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






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






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