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. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.






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






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






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






5. Enables you to format report values based on a condition - such as highlights - font colors - etc.






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






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






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






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






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






11. You must select "Other directions" when drilling attributes while viewing a report






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






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






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






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






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






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






18. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types






19. Attribute Creation Wizard - Attribute Editor






20. Subtotals reflect accumulations at selected attribute levels






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






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






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






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






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






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






27. Grid View - Graph View - Grid/Graph View - SQL View






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






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






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






31. A Project Source can house ________ . A single Metadata can be used by multiple Projects.






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






33. Used to "fine-tune" your Project






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






35. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications






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






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






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






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






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






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






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






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






44. Homogeneous - Heterogeneous






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






46. ID columns - Description columns - Fact columns






47. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts






48. Direct: 2-tier - Server: 3-tier






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






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