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. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






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






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






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






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






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






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






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






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






10. Homogeneous - Heterogeneous






11. Descriptive data that provides context for Facts.






12. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.






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






14. All Attributes must have an _______.






15. A feature that enables users to delivers reports to the history list - cache or mobile






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






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






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






19. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.






20. Simple - Derived






21. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form






22. Allow you to interact with the BI system - logically organize data to analyze complex relationships






23. Grid View - Graph View - Grid/Graph View - SQL View






24. ID columns - Description columns - Fact columns






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. The Attribute Form Expression that maps to a single column - no matter the number of tables






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






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






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






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






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






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






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






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






35. Template - Filter - View of a Report






36. Used to limit a possibly overwhelming set of potential prompt answers






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






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






39. Subtotals reflect accumulations at selected attribute levels






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






41. One that uses 2 or more columns as its ID






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






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






44. It contains the ID column of the parent attribute






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






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






47. Schema Objects - Application Objects - Configuration Objects






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






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






50. User management - Security profiles - Server parameters - like report length - idle time and report prioritization