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. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts






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






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






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






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






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






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






8. Less storage - Simple SQL - Complex ETL






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






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






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






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






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






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






15. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View






16. Columns - Tables






17. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.






18. A shortcut to an existing Object in a Project






19. A Project Source can house ________ . A single Metadata can be used by multiple Projects.






20. More storage - Complex SQL - Simple ETL






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






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






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






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






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






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






27. Simple - Derived






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






29. Tables - Facts - Attributes - Hierarchies






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






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






32. Used to "fine-tune" your Project






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






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






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






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






37. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar






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






39. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations






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






41. Subtotals reflect accumulations at selected attribute levels






42. Primary keys






43. OLAP data storage measure






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. A user interface for creating and maintaining a BI environment






46. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.






47. OLTP data storage measure






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






49. View Filters are saved with the _____________.






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