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. Direct: 2-tier - Server: 3-tier






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






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






4. Folder List - Object Viewer - Shortcut Bar






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






6. A new tool for project design tasks - used for fine-tuning a project after initial creation






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






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






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






10. All Attributes must have an _______.






11. OLAP retains data ________






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






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






14. You can _____________ in the Architect Graphical Interface.






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






16. Metrics that perform multiple aggregations; one calculation inside of another.






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






18. The System Hierarchy is automatically updated whenever you make a change to an __________________.






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






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






21. All report-level options overwrite ___________.






22. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier






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






24. Schema Objects - Application Objects - Configuration Objects






25. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform






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






27. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities






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






29. Columns - Tables






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






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






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






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






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






35. The default entry-points.






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






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






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






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






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






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






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






43. Tables - Facts - Attributes - Hierarchies






44. View Filters can only ___________.






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






46. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters






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






48. Grid View - Graph View - Grid/Graph View - SQL View






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






50. Must have a one-to-one relationship with all other forms.