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. It contains links to specific folders in the Folder List






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






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






4. User reporting requirements - Query performance - Data volume - DB Maintenance






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






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






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






8. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






9. Creating multiple attributes quickly. Used during the initial project creation.






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






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






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






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






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






15. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports






16. Simple - Compound - Nested - Derived






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






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






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






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






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






22. It contains the ID column of the parent attribute






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






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






25. Create the Project Source - Create the Database Instance






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






27. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)






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






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






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






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






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






33. Subtotals reflect accumulations at selected attribute levels






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






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






36. OLTP data storage measure






37. AND - OR - OR NOT - AND NOT






38. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling






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






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






41. More storage - Complex SQL - Simple ETL






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






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






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






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






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






47. Compound - Homogeneous - Heterogeneous






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






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






50. Facts associated to the same column name in 1 or more tables