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. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters






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






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






4. Specifies a condition data must meet in order to be included in a report






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






6. Facts - Attributes - Hierarchies






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






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






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






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






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






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






13. OLAP data storage measure






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






15. A development environment to create BI applications - allowing users to edit the Metadata database






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






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






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






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






20. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships






21. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations






22. Homogeneous - Heterogeneous






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






24. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)






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






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






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






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






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






30. To see data at completely different levels - other than that of the original Grid or Graph






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






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






33. Subtotals reflect accumulations at selected attribute levels






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






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






36. Simple - Compound - Nested - Derived






37. Metrics that perform multiple aggregations; one calculation inside of another.






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






39. Folder List - Object Viewer - Shortcut Bar






40. Less storage - Simple SQL - Complex ETL






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






42. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations






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






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






45. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities






46. AND - OR - OR NOT - AND NOT






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






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






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






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