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. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies






2. Simple - Derived






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






4. Primary keys






5. More storage - Complex SQL - Simple ETL






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






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






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






9. What tool do you use to create the Metadata shell?






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






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






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






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






14. The Attribute Form maps to the same column name in multiple tables






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






16. Subtotals reflect accumulations at selected attribute levels






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






18. Extraction - transformation - loading






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






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






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






22. View Filters are saved with the _____________.






23. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






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






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






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






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






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






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






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






31. OLAP retains data ________






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






33. All report-level options overwrite ___________.






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






35. ID columns - Description columns - Fact columns






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






37. Folder List - Object Viewer - Shortcut Bar






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






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






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






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






42. The default entry-points.






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






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






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






46. Homogeneous - Heterogeneous






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






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






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






50. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling