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. It contains the ID and DESC columns of all higher-level attributes






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






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






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






5. Subtotals reflect accumulations at selected attribute levels






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






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






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






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






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






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






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






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






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






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






16. Template - Filter - View of a Report






17. Schema Objects - Application Objects - Configuration Objects






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






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






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






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






22. Grid View - Graph View - Grid/Graph View - SQL View






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






24. Create the Project Source - Create the Database Instance






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






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






27. Level of OLAP integration






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






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






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






31. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.






32. Descriptive data that provides context for Facts.






33. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.






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






35. Simple - Compound - Nested - Derived






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






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






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






39. Level of OLTP integration






40. Used to "fine-tune" your Project






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






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






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






44. AND - OR - OR NOT - AND NOT






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


46. The default entry-points.






47. OLTP data storage measure






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






49. Homogeneous - Heterogeneous






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