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. Using the Prompt Generation Wizard - Inside the Report Editor






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






3. Schema Objects - Application Objects - Configuration Objects






4. An environment in which the MSTR Desktop connects directly to the Metadata database.






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






6. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






22. AND - OR - OR NOT - AND NOT






23. Metrics that perform multiple aggregations; one calculation inside of another.






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






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






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






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






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






29. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data






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






31. Simple - Compound - Nested - Derived






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






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






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






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






36. View Filters are saved with the _____________.






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






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






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






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






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






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






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






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






45. The default entry-points.






46. Simple - Derived






47. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.






48. Extraction - transformation - loading






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






50. The actual column name for a fact. Every fact must have at least 1 expression.