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. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






2. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.






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






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






5. Attribute Creation Wizard - Attribute Editor






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






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






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






9. Columns - Tables






10. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell






11. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications






12. It contains the ID column of the parent attribute






13. Simple - Compound - Nested - Derived






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






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






16. Template - Filter - View of a Report






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






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






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






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






21. A shortcut to an existing Object in a Project






22. Groupings of directly related attributes. Also commonly known as "dimensions".






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






24. OLTP retains data ________






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






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






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






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






29. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships






30. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar






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






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






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






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






35. Top menu/dropdowns - Toolbar - Right-click popup menus






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






37. Direct: 2-tier - Server: 3-tier






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






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






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






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






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






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






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






45. OLTP data storage measure






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






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






48. User requirements - Existing source data - Technical and performance considerations






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






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