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. Compound - Homogeneous - Heterogeneous






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






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






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






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






6. A shortcut to an existing Object in a Project






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






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






9. All Attributes must have an _______.






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






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






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






13. A Project Source can house ________ . A single Metadata can be used by multiple Projects.






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






15. View Filters are saved with the _____________.






16. Descriptive data that provides context for Facts.






17. Level of OLAP integration






18. ID columns - Description columns - Fact columns






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






20. OLAP data storage measure






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






22. A subset of a report that users can manipulate without altering the SQL






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






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






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






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






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






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






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






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






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






32. OLTP retains data ________






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






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






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






36. Used to modify a Report






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






38. Tables - Facts - Attributes - Hierarchies






39. Enables you to select which tables from the data-warehouse to store in the Metadata database






40. MS Excel - MS Word - MS Access - PDF - HTML - Plain text






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






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






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






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






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






46. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling






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






48. It contains the ID column of the parent attribute






49. Template - Filter - View of a Report






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