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. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics






2. Schema Objects - Application Objects - Configuration Objects






3. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)






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






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






6. A feature that enables users to delivers reports to the history list - cache or mobile






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






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






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






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






11. You can _____________ in the Architect Graphical Interface.






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






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






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






15. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies






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






17. Create the Project Source - Create the Database Instance






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






19. OLAP data storage measure






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






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






22. A shortcut to an existing Object in a Project






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






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






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






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






27. Columns - Tables






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






29. Simple - Compound - Nested - Derived






30. The actual column name for a fact. Every fact must have at least 1 expression.






31. The default entry-points.






32. Grid View - Graph View - Grid/Graph View - SQL View






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






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






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






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






37. Enables you to lock column headers so that they always appear when scrolling






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






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






40. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform






41. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.






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






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






44. All report-level options overwrite ___________.






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






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






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






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






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






50. More storage - Complex SQL - Simple ETL