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. To see data at completely different levels - other than that of the original Grid or Graph






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






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






4. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h






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






6. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types






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






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






9. OLTP retains data ________






10. Schema Objects - Application Objects - Configuration Objects






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






12. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations






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






14. All Attributes must have an _______.






15. Used to "fine-tune" your Project






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






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






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






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






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






21. Create the Project Source - Create the Database Instance






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






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






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






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






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






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






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






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






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






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






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






33. Descriptive data that provides context for Facts.






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






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






36. Store info on relationships between 2 or more tables (attributes) - like an Index table.






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






38. A shortcut to an existing Object in a Project






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






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






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






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






43. Reduced number of JOINS in the generated SQL






44. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.






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






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






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






48. View Filters are saved with the _____________.






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






50. What tool do you use to create the Metadata shell?