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






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






3. Allow you to interact with the BI system - logically organize data to analyze complex relationships






4. Folder List - Object Viewer - Shortcut Bar






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






6. A shortcut to an existing Object in a Project






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






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






9. Level of OLTP integration






10. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending






11. Create the Project Source - Create the Database Instance






12. Schema Objects - Application Objects - Configuration Objects






13. Simple - Compound - Nested - Derived






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






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






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






17. OLAP retains data ________






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






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






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






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






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






23. Subtotals reflect accumulations at selected attribute levels






24. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h






25. Attribute Creation Wizard - Attribute Editor






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






43. AND - OR - OR NOT - AND NOT






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






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






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






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






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






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






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