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. Homogeneous - Heterogeneous






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






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






4. OLTP data storage measure






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






6. View Filters can only ___________.






7. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data






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






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






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






11. Reduced number of JOINS in the generated SQL






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






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






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






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






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






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






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






19. Simple - Compound - Nested - Derived






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






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






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






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






24. Used to "fine-tune" your Project






25. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






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






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






28. Folder List - Object Viewer - Shortcut Bar






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






30. OLAP data storage measure






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






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






33. Create the Project Source - Create the Database Instance






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






35. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.






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






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






38. Level of OLTP integration






39. Schema Objects - Application Objects - Configuration Objects






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






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






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


43. Facts - Attributes - Hierarchies






44. The default entry-points.






45. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen






46. Columns - Tables






47. More storage - Complex SQL - Simple ETL






48. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.






49. Primary keys






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