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. Used to modify a Report






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






3. More storage - Complex SQL - Simple ETL






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






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






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






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






8. Store info on relationships between 2 or more tables (attributes) - like an Index table.






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






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






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






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






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






14. Must have Subtotals enabled - or you won't see any data for higher-level attributes






15. Tables - Facts - Attributes - Hierarchies






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






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






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






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






20. Schema Objects - Application Objects - Configuration Objects






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






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






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






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






25. It contains the ID column of the parent attribute






26. All Attributes must have an _______.






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






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






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






30. Primary keys






31. Template - Filter - View of a Report






32. Level of OLTP integration






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






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






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






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






37. A shortcut to an existing Object in a Project






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






39. Level of OLAP integration






40. Simple - Compound - Nested - Derived






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






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






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






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






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. OLAP data storage measure






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






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






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






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