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. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar






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






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






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






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






6. Tables - Facts - Attributes - Hierarchies






7. Create the Project Source - Create the Database Instance






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






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






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






11. Creating multiple attributes quickly. Used during the initial project creation.






12. Folder List - Object Viewer - Shortcut Bar






13. OLAP data storage measure






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






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






16. Used to "fine-tune" your Project






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






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






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






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






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






22. The System Hierarchy is automatically updated whenever you make a change to an __________________.






23. View Filters can only ___________.






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






25. Extraction - transformation - loading






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






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






28. Simple - Compound - Nested - Derived






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






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






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






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






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






34. Used to modify a Report






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






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






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






38. OLTP data storage measure






39. Simple - Derived






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






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






42. Schema Objects - Application Objects - Configuration Objects






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






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






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






46. Template - Filter - View of a Report






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






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






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






50. OLTP retains data ________