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. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






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






3. Template - Filter - View of a Report






4. Folder List - Object Viewer - Shortcut Bar






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






6. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form






7. OLTP data storage measure






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






9. Compound - Homogeneous - Heterogeneous






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






11. Simple - Compound - Nested - Derived






12. All Attributes must have an _______.






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






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






15. Prompts to select a single value on which to qualify a date - number or text string.






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






17. Primary keys






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






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






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






21. Simple - Derived






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






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






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






25. Less storage - Simple SQL - Complex ETL






26. Schema Objects - Application Objects - Configuration Objects






27. Tables - Facts - Attributes - Hierarchies






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






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






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






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






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






33. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field






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






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






36. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.






37. User management - Security profiles - Server parameters - like report length - idle time and report prioritization






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






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






40. View Filters are saved with the _____________.






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






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






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






44. It contains links to specific folders in the Folder List






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






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






47. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View






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






49. Subtotals reflect accumulations at selected attribute levels






50. Used to limit a possibly overwhelming set of potential prompt answers