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. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.






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






3. ID columns - Description columns - Fact columns






4. Level of OLTP integration






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






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






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






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






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






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






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






12. Homogeneous - Heterogeneous






13. All Attributes must have an _______.






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






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






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






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






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






19. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






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






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






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






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






24. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema






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






26. Folder List - Object Viewer - Shortcut Bar






27. Create the Project Source - Create the Database Instance






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






29. A condition data must meet in order to be included in a report. Does affect the SQL.






30. Used to "fine-tune" your Project






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






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






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






34. Subtotals reflect accumulations at selected attribute levels






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






36. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)






37. View Filters can only ___________.






38. The default entry-points.






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






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






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






42. Template - Filter - View of a Report






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






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






45. Descriptive data that provides context for Facts.






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






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






48. Schema Objects - Application Objects - Configuration Objects






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






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