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. Direct: 2-tier - Server: 3-tier






2. Using the Prompt Generation Wizard - Inside the Report Editor






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






4. Extraction - transformation - loading






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






6. You can _____________ in the Architect Graphical Interface.






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






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






9. A development environment to create BI applications - allowing users to edit the Metadata database






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






11. Top menu/dropdowns - Toolbar - Right-click popup menus






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






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






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






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






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






17. OLAP data storage measure






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






19. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...






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






21. Must have a one-to-one relationship with all other forms.






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






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






24. A condition data must meet in order to be included in a report. Does affect the SQL.






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






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






27. Enables you to select and display subsets of a report as separate pages.






28. Create the Project Source - Create the Database Instance






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






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






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






32. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar






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






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






35. It contains the ID column of the parent attribute






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






37. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters






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






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






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






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






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






43. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling






44. Less storage - Simple SQL - Complex ETL






45. View Filters can only ___________.






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






47. You can e-mail reports by going to _____






48. Tables - Facts - Attributes - Hierarchies






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






50. View Filters are saved with the _____________.