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 - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition






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






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






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






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






6. More storage - Complex SQL - Simple ETL






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






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






9. You must select "Other directions" when drilling attributes while viewing a report






10. Prompts to select a single value on which to qualify a date - number or text string.






11. The default entry-points.






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






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






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






15. Level of OLAP integration






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






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






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






19. OLTP retains data ________






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






21. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.






22. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save






23. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).






24. Groupings of directly related attributes. Also commonly known as "dimensions".






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






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






27. View Filters are saved with the _____________.






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






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






30. Using the Prompt Generation Wizard - Inside the Report Editor






31. Used to "fine-tune" your Project






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






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






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






35. OLAP data storage measure






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






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






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






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






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






41. ID columns - Description columns - Fact columns






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






43. All Attributes must have an _______.






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






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






46. Simple - Derived






47. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.






48. Create the Project Source - Create the Database Instance






49. Template - Filter - View of a Report






50. Simple - Compound - Nested - Derived