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. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.






2. All report-level options overwrite ___________.






3. Used for - Initially populating the Metadata - Creating schema objects






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






5. All Attributes must have an _______.






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






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






8. Template - Filter - View of a Report






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






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






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






12. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View






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






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






15. It contains the ID and DESC columns of all higher-level attributes






16. Columns - Tables






17. Subtotals reflect accumulations at selected attribute levels






18. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.






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






20. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h






21. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships






22. Compound - Homogeneous - Heterogeneous






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






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






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






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






27. Simple - Derived






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






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






30. OLAP retains data ________






31. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.






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






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






34. OLTP retains data ________






35. ID columns - Description columns - Fact columns






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






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






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






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






40. The default entry-points.






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






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






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






44. View Filters are saved with the _____________.






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






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






47. Grid View - Graph View - Grid/Graph View - SQL View






48. You can _____________ in the Architect Graphical Interface.






49. Simple - Compound - Nested - Derived






50. Used to modify a Report