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. Extraction - transformation - loading






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






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






4. It contains the ID column of all higher-level attributes






5. How users can share comments for reports to other users






6. A user interface for creating and maintaining a BI environment






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






8. Facts - Attributes - Hierarchies






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






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






11. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.






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






13. A shortcut to an existing Object in a Project






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






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






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






17. Template - Filter - View of a Report






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






19. Primary keys






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






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






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






23. Filter definition prompts - Object prompts - Value prompts - Level prompts






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






25. ID columns - Description columns - Fact columns






26. All Attributes must have an _______.






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






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






29. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.






30. Top menu/dropdowns - Toolbar - Right-click popup menus






31. The default entry-points.






32. Columns - Tables






33. Subtotals reflect accumulations at selected attribute levels






34. Create the Project Source - Create the Database Instance






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






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






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






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






39. Specifies a condition data must meet in order to be included in a report






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






41. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






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






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






44. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.






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






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






47. View Filters are saved with the _____________.






48. Level of OLTP integration






49. Descriptive data that provides context for Facts.






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