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. User requirements - Existing source data - Technical and performance considerations






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






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






4. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.






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






6. ID columns - Description columns - Fact columns






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






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






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






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






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






12. Level of OLAP integration






13. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform






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






15. Primary keys






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






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






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






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






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






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






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






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






24. Simple - Compound - Nested - Derived






25. All Attributes must have an _______.






26. The Attribute Form maps to different column names in multiple tables






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






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






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






30. A shortcut to an existing Object in a Project






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






32. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling






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






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






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






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






37. Store info about attributes - including IDs and any descriptions. Used for easier browsing.






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






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






40. Homogeneous - Heterogeneous






41. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h






42. More storage - Complex SQL - Simple ETL






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






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






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






46. Enables you to lock column headers so that they always appear when scrolling






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






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






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






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