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. It contains the ID and DESC columns of all higher-level attributes






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






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






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






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






6. ID columns - Description columns - Fact columns






7. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations






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






9. Enables you to lock column headers so that they always appear when scrolling






10. More storage - Complex SQL - Simple ETL






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






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






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






14. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.






15. Grid View - Graph View - Grid/Graph View - SQL View






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






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






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






19. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






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






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






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






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






24. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






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






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






27. Folder List - Object Viewer - Shortcut Bar






28. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling






29. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts






30. Create the Project Source - Create the Database Instance






31. A shortcut to an existing Object in a Project






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






33. Formula - Level (Dimensionality) - Conditionality - Transformation






34. Compound - Homogeneous - Heterogeneous






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






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






37. OLTP retains data ________






38. Reduced number of JOINS in the generated SQL






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






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






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






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






43. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...






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






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






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






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






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






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






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