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. Extraction - transformation - loading






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






3. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






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






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






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






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






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






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






10. All report-level options overwrite ___________.






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






12. OLTP data storage measure






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






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






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






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






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






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






19. Used to "fine-tune" your Project






20. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.






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






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






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






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






25. You can e-mail reports by going to _____






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






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






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






29. Descriptive data that provides context for Facts.






30. Tables - Facts - Attributes - Hierarchies






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






32. Used to modify a Report






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






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






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






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






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






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






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






40. Store info about attributes - including IDs and any descriptions. Used for easier browsing.






41. A user interface for creating and maintaining a BI environment






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






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






44. All Attributes must have an _______.






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






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






47. Homogeneous - Heterogeneous






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






49. Using the Prompt Generation Wizard - Inside the Report Editor






50. Level of OLAP integration