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. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform






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






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






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






5. Used to modify a Report






6. Used to create or edit complex attributes - facts - hierarchies - and logical tables






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






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






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






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






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






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






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






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






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






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






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






18. Columns - Tables






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






20. You can _____________ in the Architect Graphical Interface.






21. Simple - Compound - Nested - Derived






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






23. User requirements - Existing source data - Technical and performance considerations






24. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)






25. Primary keys






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






27. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions






28. OLTP retains data ________






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






30. It contains the ID column of the parent attribute






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






32. Subtotals reflect accumulations at selected attribute levels






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






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






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






36. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h






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






38. Descriptive data that provides context for Facts.






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






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






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






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






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






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






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






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






47. OLAP retains data ________






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






49. View Filters are saved with the _____________.






50. OLAP data storage measure