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. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save






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






3. Simple - Compound - Nested - Derived






4. OLAP retains data ________






5. View Filters are saved with the _____________.






6. Facts associated to different column names in 2 or more tables






7. Specifies a condition data must meet in order to be included in a report






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






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






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






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






12. Extraction - transformation - loading






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






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






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






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






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






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






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






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






21. All report-level options overwrite ___________.






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






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






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






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






26. Grid View - Graph View - Grid/Graph View - SQL View






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






28. A shortcut to an existing Object in a Project






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






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






31. Schema Objects - Application Objects - Configuration Objects






32. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)






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






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






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






36. OLTP data storage measure






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






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






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






40. Enables you to format report values based on a condition - such as highlights - font colors - etc.






41. What tool do you use to create the Metadata DSN connection?






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






43. It creates the System Hierarchy - when you define Attributes and their corresponding relationships






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






45. Used to modify a Report






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






47. It contains the ID column of the parent attribute






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






49. Folder List - Object Viewer - Shortcut Bar






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