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 simplified version of Desktop - providing interactive "slice-&-dice" capabilities






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






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






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






5. AND - OR - OR NOT - AND NOT






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






7. A subset of a report that users can manipulate without altering the SQL

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


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






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






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






11. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.






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






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






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






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






16. Primary keys






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






18. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.






19. Level of OLAP integration






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






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






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






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






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






25. Simple - Derived






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






27. Facts - Attributes - Hierarchies






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






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






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






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






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






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






34. Template - Filter - View of a Report






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






36. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.






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






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






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






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






41. Used for - Initially populating the Metadata - Creating schema objects






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






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






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






45. A shortcut to an existing Object in a Project






46. Level of OLTP integration






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






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






49. Enables you to search for a specific Object or group of Objects that meet a certain criteria.






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