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. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format






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






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






4. It contains the ID column of the parent attribute






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






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






7. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.






8. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations






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






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






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






12. What tool do you use to create the Metadata shell?






13. Extraction - transformation - loading






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






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






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






17. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






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






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






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






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






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






23. Enables you to lock column headers so that they always appear when scrolling






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






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






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






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






28. A method of organizing the appearance of report results in a Grid report based on a criteria






29. Simple - Compound - Nested - Derived






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






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






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






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






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






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






36. Facts - Attributes - Hierarchies






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






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






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






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






41. Must have Subtotals enabled - or you won't see any data for higher-level attributes






42. Attribute Creation Wizard - Attribute Editor






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






44. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.






45. Columns - Tables






46. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition






47. The default entry-points.






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






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






50. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.