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. Filter definition prompts - Object prompts - Value prompts - Level prompts






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






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






4. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell






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






6. Metrics you create within a report using only those objects in the report.






7. It contains the ID and DESC columns of all higher-level attributes






8. OLTP data storage measure






9. Simple - Compound - Nested - Derived






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






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






12. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.






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






14. AND - OR - OR NOT - AND NOT






15. The default entry-points.






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






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






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






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






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






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






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






23. It contains the ID column of the parent attribute






24. Creating multiple attributes quickly. Used during the initial project creation.






25. It contains links to specific folders in the Folder List






26. Store info about attributes - including IDs and any descriptions. Used for easier browsing.






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






28. Used to "fine-tune" your Project






29. A shortcut to an existing Object in a Project






30. Schema Objects - Application Objects - Configuration Objects






31. Used to modify a Report






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






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






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






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






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






37. OLTP retains data ________






38. Groupings of directly related attributes. Also commonly known as "dimensions".






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






40. Less storage - Simple SQL - Complex ETL






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






42. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.






43. Attribute Creation Wizard - Attribute Editor






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






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






46. OLAP retains data ________






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






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






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






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