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. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.






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






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






4. Subtotals reflect accumulations at selected attribute levels






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






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






7. Extraction - transformation - loading






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






9. Must have Subtotals enabled - or you won't see any data for higher-level attributes






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






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






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






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






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






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






16. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression






17. ID columns - Description columns - Fact columns






18. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.






19. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns






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






21. Template - Filter - View of a Report






22. Grid View - Graph View - Grid/Graph View - SQL View






23. Facts - Attributes - Hierarchies






24. Descriptive data that provides context for Facts.






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






26. Level of OLTP integration






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






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






29. OLAP retains data ________






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






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






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






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






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






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






36. You can _____________ in the Architect Graphical Interface.






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






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






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






40. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.






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






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






43. Create the Project Source - Create the Database Instance






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


45. The unique values of an attribute obtained from the data-warehouse






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






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






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






49. Level of OLAP integration






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