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. The System Hierarchy is automatically updated whenever you make a change to an __________________.






2. A user interface for creating and maintaining a BI environment






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






4. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound






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






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






7. Level of OLTP integration






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






9. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked






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






11. Simple - Compound - Nested - Derived






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






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






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






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






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






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






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






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






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






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






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






23. Extraction - transformation - loading






24. Level of OLAP integration






25. Schema Objects - Application Objects - Configuration Objects






26. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns






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






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






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






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






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






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






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






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






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






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






37. Less storage - Simple SQL - Complex ETL






38. The default entry-points.






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






40. Must have Subtotals enabled - or you won't see any data for higher-level attributes






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






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






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






44. Simple - Derived






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






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






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






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






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






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