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. Folder List - Object Viewer - Shortcut Bar






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






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






4. Simple - Compound - Nested - Derived






5. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






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






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






8. All report-level options overwrite ___________.






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






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






11. What tool do you use to create the Metadata DSN connection?






12. A user interface for creating and maintaining a BI environment






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






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






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






16. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports






17. Facts - Attributes - Hierarchies






18. OLAP retains data ________






19. A condition data must meet in order to be included in a report. Does affect the SQL.






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






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






22. OLAP data storage measure






23. Template - Filter - View of a Report






24. More storage - Complex SQL - Simple ETL






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






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






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






28. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.






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






30. Reduced number of JOINS in the generated SQL






31. Simple - Derived






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






33. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






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






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






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






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






38. Columns - Tables






39. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)






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






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






42. Create the Project Source - Create the Database Instance






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






44. Must have a one-to-one relationship with all other forms.






45. Used to modify a Report






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






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






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






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






50. A shortcut to an existing Object in a Project