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. It contains links to specific folders in the Folder List






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






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






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






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






6. User management - Security profiles - Server parameters - like report length - idle time and report prioritization






7. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships






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






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






10. Simple - Compound - Nested - Derived






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






12. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities






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






14. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form






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






16. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse






17. OLAP retains data ________






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






19. Facts - Attributes - Hierarchies






20. All Attributes must have an _______.






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






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






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






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






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. Enables you to format report values based on a condition - such as highlights - font colors - etc.






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






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






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






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






31. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.






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






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






34. Template - Filter - View of a Report






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






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






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






38. Used to modify a Report






39. AND - OR - OR NOT - AND NOT






40. Folder List - Object Viewer - Shortcut Bar






41. Top menu/dropdowns - Toolbar - Right-click popup menus






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






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






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






45. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.






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






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






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






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






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