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. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...






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






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






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






5. OLTP data storage measure






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






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






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






9. Extraction - transformation - loading






10. View Filters can only ___________.






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






12. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse






13. What tool do you use to create the Metadata shell?






14. Reduced number of JOINS in the generated SQL






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






16. View Filters are saved with the _____________.






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






18. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked






19. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






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






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






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






23. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data






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






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






26. Columns - Tables






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






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






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






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






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






32. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling






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






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






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






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






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






38. A new tool for project design tasks - used for fine-tuning a project after initial creation






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






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






41. Homogeneous - Heterogeneous






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






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






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






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






46. You can _____________ in the Architect Graphical Interface.






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






48. All Attributes must have an _______.






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






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