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






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






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






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






5. Folder List - Object Viewer - Shortcut Bar






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






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






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






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






10. Used to modify a Report






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






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






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






14. OLAP data storage measure






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






16. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






17. Used to limit a possibly overwhelming set of potential prompt answers






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






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






20. Columns - Tables






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






22. You can _____________ in the Architect Graphical Interface.






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






24. All report-level options overwrite ___________.






25. Schema Objects - Application Objects - Configuration Objects






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






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






28. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy






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






30. More storage - Complex SQL - Simple ETL






31. Level of OLTP integration






32. What tool do you use to create the Metadata shell?






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






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






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






36. View Filters can only ___________.






37. Compound - Homogeneous - Heterogeneous






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






39. OLTP retains data ________






40. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions






41. A new tool for project design tasks - used for fine-tuning a project after initial creation






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






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






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






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






46. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form






47. It contains the ID column of the parent attribute






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






49. Create the Project Source - Create the Database Instance






50. ID columns - Description columns - Fact columns