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






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






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






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






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






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






7. Homogeneous - Heterogeneous






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






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






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






11. Create the Project Source - Create the Database Instance






12. Schema Objects - Application Objects - Configuration Objects






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






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






15. Enables you to rearrange the columns and rows in a report.






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






17. Level of OLAP integration






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






19. Using the Prompt Generation Wizard - Inside the Report Editor






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






21. A shortcut to an existing Object in a Project






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






23. Extraction - transformation - loading






24. Used to "fine-tune" your Project






25. Descriptive data that provides context for Facts.






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






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






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






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






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






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






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






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






34. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data






35. View Filters can only ___________.






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






37. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.






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






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






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






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






42. A development environment to create BI applications - allowing users to edit the Metadata database






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






44. OLAP retains data ________






45. One that uses 2 or more columns as its ID






46. Less storage - Simple SQL - Complex ETL






47. Columns - Tables






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






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






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