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. Facts associated to different column names in 2 or more tables






2. Used to "fine-tune" your Project






3. AND - OR - OR NOT - AND NOT






4. Schema Objects - Application Objects - Configuration Objects






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






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






7. Less storage - Simple SQL - Complex ETL






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






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






10. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities






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






12. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations






13. View Filters can only ___________.






14. OLAP Services does not add any ______ to the report query.






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






16. Used to modify a Report






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






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






19. It contains links to specific folders in the Folder List






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






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






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






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






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






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






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






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






28. Compound - Homogeneous - Heterogeneous






29. Metrics that perform multiple aggregations; one calculation inside of another.






30. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.






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






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






33. Enables you to search for a specific Object or group of Objects that meet a certain criteria.






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






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






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






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






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






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






40. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression






41. Folder List - Object Viewer - Shortcut Bar






42. Level of OLAP integration






43. Grid View - Graph View - Grid/Graph View - SQL View






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






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






46. Simple - Derived






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






48. OLTP data storage measure






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






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