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. Specifies a condition data must meet in order to be included in a report






2. OLTP retains data ________






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






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






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






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






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






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






9. A shortcut to an existing Object in a Project






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






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






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






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






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






15. Folder List - Object Viewer - Shortcut Bar






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






17. It contains the ID and DESC columns of all higher-level attributes






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






19. AND - OR - OR NOT - AND NOT






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






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






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






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. A subset of a report that users can manipulate without altering the SQL

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


25. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.






26. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.






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






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






29. Used to modify a Report






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






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






32. Grid View - Graph View - Grid/Graph View - SQL View






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






34. OLAP data storage measure






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






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






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






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






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






40. Contains info that facilitates the transfer of data from the source systems to the data-warehouse






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






42. Level of OLAP integration






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






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






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






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






47. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






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






49. Create the Project Source - Create the Database Instance






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