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. Must have a one-to-one relationship with all other forms.






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






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






4. View Filters are saved with the _____________.






5. Reduced number of JOINS in the generated SQL






6. OLTP data storage measure






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






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






9. Homogeneous - Heterogeneous






10. Used to "fine-tune" your Project






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






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






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






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






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






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






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






18. OLAP data storage measure






19. The logical associations between attributes that exist based on a business rule






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






21. Grid View - Graph View - Grid/Graph View - SQL View






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






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






24. OLAP Services does not add any ______ to the report query.






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






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






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






28. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.






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






30. OLAP retains data ________






31. All Attributes must have an _______.






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






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






34. It contains the ID column of the parent attribute






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






36. Used to limit a possibly overwhelming set of potential prompt answers






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






38. You can _____________ in the Architect Graphical Interface.






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






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






41. Enables you to search for a specific Object or group of Objects that meet a certain criteria.






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






43. Attribute Creation Wizard - Attribute Editor






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






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






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






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






48. Extraction - transformation - loading






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






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