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. Used to "fine-tune" your Project






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. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar






4. Tables - Facts - Attributes - Hierarchies






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






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






7. Subtotals reflect accumulations at selected attribute levels






8. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound






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






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






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






12. Primary keys






13. All Attributes must have an _______.






14. AND - OR - OR NOT - AND NOT






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






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






17. The logical associations between attributes that exist based on a business rule






18. A feature that enables users to delivers reports to the history list - cache or mobile






19. How users can share comments for reports to other users






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






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






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






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






24. What tool do you use to create the Metadata shell?






25. You can _____________ in the Architect Graphical Interface.






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






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






28. Enables you to select which tables from the data-warehouse to store in the Metadata database






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






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






31. Extraction - transformation - loading






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






33. The actual column name for a fact. Every fact must have at least 1 expression.






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






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






36. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations






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






38. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.






39. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)






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






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






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






43. Homogeneous - Heterogeneous






44. Metrics you create within a report using only those objects in the report.






45. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






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






47. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report






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






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






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