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. Level of OLAP integration






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






3. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.






4. Less storage - Simple SQL - Complex ETL






5. Level of OLTP integration






6. Compound - Homogeneous - Heterogeneous






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






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






9. View Filters can only ___________.






10. Extraction - transformation - loading






11. Subtotals reflect accumulations at selected attribute levels






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






13. Homogeneous - Heterogeneous






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






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






16. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






17. Grid View - Graph View - Grid/Graph View - SQL View






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






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






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






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






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






23. ID columns - Description columns - Fact columns






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






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






26. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format






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






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






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






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






31. Used to modify a Report






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






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






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






35. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field






36. It creates the System Hierarchy - when you define Attributes and their corresponding relationships






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






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






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






40. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression






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






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






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






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






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






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






47. Reduced number of JOINS in the generated SQL






48. Create the Project Source - Create the Database Instance






49. Template - Filter - View of a Report






50. Columns - Tables