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 actual column name for a fact. Every fact must have at least 1 expression.






2. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts






3. Simple - Derived






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






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






6. View Filters are saved with the _____________.






7. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling






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






9. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format






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






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






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






13. Used to modify a Report






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






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






16. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types






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






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






19. The default entry-points.






20. A new tool for project design tasks - used for fine-tuning a project after initial creation






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






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






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






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






25. AND - OR - OR NOT - AND NOT






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






27. More storage - Complex SQL - Simple ETL






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






29. OLTP data storage measure






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






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






32. Columns - Tables






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






34. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.






35. MS Excel - MS Word - MS Access - PDF - HTML - Plain text






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






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






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






39. Level of OLTP integration






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






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






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






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






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






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






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






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






49. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.






50. An environment in which the MSTR Desktop connects directly to the Metadata database.