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. One that uses 2 or more columns as its ID






2. More storage - Complex SQL - Simple ETL






3. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View






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






5. Schema Objects - Application Objects - Configuration Objects






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






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






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






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






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






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






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






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






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






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






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






17. View Filters can only ___________.






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






19. Used to modify a Report






20. You can e-mail reports by going to _____






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






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






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






24. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar






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






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






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






28. View Filters are saved with the _____________.






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






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






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






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






33. Attribute Creation Wizard - Attribute Editor






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






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






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






37. Extraction - transformation - loading






38. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data






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






40. A shortcut to an existing Object in a Project






41. Facts - Attributes - Hierarchies






42. How users can share comments for reports to other users






43. It contains the ID column of the parent attribute






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






45. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.






46. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics






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






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






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






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