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 new tool for project design tasks - used for fine-tuning a project after initial creation






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






3. Subtotals reflect accumulations at selected attribute levels






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






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






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






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






8. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






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






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






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






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






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






14. Facts - Attributes - Hierarchies






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






16. Template - Filter - View of a Report






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






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






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






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






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






22. Descriptive data that provides context for Facts.






23. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships






24. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View






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






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






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






28. User requirements - Existing source data - Technical and performance considerations






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






30. It contains the ID and DESC columns of all higher-level attributes






31. Enables you to select and display subsets of a report as separate pages.






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






33. Primary keys






34. Direct: 2-tier - Server: 3-tier






35. Extraction - transformation - loading






36. A shortcut to an existing Object in a Project






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






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






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






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






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






42. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse






43. Used to create or edit complex attributes - facts - hierarchies - and logical tables






44. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell






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






46. Create the Project Source - Create the Database Instance






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






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






49. Simple - Compound - Nested - Derived






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