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. Used to "fine-tune" your Project






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






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






4. A subset of a report that users can manipulate without altering the SQL

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


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






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






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






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






9. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)






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






11. Attribute Creation Wizard - Attribute Editor






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






13. Compound - Homogeneous - Heterogeneous






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






15. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View






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






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






18. View Filters are saved with the _____________.






19. OLAP data storage measure






20. Metrics aggregate on the lowest-level attribute __________.






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






22. Schema Objects - Application Objects - Configuration Objects






23. OLTP data storage measure






24. It creates the System Hierarchy - when you define Attributes and their corresponding relationships






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






26. Contains info that facilitates the transfer of data from the source systems to the data-warehouse






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






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






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






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






31. The default entry-points.






32. Create the Project Source - Create the Database Instance






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






34. OLTP retains data ________






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






36. One that uses 2 or more columns as its ID






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






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






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






40. Metrics you create within a report using only those objects in the report.






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






42. Template - Filter - View of a Report






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






44. Simple - Derived






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






46. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save






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






48. Used to modify a Report






49. ID columns - Description columns - Fact columns






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