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. Metrics that perform multiple aggregations; one calculation inside of another.






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






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






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






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






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






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






8. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition






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






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






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






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






13. OLTP retains data ________






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






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






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






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






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






19. All report-level options overwrite ___________.






20. Tables - Facts - Attributes - Hierarchies






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






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






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






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






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






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






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






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






29. Primary keys






30. OLAP data storage measure






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






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






33. OLTP data storage measure






34. Less storage - Simple SQL - Complex ETL






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






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






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






38. Store info on relationships between 2 or more tables (attributes) - like an Index table.






39. Create the Project Source - Create the Database Instance






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






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






42. Filter definition prompts - Object prompts - Value prompts - Level prompts






43. You must select "Other directions" when drilling attributes while viewing a report






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






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






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






47. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...






48. Level of OLAP integration






49. Columns - Tables






50. Attribute Creation Wizard - Attribute Editor