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. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






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






3. The System Hierarchy is automatically updated whenever you make a change to an __________________.






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






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






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






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






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






9. All Attributes must have an _______.






10. Primary keys






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






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






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






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






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






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






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






18. AND - OR - OR NOT - AND NOT






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






20. Attribute Creation Wizard - Attribute Editor






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






22. Homogeneous - Heterogeneous






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






24. Facts - Attributes - Hierarchies






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






26. Used to "fine-tune" your Project






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






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






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






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






31. Using the Prompt Generation Wizard - Inside the Report Editor






32. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound






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






34. Folder List - Object Viewer - Shortcut Bar






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






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






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






38. ID columns - Description columns - Fact columns






39. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






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






41. Must have Subtotals enabled - or you won't see any data for higher-level attributes






42. Descriptive data that provides context for Facts.






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






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






45. OLTP retains data ________






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






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






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






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






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