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. The Attribute Form maps to the same column name in multiple tables






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






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






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






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






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






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






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






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






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






11. Descriptive data that provides context for Facts.






12. Used to modify a Report






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






14. Attribute Creation Wizard - Attribute Editor






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


16. Tables - Facts - Attributes - Hierarchies






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






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






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






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






21. Create the Project Source - Create the Database Instance






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






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






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






25. Columns - Tables






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






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






28. AND - OR - OR NOT - AND NOT






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






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






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






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






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






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






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






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






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






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






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






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






41. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics






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






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






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






45. Facts - Attributes - Hierarchies






46. Compound - Homogeneous - Heterogeneous






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






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






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






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