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






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






3. View Filters can only ___________.






4. Formula - Level (Dimensionality) - Conditionality - Transformation






5. Used to modify a Report






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






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






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






9. Enables you to select and display subsets of a report as separate pages.






10. Extraction - transformation - loading






11. Simple - Compound - Nested - Derived






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






13. Facts - Attributes - Hierarchies






14. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.






15. Columns - Tables






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






17. Primary keys






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






19. Template - Filter - View of a Report






20. Used for - Initially populating the Metadata - Creating schema objects






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






22. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell






23. OLAP retains data ________






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






25. Descriptive data that provides context for Facts.






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






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






28. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts






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






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






31. All Attributes must have an _______.






32. Direct: 2-tier - Server: 3-tier






33. View Filters are saved with the _____________.






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






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






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






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






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






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






40. Less storage - Simple SQL - Complex ETL






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






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






43. Facts associated to the same column name in 1 or more tables






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






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






46. Tables - Facts - Attributes - Hierarchies






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






48. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






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






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