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






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






3. Level of OLTP integration






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






5. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View






6. Reduced number of JOINS in the generated SQL






7. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies






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






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






10. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns






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






12. Subtotals reflect accumulations at selected attribute levels






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






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






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






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






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






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






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






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






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






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






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






24. OLAP data storage measure






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






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






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






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






29. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics






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






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






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






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






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






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






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






37. Extraction - transformation - loading






38. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)






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






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






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






42. To define the level of aggregation for a specific metric - Used for qualifications






43. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.






44. Grid View - Graph View - Grid/Graph View - SQL View






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






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






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






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






49. A shortcut to an existing Object in a Project






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