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. Grid View - Graph View - Grid/Graph View - SQL View






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






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






4. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.






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






6. OLAP retains data ________






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






8. View Filters are saved with the _____________.






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






10. Tables - Facts - Attributes - Hierarchies






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






12. Facts - Attributes - Hierarchies






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






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






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






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






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






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






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






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






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






22. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form






23. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner






24. A condition data must meet in order to be included in a report. Does affect the SQL.






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






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


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






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






29. Homogeneous - Heterogeneous






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






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






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






33. Used to "fine-tune" your Project






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






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






36. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen






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






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






39. Extraction - transformation - loading






40. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform






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






42. AND - OR - OR NOT - AND NOT






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






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






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






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






47. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






48. View Filters can only ___________.






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






50. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report