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. Enables you to search for a specific Object or group of Objects that meet a certain criteria.






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






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






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






5. Template - Filter - View of a Report






6. Compound - Homogeneous - Heterogeneous






7. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)






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






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






10. All report-level options overwrite ___________.






11. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






12. Simple - Derived






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






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






15. The Attribute Form Expression that maps to a single column - no matter the number of tables






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






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






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






19. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse






20. Reduced number of JOINS in the generated SQL






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






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






23. OLAP retains data ________






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






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






26. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending






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






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






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






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






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






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






33. Create the Project Source - Create the Database Instance






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






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






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






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






38. Level of OLAP integration






39. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked






40. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform






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






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






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






44. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling






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






46. OLAP data storage measure






47. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents






48. To see data at completely different levels - other than that of the original Grid or Graph






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






50. More storage - Complex SQL - Simple ETL