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. Used for - Initially populating the Metadata - Creating schema objects






2. AND - OR - OR NOT - AND NOT






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






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






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






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






7. MS Excel - MS Word - MS Access - PDF - HTML - Plain text






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






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






10. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






11. More storage - Complex SQL - Simple ETL






12. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked






13. OLTP retains data ________






14. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






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






16. Formula - Level (Dimensionality) - Conditionality - Transformation






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






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






19. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters






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






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






22. A development environment to create BI applications - allowing users to edit the Metadata database






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






24. Subtotals reflect accumulations at selected attribute levels






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






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






27. Tables - Facts - Attributes - Hierarchies






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






29. View Filters can only ___________.






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






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






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






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






34. Facts - Attributes - Hierarchies






35. Specifies what info to retrieve from a data-warehouse - and how to display it






36. It contains the ID column of the parent attribute






37. Metrics you create within a report using only those objects in the report.






38. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.






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






40. Enables you to select which tables from the data-warehouse to store in the Metadata database






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






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






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






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






45. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.






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






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






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






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






50. ID columns - Description columns - Fact columns