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. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).






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






3. OLAP data storage measure






4. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations






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






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






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






8. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities






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






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






11. Homogeneous - Heterogeneous






12. View Filters are saved with the _____________.






13. One that uses 2 or more columns as its ID






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






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






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






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






18. All report-level options overwrite ___________.






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






20. Used to "fine-tune" your Project






21. Must have Subtotals enabled - or you won't see any data for higher-level attributes






22. OLTP retains data ________






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






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






25. The Attribute Form maps to different column names in multiple tables






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






27. Extraction - transformation - loading






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






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






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






31. Used to create or edit complex attributes - facts - hierarchies - and logical tables






32. The default entry-points.






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






34. Create the Project Source - Create the Database Instance






35. Specifies a condition data must meet in order to be included in a report






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






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






38. The Attribute Form Expression that maps to a single column - no matter the number of tables






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






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






41. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View






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






43. Attribute Creation Wizard - Attribute Editor






44. All Attributes must have an _______.






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






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






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






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






49. Must have a one-to-one relationship with all other forms.






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