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. Template - Filter - View of a Report






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






3. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.






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






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






6. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling






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






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






9. View Filters are saved with the _____________.






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






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






12. Simple - Compound - Nested - Derived






13. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform






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






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






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






17. Create the Project Source - Create the Database Instance






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






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






20. OLAP Services does not add any ______ to the report query.






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






22. Enables you to format report values based on a condition - such as highlights - font colors - etc.






23. Used to create or edit complex attributes - facts - hierarchies - and logical tables






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






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






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






27. The Attribute Form Expression that maps to a single column - no matter the number of tables






28. It contains the ID column of the parent attribute






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






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






31. You can _____________ in the Architect Graphical Interface.






32. Level of OLTP integration






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






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






35. Folder List - Object Viewer - Shortcut Bar






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






37. The default entry-points.






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






39. Enables you to rearrange the columns and rows in a report.






40. A method of organizing the appearance of report results in a Grid report based on a criteria






41. Used to modify a Report






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






43. One that uses 2 or more columns as its ID






44. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions






45. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner






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






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






48. View Filters can only ___________.






49. Attribute Creation Wizard - Attribute Editor






50. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.