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. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar






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






3. You can _____________ in the Architect Graphical Interface.






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






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






6. Descriptive data that provides context for Facts.






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






8. The default entry-points.






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






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






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






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






13. More storage - Complex SQL - Simple ETL






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






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






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






17. All Attributes must have an _______.






18. Level of OLTP integration






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






20. The Attribute Form Expression that maps to a single column - no matter the number of tables






21. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports






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






23. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)






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






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






26. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling






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






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






29. Compound - Homogeneous - Heterogeneous






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






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






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






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






34. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending






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






36. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations






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






38. It contains the ID column of all higher-level attributes






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






40. Create the Project Source - Create the Database Instance






41. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...






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






43. Used to modify a Report






44. ID columns - Description columns - Fact columns






45. Homogeneous - Heterogeneous






46. Schema Objects - Application Objects - Configuration Objects






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






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






49. Extraction - transformation - loading






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