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. Top menu/dropdowns - Toolbar - Right-click popup menus






2. Columns - Tables






3. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).






4. Descriptive data that provides context for Facts.






5. Create the Project Source - Create the Database Instance






6. Tables - Facts - Attributes - Hierarchies






7. Grid View - Graph View - Grid/Graph View - SQL View






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






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






10. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents






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






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






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






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






15. One that uses 2 or more columns as its ID






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






17. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns






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






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






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






21. Compound - Homogeneous - Heterogeneous






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






23. Folder List - Object Viewer - Shortcut Bar






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






25. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data






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






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






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






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






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






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






32. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types






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






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






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






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






37. OLAP retains data ________






38. Less storage - Simple SQL - Complex ETL






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






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






41. Used to "fine-tune" your Project






42. AND - OR - OR NOT - AND NOT






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






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






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






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






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






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






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






50. The logical associations between attributes that exist based on a business rule