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. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






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






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






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






5. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types






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






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






8. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...






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






10. AND - OR - OR NOT - AND NOT






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






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






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






14. Level of OLAP integration






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






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






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






18. Homogeneous - Heterogeneous






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






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






21. Attribute Creation Wizard - Attribute Editor






22. Allow you to interact with the BI system - logically organize data to analyze complex relationships






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






24. Primary keys






25. View Filters are saved with the _____________.






26. Facts - Attributes - Hierarchies






27. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)






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






29. OLTP retains data ________






30. To define the level of aggregation for a specific metric - Used for qualifications






31. Used to "fine-tune" your Project






32. Used to modify a Report






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






34. Extraction - transformation - loading






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






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






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






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






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






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






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






42. The Attribute Form Expression that maps to a single column - no matter the number of tables






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






44. Simple - Derived






45. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents






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






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






48. Used to create or edit complex attributes - facts - hierarchies - and logical tables






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






50. It contains the ID column of the parent attribute