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. Create the Project Source - Create the Database Instance






2. Primary keys






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






4. All Attributes must have an _______.






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






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






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






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






9. Schema Objects - Application Objects - Configuration Objects






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






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






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






13. User reporting requirements - Query performance - Data volume - DB Maintenance






14. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform






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






16. OLAP data storage measure






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






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






19. Used to modify a Report






20. More storage - Complex SQL - Simple ETL






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






22. The logical associations between attributes that exist based on a business rule






23. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.






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






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






26. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts






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






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






29. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts






30. OLAP retains data ________






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






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






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






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






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






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






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






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






39. Attribute Creation Wizard - Attribute Editor






40. Level of OLTP integration






41. Used to "fine-tune" your Project






42. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell






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






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






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






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






47. Facts associated to different column names in 2 or more tables






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






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






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