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






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






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






4. Compound - Homogeneous - Heterogeneous






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






6. Facts associated to different column names in 2 or more tables






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






8. Specifies what info to retrieve from a data-warehouse - and how to display it






9. You can _____________ in the Architect Graphical Interface.






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






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






12. Primary keys






13. Create the Project Source - Create the Database Instance






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






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






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






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






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






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






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






21. Facts - Attributes - Hierarchies






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






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






24. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






25. OLAP retains data ________






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






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






28. Tables - Facts - Attributes - Hierarchies






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






30. Folder List - Object Viewer - Shortcut Bar






31. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound






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






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






34. Level of OLTP integration






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






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






37. Template - Filter - View of a Report






38. Allow you to interact with the BI system - logically organize data to analyze complex relationships






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






40. All Attributes must have an _______.






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






42. The Attribute Form maps to the same column name in multiple tables






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






44. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.






45. Facts associated to the same column name in 1 or more tables






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






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






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






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






50. Columns - Tables